View previous topic :: View next topic
|
Author |
Message |
VNAG
New User
Joined: 03 Nov 2011 Posts: 2 Location: India
|
|
Back to top |
|
|
VNAG
New User
Joined: 03 Nov 2011 Posts: 2 Location: India
|
|
|
|
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 |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
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 |
|
|
VNAG
New User
Joined: 03 Nov 2011 Posts: 2 Location: India
|
|
|
|
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 |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
vsam to db2 conversion
provides about 576,000 Google results. |
|
Back to top |
|
|
VNAG
New User
Joined: 03 Nov 2011 Posts: 2 Location: India
|
|
|
|
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 |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
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 |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
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 |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
the question as posed belongs to the beginners forum!
I strongly suggest that You might be more at ease there
here
ibmmainframeforum.com/index.php
topic locked to prevent useless waste of resources |
|
Back to top |
|
|
|