DSXchange

Pretty straight-forward, actually. Read the chapter in the Server Job manual on the "Command Line Interface", everything you need should be in there. Its towards the end of Chapter 14 in mine. -craig Doris Zammit 12/04/2002 12:53 PM Please respond to datastage-users To: datastage-users@oliver.com cc...

Hello group,
We are trying to inititiate a Datastage job from a Unix shell
script...any suggestions would be appreciated....thanks,
Doris, Mike and Cliff

Craig, When we upgraded from v4.2 to v5.1, we had numerous issues with our existing projects that were upgrade. We decided to backup our projects prior to upgrade, then removed DataStage from the server. Although we executed the uninstall executable, we still had to manually remove some directories....

Ray, Thank you for the response. This issue was actually making my job fail. Last night, I just renamed all the longer stage & link names to shorter names. I will implement your suggestion today. Thank you, Tim PS: As a rule of thumb, should stage and link names be shorter than 41 character? "Ray Wu...

One of the comments Ray made set to thinking, once again, about a question I have so I thought I would pose it to the group. The comment was this: "This is mainly seen in sites where DataStage has been upgraded from earlier versions; fresh installs of DataStage 5.x should always use Type 19." Ive go...

Hi, Actually we are using Control-M to scheduller our DS jobs, and we have same problems because Control-M cant received DS log, so we will build an API that can call and execute the DS job, and pass the log information to the Scheduller tool. Anibody have any experience in this type of process ? Be...

Ray, That was a very eloquent explanation! Couldnt have done better myself!! Glenn At 02:58 AM 12/04/2002, you wrote: >This is an obscure artifact of the way that UniVerse works and, >consequently, that DataStage Engine works. There is a tiny, but subtle, >difference in the way your production syste...

This is an obscure artifact of the way that UniVerse works and, consequently, that DataStage Engine works. There is a tiny, but subtle, difference in the way your production system is set up from the way your development and test systems are set up. DataStage Engine can "see" a directory as a table....

This is a topic for an orphaned message.

hmm, im not sure that my previous e-mail answers your question, Ive send you the unix command for a running job. However this command works for a job not really running but always existing as a "phantom" on the unix server. It depends what do you mean by "locked job" : job having strange status afte...

Hi Mani, yes, that is a normal behaviour in DataStage when validating Jobs and I have met a lot of people who are as angry about it as you are. Me personaly I dont mind. If I write a Job which says: "clear table" then it should be cleared at least when I start the Job and this is what I designed. Bu...

ps -ef|grep DSD you obtain then a line with : user pid ppid date phantom DSD.RUN JobName JobParameters kasia At 07:43 03/12/2002, you wrote: >dear all > >running environment : DataStage5.2 on Unix >designer : on win2k server > >One of my job is locked on the datastage server. >now, I can get the PID...

Hi Tim, this is only a "helpfull" Warning which can only be prevented if you choose shorter names for the sum of Job and Stage. The truncation is found in the log-table for that you know everywhere wher IDENT2 is seen in reality IDENT20 is meant. Wolfgang -----Original Message----- From: tim_walsh@n...

Hi All, Ours is DS 5.x, Unix version. When I validate a job with DB stage with update action set to "Clear the table and insert rows", it actually clears the table contents. Is this the normal way "Validating a job behaves". >From the DS help, it is stated that "SQL SELECTS will be prepared" and tha...

Hello All, We created a job in our development environment and tested it in our test environment. Everything was perfect. We just migrated the job to our production environment and we get the following error: DataStage Job 541 Phantom 27192 File name "JOB.2128028722.DT.1275650346.V0S96.IDENT20" too ...