What's have a better performance to do a DB2 Load by ServerJob or ParallelJob?
Regards,
Fernando
DB2 Load by ServerJob or Parallel
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 142
- Joined: Wed Mar 24, 2004 10:51 am
- Location: Brazil
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.
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.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
-
- Participant
- Posts: 142
- Joined: Wed Mar 24, 2004 10:51 am
- Location: Brazil
Thanks!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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: