read data from DB2 API Stage (iSeries) job hanging

[mjakubo]

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 data" button in stage gives a result as well.
But when I run the job, the link2 get blue (active) in Designer but link1 get not active and job hang.
When I changed the SQL with join of 3 tables the job run. I tested as well another comibation of 3 tables from my starting script and the job run as well.

Every hint will be helpfull.

mjakubo

[Minhajuddin]

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?

[mjakubo]

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, worked within half a minute)
- I made another check and used ODBC_Enterprise stage with same SQL which do not work in API-stage, and the job run as well.

May be somebody can give a hint/idea how to analyse the error. Because the job hung I get no error message or something else.

Thanks,
Mjakubo

[mjakubo]

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

[Minhajuddin]

Cool, Time to mark the post as "Resolved" then