DB2Loader failed when no records

SPI · Post by **SPI** » Fri Dec 11, 2009 5:16 am

Hi all,
We've got an random issue with empty file to load in DB2 EEE 8.1.6 via DB2 UDB Enterprise stage.(AIX 5.x).
The job stay in the Running status.

Precisely, the job contains a dataset source, a copy stage (for the dsreport only) and the DB2 UDB Enterprise stage.

Do you have any idea ?

Regards

chulett · Post by **chulett** » Fri Dec 11, 2009 8:20 am

By 'random issue' do you mean that sometimes an empty file 'loads' and other times the job hangs?

SPI · Post by **SPI** » Fri Dec 11, 2009 9:13 am

Yes, this is the way Datastage PX runs

The job stay in Running status

peterzehwork · Post by **peterzehwork** » Thu Dec 31, 2009 3:03 am

Next time ask your friendly DB2 DBA to have a look if there are any locks on that table.