Can not run DB2LOAD in parallel

[nekiv90]

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!

[Pierre Saint-Jacques]

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!

[mirof007]

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

[nekiv90]

Thanks Pierre and Miro, I'll give it a shot!