DSXchange

If DB2 UDB server is on the same machine as DataStage server, set Array Size to 1. Otherwise set Array Size to some multiple of (packet_size / row_size). Is there a large number of deletes? If not, set rows per transaction to 0, so that all the deletes form one transaction.

This has helped.. Thx

.....if you include -904 as fatal error in the stage, whenever it encounters a -904 from DB2, this job is going to fail. You can include all possible DB2 -SQL codes as either warnings or fatal errors. If included as warning, job contines fine, else it fails. Hope this helps. Hi Vijay, I am stuck in...

Hey Guys, the problem is resolved like this: I am not allowing the MSEQ to handle the failure of SEQ01. So as a result the MSEQ is finishes, triggerring the routine to send the status of SEQ01 to Tivoli. The SEQ01 anyhow is Restartable... So, now when I run the MSEQ again, the SEQ01 is restarted fro...

Ah... that would be because you are on a Windows server rather than a
UNIX one. Substitute 'AT' for 'cron' in my previous message.

Now what is AT

Hey Chulett, Let me stress on the requirement for which I need to send the status of the controlling sequence, which is this: BUT the problem comes when a job is not even Triggerred , due to say Time Out Error ( Error Code = -14 ).. the Job's finishing status is never published... I donot understand...

Tivoli is not triggerring this job. The job is being scheduled from DataStage Director itself.. Actually, I need to sedn the status if each job to Tivoli, for the Production Support Team. Now For this I have created a After Job Routine and attached it to each job. So the finishing status of each job...

Hi, I am stuck in problem, which is as follows: I have a sequence job, called as Master Sequence, SEQ01. The SEQ01 has following flags set: 1. Add checkpoints so sequence is restartable on failure. 2. Automatically handle activities that fail~ So, in the above case, if a any job or job sequences ins...

It is most certainly a bug, I know I had a ticket open for that and ended up having to code a recursive routine to get the whole "family" of a job's parents. I have also written a recursive routine to get the to the immediate controller.... because I was not getting the results as mention...

Am sorry,

I dont understand this please..

Please guide me for the usage of COUNT.SUP ?

What is the syntax ??

Thx..

Am sorry,

I dont understand this please..

Please guide me for the usage of COUNT.SUP ?

What is the syntax ??

Thx..

How to supress the number of records listed count ??

If possible, Please share where are these commands documented ??

Thanks

How to supress the number of records listed count ??

If possible, Please share where are these commands documented ??

Thanks

Hi, In a custom before job routine , I am determining the Controller of the job, using DSGetJobInfo(JobHandle, DSJ.JOBCONTROLLER). Acoording to DSbooks, Name of the job controlling the job referenced by the job handle. Note that this may be several job names separated by periods if the job is contro...

Hi, I am executing the below command from a before stage routine... SELECT CATEGORY FROM DS_JOBS WHERE NAME = 'TestTivoli'; the result contains Category............Testing\Tivoli\JobsNSeq1 records listed. Now I want the remove Category............ , for this I am using CHANGE function to remove it.....

Hi, I am executing the below command from a before stage routine... SELECT CATEGORY FROM DS_JOBS WHERE NAME = 'TestTivoli'; the result contains Category............Testing\Tivoli\JobsNSeq1 records listed. Now I want the remove Category............ , for this I am using CHANGE function to remove it.....