467,199 Members | 981 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,199 developers. It's quick & easy.

DB2 load utility and subsytem

Hi All,

I am trying to load a table in one subsytem with QREP ON using DB2 UTILB.Will this load affect any other parallel load on the other subsytem even if i wont be loading into the other subsystem? If it does is it specific to the utility or is there any option i can specify so that i dont bring down the other subsytem as well.

Thanks,
Deepa
Jul 30 '07 #1
  • viewed: 3120
Share:
2 Replies
Hi All,

I am in a similar situation - need to do bulk loads (10 million records) in tables which are QREP'ed. My application has Peer to Peer QREP. I plan to use UTILB with LOG YES and RESUME YES and also will have QREP off for the load job (by adding jobname in the Ignore Transaction table). I will be loading on both the sites. Please let me know if anyone has done similar loads. Thanks!

Regards,
Gaurav
Aug 1 '07 #2
Hi,

I have loaded a QREP'ed table using UTILB (RESUME NO REPLACE) and it worked fine. I loaded the table on both my sites and the QREP CAPTURE did not interfere with the Utility.

Regards,
Gaurav
Aug 6 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Rick | last post: by
3 posts views Thread by claus.hirth@abraxas.ch | last post: by
6 posts views Thread by jrthor2 | last post: by
1 post views Thread by huyuhui@gmail.com | last post: by
reply views Thread by Eric Davidson | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.