Page 1 of 1

Loading multiple tables using REXX

PostPosted: Mon May 24, 2010 7:31 am
by djprakash1
Hi,

I need to load around 100 tables simultaneously. Is this possible using REXX?
If so, please explain how this can be acheived.

Any hints will help.

Regards,
David

Re: Loading multiple tables using REXX

PostPosted: Mon May 24, 2010 8:59 am
by dick scherrer
Hello and welcome to the forum,

Please explain why you believe this should happen simultaneously. . . It probably should not - fwiw. . .

What is being loaded? Are these tables all in the same db2 subsystem? How many rows are being loaded?

Re: Loading multiple tables using REXX

PostPosted: Tue May 25, 2010 12:38 am
by djprakash1
Hi Dick,

This is a repeated exercise in my project as I have to refresh the tables to start a new test.

Probably I used an incorrect term. When I said "simulataneously" - I meant - I should have once single REXX code, if triggered will kick-off my table loads.

Yes all the tables are in the same DB2 subsystem.

Each table has around 50000 rows.

Regards,
David

Re: Loading multiple tables using REXX

PostPosted: Tue May 25, 2010 12:59 am
by dick scherrer
Hi David,

If this was something i needed to do, i'd create 4 sets of jcl that load 25 tables each. Then, when i needed to reload the data, i'd submit the 4 jobs (assuming that the system support people have no problem with using 4 batch processes at the same time). The good news is that this should run rather quickly.

I'm not sure where rexx provides something useful :?