Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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 Loading data to table gives wrong for... Raghu navaikulam DB2 18 Thu Jul 13, 2017 2:11 pm
No new posts Db2 load job abending in SORT mistah kurtz DB2 4 Mon Jun 05, 2017 3:58 pm
No new posts Cobol upgrade - source code missing f... gthmrj IBM Tools 1 Wed Apr 26, 2017 6:04 pm
No new posts unload data from table with lob columns farhad_evan DB2 1 Sat Apr 22, 2017 1:32 pm
No new posts Copy load modules and alias vasanthz IBM Tools 5 Thu Apr 20, 2017 6:31 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us