IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

How can we migrate data from VSAM to DB2
IBM Mainframe Forums -> Mainframe Interview Questions
Post new topic   Reply to topic Quick References
View previous topic :: View next topic  
Author Message
master_linux
Warnings : 1
New User


Joined: 17 May 2006
Posts: 1
Location: mumbai
PostPosted: Thu Aug 31, 2006 4:40 pm
 Reply with quote
Hello all ,

Can someone pls let me know way we can migrate data from VSAM to DB2 .
Please let me know exact way / methods to do that .

Also if anyone have tutorial please ......

Thanks ,

Tushar
Back to top
View user's profile Send private message
superk

Global Moderator


Joined: 26 Apr 2004
Posts: 4652
Location: Raleigh, NC, USA
PostPosted: Thu Aug 31, 2006 5:36 pm
 Reply with quote
First you need to REPRO the VSAM dataset to a sequential dataset and then load the sequential dataset into the table, provided that the table is created based on the VSAM dataset layout.

Check this link for a detailed explanation and examples of the IDCAMS REPRO command.

Check this link for a detailed explanation and examples of DB2 utility LOAD.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> Mainframe Interview Questions

 

Similar Topics
Topic Forum Replies
No new posts Store the data for fixed length COBOL Programming 1
No new posts Access to non cataloged VSAM file JCL & VSAM 18
No new posts Data set Rec-Cnt and Byte-Cnt Testing & Performance 2
No new posts SCOPE PENDING option -check data DB2 2
No new posts Check data with Exception Table DB2 0
Search our Forums:

Back to Top
IBMMainframes.com is not an official and/or affiliated with IBM® in anyway
Board Rules | FAQ | Downloads | Wiki | SiteMap | Contact Us