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
 

 

ISAM to DB2 Conversion

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Virendra Shambharkar

New User


Joined: 26 Aug 2015
Posts: 26
Location: India

PostPosted: Fri Oct 16, 2015 6:02 pm    Post subject: ISAM to DB2 Conversion
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10202
Location: italy

PostPosted: Fri Oct 16, 2015 6:05 pm    Post subject: Reply to: ISAM to DB2 Conversion
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: 645
Location: Pennsylvania

PostPosted: Fri Oct 16, 2015 7:53 pm    Post subject:
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 User


Joined: 31 Dec 2009
Posts: 437
Location: London

PostPosted: Sat Oct 17, 2015 1:33 am    Post subject:
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

Senior Member


Joined: 21 Sep 2010
Posts: 1609
Location: NY,USA

PostPosted: Sat Oct 17, 2015 3:38 am    Post subject:
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: 26
Location: India

PostPosted: Sat Oct 17, 2015 8:39 am    Post subject: Reply to: ISAM to DB2 Conversion
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: 2422
Location: Netherlands, Amstelveen

PostPosted: Sat Oct 17, 2015 11:20 am    Post subject:
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: 26
Location: India

PostPosted: Mon Oct 19, 2015 10:00 am    Post subject: Reply to: ISAM to DB2 Conversion
Reply with quote

Hi,

Thanks for the suggestion . I tried to look here :- http://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: 1712
Location: UK

PostPosted: Mon Oct 19, 2015 3:09 pm    Post subject:
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

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7223

PostPosted: Mon Oct 19, 2015 3:21 pm    Post subject: Reply to: ISAM to DB2 Conversion
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

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7223

PostPosted: Mon Oct 19, 2015 3:25 pm    Post subject: Reply to: ISAM to DB2 Conversion
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: 26
Location: India

PostPosted: Mon Oct 19, 2015 4:25 pm    Post subject:
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10202
Location: italy

PostPosted: Mon Oct 19, 2015 4:32 pm    Post subject: Reply to: ISAM to DB2 Conversion
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: 1738
Location: Bloomington, IL

PostPosted: Mon Oct 19, 2015 5:03 pm    Post subject:
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

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7223

PostPosted: Mon Oct 19, 2015 5:42 pm    Post subject: Reply to: ISAM to DB2 Conversion
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    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 Conversion of a VB file to FB. isssal DFSORT/ICETOOL 1 Mon Oct 31, 2016 10:23 pm
No new posts EBCDIC to ASCII conversion using OCOPY mistah kurtz All Other Mainframe Topics 5 Tue Sep 06, 2016 2:26 pm
No new posts Comparex utility to Syncsort conversion mistah kurtz SYNCSORT 11 Fri Jul 22, 2016 1:53 pm
No new posts changing z/os unicode conversion service meykh2014 All Other Mainframe Topics 0 Tue Jul 12, 2016 10:49 am


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