DSXchange

@ray: My understanding is, that invocation id makes instances of job unique when using "Allow Multiple Instances". Within the job design the invocation id is not used. I checked the Jobinfo and got the following result: -- Job runs fine Job Status : RUN OK (1) Job Controller : MasterJobBDW...

have somebody a hint for me, how I can analyse the problem, because I have no further idea on than issue.

At the moment it looks like the error occur if the invocationid is .FLXY the invocationid .FLXN works fine. Then Y/N-value is set for monthly run.

At the moment it looks like the error occur if the invocationid is .FLXY the invocationid .FLXN works fine. Then Y/N-value is set for monthly run.

the autopurge option is not activated for that job.

Hello all, I have a strange problem. One of your multiple instance jobs sometimes don't do anything. The job runs with no warning and no error, but he doesn't write any data as well. After resetting the job he runs well and writes the data fine. The only hint I found is a shorter joblog when the job...

Hi All,

I don't know really why but the job worked fine now. I created new DB2_API stage and used custom SQL and created column by load of saved column list and the error was gone. Strange.

Thanks

Try replacing the DB2 API stage with a row generator stage. This will filter out other possibilities for this behavior. Also, how may records do you expect for your query? Hi Minhajuddin, - yes row generator stage worked fine (and API with join of 3 tables as well) - 250k records (when job run, wor...

Hi, I have a problem with hanging job reading data from DB2 API Stage from iSeries. For testing I created a simple job: db2_stage,link1, transformer, link2, ds_file. The SQL within the db2_stage contains a join of four tables and works fine in Navigator (native ODBC tool for iSeries). The "View...

Hi, there is a problem with a new DS installation on AIX, I this some parameter or configurations are wrong / missing. I can create a server job and the job worked fine. When create the same process as parallel job I get no error but no data are transferred. Job is doing a copy from DB2 stage to dat...