By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,611 Members | 2,296 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,611 IT Pros & Developers. It's quick & easy.

Can not run DB2LOAD in parallel

P: n/a
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
Share this Question
Share on Google+
3 Replies


P: n/a
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

P: n/a
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

P: n/a
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.