468,532 Members | 1,643 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

Can not run DB2LOAD in parallel

Greetings,

We need to initial load hundreds of tables from within programs. We try
to run several programs that call the DB2LOAD in parallel (to load
different tables of course) in order to speed up the process.

However, the program that completes the DB2LOAD first appears to cancel
the subsequent DB2LOAD by other programs. No obvious error found in
db2diag.log.

Has anyone come across this?

Thanks!

Nov 12 '05 #1
3 1519
You can run parrellel loads as long as each of them adresses a different
tablespace.
Also, you must use the TEMPFILES parm. in the load command to point to a
separate temporary files directory for each load that runs in parellel.
You must be at V7.2 or up.
HTH, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
<ne*****@hotmail.com> a écrit dans le message de news:
11*********************@g47g2000cwa.googlegroups.c om...
Greetings,

We need to initial load hundreds of tables from within programs. We try
to run several programs that call the DB2LOAD in parallel (to load
different tables of course) in order to speed up the process.

However, the program that completes the DB2LOAD first appears to cancel
the subsequent DB2LOAD by other programs. No obvious error found in
db2diag.log.

Has anyone come across this?

Thanks!


Nov 12 '05 #2
ne*****@hotmail.com wrote:
Greetings,

We need to initial load hundreds of tables from within programs. We try
to run several programs that call the DB2LOAD in parallel (to load
different tables of course) in order to speed up the process.

However, the program that completes the DB2LOAD first appears to cancel
the subsequent DB2LOAD by other programs. No obvious error found in
db2diag.log.

Has anyone come across this?

Thanks!


What is the sqlcode returned by the failed loads? You might need to
check the message file to find it. Assuming you're on Version 8 of DB2
UDB for L/U/W, make sure you're not specifying the FORCE option with
your load commands.

Regards,
Miro

Nov 12 '05 #3
Thanks Pierre and Miro, I'll give it a shot!

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

11 posts views Thread by lovecreatesbeauty | last post: by
reply views Thread by Suresh | last post: by
reply views Thread by anils | last post: by
7 posts views Thread by Vivek | last post: by
2 posts views Thread by Vivek | last post: by
reply views Thread by Vivek | last post: by
reply views Thread by NPC403 | last post: by
1 post views Thread by fmendoza | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.