Page 1 of 1

DB2 Bulk Load...a few questions

Posted: Fri Oct 24, 2008 4:08 pm
by jpr196
Hi All,

I have a few questions regarding the DB2 Bulk Load Stage. We've been using the Bulk Load on the end of a process that has been disrupted more than two times now and every time the job aborts, the sequential file disappears! Is this a known issue with the bulk load stage or is there a setting I'm missing. Here are some of the more important parameter settings in the stage:
Load Method: Sequential file
Load Immediate: No
Load from client: Yes
Remove Intermediate File: No (was originally set to yes and file disappeared as well)

Another issue I've found with the Bulk Load Stage is that it appears to be much slower (approximately 3 times slower) than just writing the data to a sequential file. This doesn't make sense to me as isn't that what the Bulk Load Stage is essentially doing anyway? Am I missing something here that would help our performance/recoverability?

Thanks