View previous topic :: View next topic
|
Author |
Message |
Virendra Shambharkar
New User
Joined: 26 Aug 2015 Posts: 55 Location: India
|
|
|
|
Hi,
Can you suggest some tools for ISAM to DB2 conversion.
Also can you let me know what things will need to be considered for ISAM to DB2 conversion.
Also if the conversion can happen in one go or it has be done in a phased manner.
Thanks for your responses.
Thanks,
Virendra |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10888 Location: italy
|
|
|
|
ISAM |
|
Back to top |
|
|
daveporcelan
Active Member
Joined: 01 Dec 2006 Posts: 792 Location: Pennsylvania
|
|
|
|
Quote: |
Can you suggest some tools for ISAM to DB2 conversion.
|
I highly doubt there will be any 'tools' available for this. You will have to write a series of Conversion Programs to accomplish this.
Quote: |
Also can you let me know what things will need to be considered for ISAM to DB2 conversion. |
You will have to consider the layout of each ISAM file.
Should each file become a DB2 table, or should files be split or combined?
What are the relationships between each file? Which are parents, which are children? What indexes are needed? What foreign keys are needed?
Quote: |
Also if the conversion can happen in one go or it has be done in a phased manner. |
This should be carefully planned, and should take a while to complete.
It took our shop several years to successfully convert from VSAM to DB2. |
|
Back to top |
|
|
Pete Wilson
Active Member
Joined: 31 Dec 2009 Posts: 592 Location: London
|
|
|
|
Is this an interview question? Has to be from someone with a keen sense of humour. Coincidental that there's been two ISAM queries recently. |
|
Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3076 Location: NYC,USA
|
|
|
|
ISAM to DB2 migration should be mirrored as VSAM as they should be similar programs else talk to IBM and get the suggestions.
Do you have an ER diagram corresponds to ISAM file relations as yet?, if not then it is no good to even think how this can be done asdaveporcelan said clearly few of the important points. |
|
Back to top |
|
|
Virendra Shambharkar
New User
Joined: 26 Aug 2015 Posts: 55 Location: India
|
|
|
|
Thanks all for the replies.
I have come across an IBM tool CICS VSAM Transparency which does a VSAM to DB2 migration . What I want to know if this tool is only for VSAM to DB2 Z/OS migration or this can be used for VSAM to DB2 LUW migration as well.
Thanks,
Virendra. |
|
Back to top |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009 Posts: 2481 Location: Netherlands, Amstelveen
|
|
|
|
Quote: |
I have come across an IBM tool CICS VSAM Transparency which does a VSAM to DB2 migration . What I want to know if this tool is only for VSAM to DB2 Z/OS migration or this can be used for VSAM to DB2 LUW migration as well. |
Why don't you read the documentation? |
|
Back to top |
|
|
Virendra Shambharkar
New User
Joined: 26 Aug 2015 Posts: 55 Location: India
|
|
|
|
Hi,
Thanks for the suggestion . I tried to look here :- www-03.ibm.com/software/products/en/cics-vt
but it mentions Z/OS only . I want to understand from migration VSAM/ISAM data to DB2 what would be the essential differences if it is DB2-Z/OS or DB2-LUW .
Thanks for your inputs. |
|
Back to top |
|
|
Nic Clouston
Global Moderator
Joined: 10 May 2007 Posts: 2454 Location: Hampshire, UK
|
|
|
|
That depends on the differences between DB2on Z/OS and DB2 on LUW. Have you read up on this? Genereally it is the SQL functionality that is different - you should not need to worry about the underlying file formats as that is the job of DB2. |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
Can you tell us which OS you are converting to, and which COBOL compiler you are using? |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
Can you tell us which OS you are converting to, and which COBOL compiler you are using? |
|
Back to top |
|
|
Virendra Shambharkar
New User
Joined: 26 Aug 2015 Posts: 55 Location: India
|
|
|
|
Hi,
Actually the source environment is ISAM/DIBOL . We need to migrate the the ISAM files to DB2-LUW and looking for some automation tools which can help achive this.
Thanks |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10888 Location: italy
|
|
|
|
what happened when You googled with dibol |
|
Back to top |
|
|
Akatsukami
Global Moderator
Joined: 03 Oct 2009 Posts: 1787 Location: Bloomington, IL
|
|
|
|
I don't believe there was ever a DIBOL compiler for the S/360 or its successors. Are you actually touching a mainframe anywhere in this process? |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
Outside of the Mainframe, ISAM is a common generic name for file-systems allowing sequential or keyed access.
DB2 for LUW is different from that for z/OS. DiBOL is non-Mainframe. Are you even running Linux on the Mainframe? |
|
Back to top |
|
|
|