DB2 Bulk Loader Stage
Posted: Wed Dec 01, 2004 3:09 am
Loading a flatfile with fixed width columns. We have to use the Bulk Loader Stage, since the normal DB2 stage only loads at 80 rows per second. The Bulk Loader stage reaches up to 800 rows per second.
The problem is that the job will load all the records in the DB2 table, but will not Finish. The job will keep on "Running" although there is no more records loaded to the DB2 Database table.
Hows does one monitor the load process via DataStage e.g test DBMS return codes (link variables)?
:D Any help on this would be greatly appreciated.
The problem is that the job will load all the records in the DB2 table, but will not Finish. The job will keep on "Running" although there is no more records loaded to the DB2 Database table.
Hows does one monitor the load process via DataStage e.g test DBMS return codes (link variables)?
:D Any help on this would be greatly appreciated.