DSXchange

Posted: **Fri Mar 23, 2007 12:33 pm**

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

Regards,

Fernando

Posted: **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.

Posted: **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!

Posted: **Fri Mar 23, 2007 5:47 pm**

Are you loading a partitioned DB2 table?