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

ISAM to DB2 Conversion


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Virendra Shambharkar

New User


Joined: 26 Aug 2015
Posts: 55
Location: India

PostPosted: Fri Oct 16, 2015 6:02 pm
Reply with quote

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
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10886
Location: italy

PostPosted: Fri Oct 16, 2015 6:05 pm
Reply with quote

ISAM icon_eek.gif
Back to top
View user's profile Send private message
daveporcelan

Active Member


Joined: 01 Dec 2006
Posts: 792
Location: Pennsylvania

PostPosted: Fri Oct 16, 2015 7:53 pm
Reply with quote

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
View user's profile Send private message
Pete Wilson

Active Member


Joined: 31 Dec 2009
Posts: 590
Location: London

PostPosted: Sat Oct 17, 2015 1:33 am
Reply with quote

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. icon_rolleyes.gif
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 3076
Location: NYC,USA

PostPosted: Sat Oct 17, 2015 3:38 am
Reply with quote

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
View user's profile Send private message
Virendra Shambharkar

New User


Joined: 26 Aug 2015
Posts: 55
Location: India

PostPosted: Sat Oct 17, 2015 8:39 am
Reply with quote

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
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen

PostPosted: Sat Oct 17, 2015 11:20 am
Reply with quote

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
View user's profile Send private message
Virendra Shambharkar

New User


Joined: 26 Aug 2015
Posts: 55
Location: India

PostPosted: Mon Oct 19, 2015 10:00 am
Reply with quote

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
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 2454
Location: Hampshire, UK

PostPosted: Mon Oct 19, 2015 3:09 pm
Reply with quote

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
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix

PostPosted: Mon Oct 19, 2015 3:21 pm
Reply with quote

Can you tell us which OS you are converting to, and which COBOL compiler you are using?
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix

PostPosted: Mon Oct 19, 2015 3:25 pm
Reply with quote

Can you tell us which OS you are converting to, and which COBOL compiler you are using?
Back to top
View user's profile Send private message
Virendra Shambharkar

New User


Joined: 26 Aug 2015
Posts: 55
Location: India

PostPosted: Mon Oct 19, 2015 4:25 pm
Reply with quote

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
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10886
Location: italy

PostPosted: Mon Oct 19, 2015 4:32 pm
Reply with quote

what happened when You googled with dibol
Back to top
View user's profile Send private message
Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1787
Location: Bloomington, IL

PostPosted: Mon Oct 19, 2015 5:03 pm
Reply with quote

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
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix

PostPosted: Mon Oct 19, 2015 5:42 pm
Reply with quote

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
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 -> DB2

 


Similar Topics
Topic Forum Replies
No new posts GDG generation name to GDG Base name ... DFSORT/ICETOOL 3
No new posts FB to .CSV conversion using sort DFSORT/ICETOOL 7
No new posts small int to zoned decimal conversion DFSORT/ICETOOL 3
No new posts ISAM and abend S03B JCL & VSAM 10
No new posts 10 byte RBA conversion DB2 2
Search our Forums:

Back to Top