DSXchange

Since yesterday weve got a problem with all jobs that make a connection to Oracle. We get this message: CheckFileExists..Dummy: Oracle Error - OCI_INVALID_HANDLE ORA-12154: TNS:could not resolve service name Weve checked all settings but it looks like nothing has been changed since last time when it...

This is a topic for an orphaned message.

Dave, Usually I regard approaches via private email to be seeking to engage my professional services. However, here are some short answers. An export from DataStage is only of the metadata in the Repository; it can be done safely if no design objects are opened for update (that is, if nothings open ...

Hi, While trying to copy a file from one folder to another folder I get the following message " Write caching disabled" and the file is not copied. I am using DataStage6 on UNIX. I am able to copy among the folders in UNIX using the cp command.Are there any environment variables that need to be set ...

Steve DataStage sets on top of Universe. Universe is just like any other database in that if you backup while it is active then you might get a partial transaction. This is what corrupts files. The safest way is to do exports. Even exports have problems if you are in the Designer when you try to exp...

Hi Karl, We have found out the hard way, We are looking for a backup strategy that works with datastage, anyone have any ideads? Steve -----Original Message----- From: Karl [mailto:karl@karltech.co.uk] Sent: 19 June 2003 16:47 To: datastage-users@oliver.com Subject: Re: Backups and Restores corrupti...

Steve, you are correct, and can only do this with a reinstall. regards Karl ----- Original Message ----- From: "Elsender, Steve" To: Sent: Thursday, June 19, 2003 4:16 PM Subject: RE: Backups and Restores corrupting Dstage jobs > Karl, > > In our experience if the project directory exists, administr...

Karl, In our experience if the project directory exists, administrator will not allow you to add a project with the same name. Consider, if the project is /datastage/prod removing the project "prod" also removes the directory /datastage/prod. In order to restore this directory it has to exist and if...

Lawrence, from my experience, if you are going to use a copy of a datastage project as a means of backup rather than dsx. To restore a project you should first use the administrator to delete the project. This will delete the corrupt directory structure as well as the pointers. Restore the project d...

Thanks Kim/Ray Were going to create a new project and restore from a .dsx export file. Then delete the corrupted project. Many thanks for your help.. Lawrence... -----Original Message----- From: Ray Wurlod [mailto:rayw@mindless.com] Sent: 19 June 2003 02:05 To: datastage-users@oliver.com Subject: Re...

Oh dear. My guess is that youve done some work in the project since it was backed up, then restored the backup over the top of the existing project. This is pretty much guaranteed to corrupt the hashed files in the Repository, since their internal structure is not visible to operating system backup/...

The SLEEP statement in DS BASIC can also allow you to specify to sleep to a particular time. For example, if you had a controlling job that was scheduled to start at 23:30 each day, you might set up the following loop. For Hour = 0 To 23 NextStartTime = Fmt(Hour, "R#2") : ":00" Sleep NextStartTime h...

See also m ----- Original Message ----- From: "Babatunde.Ebohon" Date: Wed, 18 Jun 2003 08:57:46 -0500 To: Subject: Assigning surrogate keys from within Data stage to a table > > Can someone help me out on this. i want to assign surrogate keys ( unique sequence keys ) to my table. How do i go about ...

Hi, im running into this issue on Datastage PX 6. each time i run into this error, i cant seem to be able to add a table definition to a link. The error is ( 40503 - A call to the OLE server has failed, or a runtime error occurred within the OLE server itself Also, how can i find out what caused a p...

Hi DataStage supports the use of stored procedures with or without input arguments and the creation of a result set, but does not support output arguments or return values. A stored procedure may have a return value defined, but it is ignored at run time. A stored procedure may not have output param...