DB2 Load by ServerJob or Parallel

fmartinsferreira · Post by **fmartinsferreira** » Fri Mar 23, 2007 12:33 pm

What's have a better performance to do a DB2 Load by ServerJob or ParallelJob?

Regards,

Fernando

DSguru2B · Post by **DSguru2B** » Fri Mar 23, 2007 12:59 pm

If your referring to the bulk load stage then both would be the same I suspect. I dont have any test results to back it up. But technically both use DB2's bulk utility. Hence it should be the same.
If your talking about the DB2 API stage and DB2 enterprise stage then the latter is way way faster as it utilizes parallism and loads tables in partitions. I believe vmcburney has a blog on it. Search for his name and go to his blog from his footer signature.

fmartinsferreira · Post by **fmartinsferreira** » Fri Mar 23, 2007 2:50 pm

DSguru2B wrote:If your referring to the bulk load stage then both would be the same I suspect. I dont have any test results to back it up. But technically both use DB2's bulk utility. Hence it should be the same.
If your talking about the DB2 API stage and DB2 enterprise stage then the latter is way way faster as it utilizes parallism and loads tables in partitions. I believe vmcburney has a blog on it. Search for his name and go to his blog from his footer signature.

Thanks!

ray.wurlod · Post by **ray.wurlod** » Fri Mar 23, 2007 5:47 pm

Are you loading a partitioned DB2 table?