How to load a DB2 table from one DB2 subsystem to another?

mathukumar · New User Joined: 20 Aug 2009 Posts: 3 Location: chennai

Hi, can anyone tell me how to load a table using jcl from one DB2 subsystem to another DB2 subsystem? For example, now am in db2 subsystem DBJA and my jcl is also present in DBJA; now i need to load a table which is present in DB2 subsystem DBJB.

dick scherrer · Posted: Thu Aug 20, 2009 8:50 am

Hello and welcome to the forum,

Suggest you unload the data to shared dasd on the A system and run the corresponding load on the B system. If there is no shared dasd or you are not permitted to use it, you might use tape instead. . .

mathukumar · New User Joined: 20 Aug 2009 Posts: 3 Location: chennai

I have the dataset in A system, can i run the load in A system to load the table in B system?

dick scherrer · Posted: Fri Aug 21, 2009 2:14 am

Hello,

You should submit the load on system B. It should not matter where the transient dataset resides (assuming shared dasd).

mathukumar · New User Joined: 20 Aug 2009 Posts: 3 Location: chennai

Hi thanks for the information, But i would like to know, is there any posibility to submit the load on A subsystem to load the table in B subsystem....

dick scherrer · Posted: Sat Aug 22, 2009 12:20 am

Hello,

Suggest you speak with your DBA. . . .

satyender · Posted: Sat Aug 22, 2009 4:46 am

mathukumar,

First unload the data from DBJA environment using UNLOAD JCL.
Then log into DBJB, use the SYSREC dataset of UNLOAD JCL in LOAD JCL as input dataset and LOAD the data.

Check the region name while you are loading.
Otherwise you may replace the table in another region.

dick scherrer · Posted: Sat Aug 22, 2009 7:40 am

Hello,

This is what mathukumar has said is not wanted. . .