We a simple job of dataset to Table Bulk load using DB2 connector bulk load without any other stages . This has around 4 millon records and the load time is around 25 mins . When we run the same through DB2 Load utility its takes only 4 mins ??
So my question here is does Datastage bulk load internally use the same DB2 load utility , if yes whats the difference betweem both ???
The option I have used are
Load mode - Isert
Load method - Named Pipe
NON RECOVERABLE - yes
Is there anything esle that can be done to imporve performace like buffering etc..
Datastage DB2 Bulk load vs DB2 load utility
Moderators: chulett, rschirm, roy
Re: Datastage DB2 Bulk load vs DB2 load utility
changing File Type option seems to have resolved the issue , after changing it from ASC to DEL the Load completed in nearly 4 mins ..same as DB2 load .
Though am still not clear ,when to use DEL and when to use ASC
Though am still not clear ,when to use DEL and when to use ASC
Re: Datastage DB2 Bulk load vs DB2 load utility
Hi nishantrk
DataStage uses the regular DB2 Load utility.
I am a littl e surprised about the different durations you saw but DEL (Delimited ASCII) would always be my choice as ASC is only used when you get data in that format.
Of cause differnt options can have a performance impact.
Try to use API load (instead of CLI load) if you do not process XML and LOB data.
Make sure you talk to your DBA about the recovery options.
DataStage uses the regular DB2 Load utility.
I am a littl e surprised about the different durations you saw but DEL (Delimited ASCII) would always be my choice as ASC is only used when you get data in that format.
Of cause differnt options can have a performance impact.
Try to use API load (instead of CLI load) if you do not process XML and LOB data.
Make sure you talk to your DBA about the recovery options.
regards
Michael
Michael