DSXchange

You don't get such specific information w.r.t different stages in the job log.

Run your Stored Procedure outside Datastage and check how long it takes.
Then you can find out as to where your problem is occuring.

xinhuang66 wrote:what I want to get is the job log information for the finished job ?

Is developing a job routine the only way to get it ??

Yes, as Ray already specified above.

Yes, check the "Add checkpoints so sequence is restartable on failure"
in the Compilation Options of the Job Sequence.

ray.wurlod wrote:General probably IS the appropriate forum, since the answer will be the same irrespective of job type.

Gave it a thought, don't know why I still posted it Guess I had a long day..

Dooh.. late...

xinhuang66,
Moving forward, please post in appropriate forum.

Use the Notification activity in the Job Sequence.
Check the "Include job status in email", you should get what you want.

please help me Gurus, from where i can get the actual value. In DS Administrator, where you set up the default values. Not sure if you can get this information from dsjob -paraminfo. Environment Variable is more a global thing than specific to a job. Would be interesting if somebody know how to get...

vijaykumar wrote:This is my requirement, my teamlead wants t o know information from the operating system.

You have a tough Team Lead

Compile your job and try again.
If not try searching for Status code = -1004 here
You should have get your answer.

Looks like this is an one of those unresolved issues

If you are using Environment Variables you should be passing the parameters like this #$DSCAPIOP__DB2DSN#
I am sure you would have already used this - default value as $PROJDEF in your job parameters

Looks like you are using '1' (One) instead of 'l' (Alphabet l)

Use

not


Or was it a typo?

Don't use [useid]
Try

Try reading it using a hex editor like UltraEdit or xvi32 and check if you see something different.