IBM Mainframe Forum

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

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?

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

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