DB2 Load row limit
Posted: Mon Jul 11, 2005 6:46 pm
G'day,
I am trying to load a DB2 database with a volume of rows in the order of 7.5 million.
When using DB2 'load' (as opposed to 'write') not all my rows are being inserted into the database. From what I can tell, only the first 70000 rows (exactly) are loaded. DataStage statistics, and the Director log, indicate that all 7.5 million rows have been passed to the stage.
Note: When using 'write' to insert rows there is no problem. However the job runs too slowly for our needs.
Has anyone encountered this problem using DB2 load and what was your final solution?
Zac.
I am trying to load a DB2 database with a volume of rows in the order of 7.5 million.
When using DB2 'load' (as opposed to 'write') not all my rows are being inserted into the database. From what I can tell, only the first 70000 rows (exactly) are loaded. DataStage statistics, and the Director log, indicate that all 7.5 million rows have been passed to the stage.
Note: When using 'write' to insert rows there is no problem. However the job runs too slowly for our needs.
Has anyone encountered this problem using DB2 load and what was your final solution?
Zac.