DSXchange

Hi We are getting following error Status code = -14 DSJE_TIMEOUT Error Return from ascential job with error code 255 consistently on random jobs when tried to run at same time. Those jobs which got aborted have one thing in common, they all read files from disk. The number of jobs aborted at the sam...

Hi, I have a job which is executed as a multiple instance. Say I have this job named as 'JobA'. Say its 5 instances were run 1...10 like JobA.1 JobA.2 . . JobA.10 My log gets cleared say after 3 runs of JobA, then I could see logs for last 3 as JobA.8, JobA.9, JobA.10. Cant we see last 3 logs for ev...

Is there any option available which will compile jobs from subcategories, than individually specifying a subcategory?

I have tried doing that by seeing options for dscc. It mentions something for categories 'cat\*'. This doesn't helps, as I have tried multiple combinations by giving category names at different places.

I am uaing dscc jobs to compile uncompiled jobs in the given environment. But I could not find an option which can mention, to compile jobs under a particular category.

Could someone, if used can share how this can be done?

When we perform 'select nextval...' on the DB2 table for particular column, we need to have DB2 table locked, which we can mention in Open command. So no other process should get max id until this recently generated id is inserted. Once this record is inserted via next DB2 EE stage then in the close...

We are using DB2 database has dpf (dynamically partitioned feature) enabled. Our Px job say JobA has multiple invocation enabled. For an incoming record if surrogate id is created based on if previously generated. In the next stage this id generated gets stored into the database. When job is called ...

You are pointing to which I am afraid of. If I wait all datasets are written & then appended then I need to allocate the 2ce the node space. One is for all individual datasets & other for combining all datasets. Also in this approach, there will be a wait time untill all datasets are written...

cd $DSHOME/bin
orchadmin delete datasetname

Hi We have a DataStage job which allows its multiple invocations. This job is expected to append a DataSet. Now my question is there could be a possibility at a given instance of a time we may have 5 instances of this job running together, which will try to append same DataSet. Even though DataSet s...

In the transformer, at derivation we just mention the 'System Environment Variable'. Say parameter user is defined with PROJDEF, then it is sourced in at Job parameter as, $user. In the transformer derivation for this particular coulmn, mapping derivation is just $user. It gives error only after, we...

We have some params defined in the project definition. We use those in our job by using $ qualifier. It works fine for stages like sequential file, DB stage. But it seems it do not work for Px Tansformer derivation. We get complilation error if system variable is used in the Px derivation. Can someo...

Yes, I used thomsomps method.

I set, 'Abort after rows = 1', for failure condition. It aborts the job.

Thanks.

Hi

In my Px job, after some condition in transformer is evaluated false, I want that DataStage job to abort. It should not execute further stages. Can someone suggest me what is the way out of this?

Thanks in advance.

Hi

I have found the solution. I used this function called 'JulianDayFromDate
'. This returned me an integer & comparison worked out to be as expected.