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
 

 

VSAM TO DB2 CONVERSION

 
Post new topic   This topic is locked: you cannot edit posts or make replies.    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
VNAG

New User


Joined: 03 Nov 2011
Posts: 2
Location: India

PostPosted: Thu Nov 03, 2011 12:31 pm    Post subject: VSAM TO DB2 CONVERSION
Reply with quote

icon_neutral.gif
Back to top
View user's profile Send private message

VNAG

New User


Joined: 03 Nov 2011
Posts: 2
Location: India

PostPosted: Thu Nov 03, 2011 12:38 pm    Post subject:
Reply with quote

Hi All,
In my project we are converting VSAM to DB2. I need some suggestion like, which one would be the best way, wheather loading the table using load utlity or writing a code, which would insertin to table. Also, is that possible to use the VSAM file directly as load file!!!
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7225

PostPosted: Thu Nov 03, 2011 12:44 pm    Post subject: Reply to: VSAM TO DB2 CONVERSION
Reply with quote

This is a "planning" thing. If you already "are converting" (not "will be converting") you've left it a bit late.

Have a look at the DB2 manuals. See what it recommends for situations to use the load utilities (just a guess, but loading from scratch might be one of them). Also see if there is some way you can stuff a VSAM file into some utility and get something meaningful out.
Back to top
View user's profile Send private message
VNAG

New User


Joined: 03 Nov 2011
Posts: 2
Location: India

PostPosted: Thu Nov 03, 2011 12:54 pm    Post subject: Reply to: VSAM TO DB2 CONVERSION
Reply with quote

Hi, Thanks for your suggestion, project is in design stage. It would be greatly helpful, if some can give input on this. Thanks in advance

Note : It is a one time conversion process!!!!
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Thu Nov 03, 2011 2:26 pm    Post subject:
Reply with quote

vsam to db2 conversion
provides about 576,000 Google results.
Back to top
View user's profile Send private message
VNAG

New User


Joined: 03 Nov 2011
Posts: 2
Location: India

PostPosted: Thu Nov 03, 2011 2:48 pm    Post subject:
Reply with quote

dbzTHEdinosauer wrote:
vsam to db2 conversion
provides about 576,000 Google results.


Yes, Thanks , But most of them leading to a product for this, no actual solution was provided. Any ways,now we have decided to go with, load job to load the table. As loading the table through program consumes huge CPU time. Inputs are welcomed..Thanks
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Thu Nov 03, 2011 3:05 pm    Post subject:
Reply with quote

instead of wasting time to pick a tool/method to perform the conversion,

time needs to be taken for design.

now, if you want to use the old (very stupid and wasteful) method of direct conversion of vsam record to db2 row,
IBM has many documents (some of the 576,000 you decided not to read)
covering this very topic, since so many sites decided to go the cheap image to image conversion.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Thu Nov 03, 2011 3:08 pm    Post subject:
Reply with quote

i apologize.
i forgot that this website is to provide free information to people
who know little or nothing about performing their job
and have few if any skills,
so that they can use others' experience and effort to get a paycheck.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10202
Location: italy

PostPosted: Thu Nov 03, 2011 3:09 pm    Post subject: Reply to: VSAM TO DB2 CONVERSION
Reply with quote

the question as posed belongs to the beginners forum!
I strongly suggest that You might be more at ease there
here
http://ibmmainframeforum.com/index.php

topic locked to prevent useless waste of resources
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   This topic is locked: you cannot edit posts or make replies.    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 File Aid to File Manager conversion murali3955 IBM Tools 4 Thu Nov 24, 2016 3:41 pm
No new posts BWO option in VSAM blayek CICS 3 Sat Nov 05, 2016 10:47 am
No new posts Conversion of a VB file to FB. isssal DFSORT/ICETOOL 1 Mon Oct 31, 2016 10:23 pm
No new posts VSAM define for large file jerryte JCL & VSAM 9 Wed Oct 05, 2016 1:51 am
No new posts CICS VSAM RLS READ akodakka CICS 3 Tue Oct 04, 2016 3:09 pm


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