Loading multiple tables using REXX



IBM's Command List programming language & Restructured Extended Executor

Loading multiple tables using REXX

Postby djprakash1 » Mon May 24, 2010 7:31 am

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
djprakash1
 
Posts: 2
Joined: Mon May 24, 2010 7:26 am
Has thanked: 0 time
Been thanked: 0 time

Re: Loading multiple tables using REXX

Postby dick scherrer » Mon May 24, 2010 8:59 am

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?
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: Loading multiple tables using REXX

Postby djprakash1 » Tue May 25, 2010 12:38 am

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
djprakash1
 
Posts: 2
Joined: Mon May 24, 2010 7:26 am
Has thanked: 0 time
Been thanked: 0 time

Re: Loading multiple tables using REXX

Postby dick scherrer » Tue May 25, 2010 12:59 am

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 :?
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times


Return to CLIST & REXX

 


  • Related topics
    Replies
    Views
    Last post