Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
How to load a DB2 table from one DB2 subsystem to another?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
mathukumar

New User


Joined: 20 Aug 2009
Posts: 3
Location: chennai

PostPosted: Thu Aug 20, 2009 8:12 am    Post subject: How to load a DB2 table from one DB2 subsystem to another?
Reply with quote

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.
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Aug 20, 2009 8:50 am    Post subject:
Reply with quote

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. . .
Back to top
View user's profile Send private message
mathukumar

New User


Joined: 20 Aug 2009
Posts: 3
Location: chennai

PostPosted: Thu Aug 20, 2009 10:36 pm    Post subject:
Reply with quote

I have the dataset in A system, can i run the load in A system to load the table in B system?
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Aug 21, 2009 2:14 am    Post subject:
Reply with quote

Hello,

You should submit the load on system B. It should not matter where the transient dataset resides (assuming shared dasd).
Back to top
View user's profile Send private message
mathukumar

New User


Joined: 20 Aug 2009
Posts: 3
Location: chennai

PostPosted: Fri Aug 21, 2009 11:15 pm    Post subject: Reply to: How to load a DB2 table from one DB2 subsystem to
Reply with quote

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.... icon_lol.gif
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sat Aug 22, 2009 12:20 am    Post subject:
Reply with quote

Hello,

Suggest you speak with your DBA. . . .
Back to top
View user's profile Send private message
satyender

New User


Joined: 05 Jan 2008
Posts: 50
Location: Olympia, WA, USA

PostPosted: Sat Aug 22, 2009 4:46 am    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sat Aug 22, 2009 7:40 am    Post subject:
Reply with quote

Hello,

This is what mathukumar has said is not wanted. . .
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Update table without cursor Ron Klop DB2 3 Wed Oct 11, 2017 1:06 pm
No new posts Table(Unicode(Graphic) table) loading... muralikrishnan_new DB2 0 Thu Oct 05, 2017 5:10 pm
No new posts Insert a Row_number into table useit DB2 2 Tue Sep 19, 2017 1:07 pm
No new posts how to see when the last read access ... Mike 1304 DB2 1 Tue Sep 12, 2017 7:52 pm
No new posts PC (UTF-8) -> z/OS (EBCDIC) -> ... prino All Other Mainframe Topics 4 Fri Sep 01, 2017 1:47 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us