ISAM to DB2 Conversion

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

enrico-sorichetti · Posted: Fri Oct 16, 2015 6:05 pm

ISAM

daveporcelan · Posted: Fri Oct 16, 2015 7:53 pm

Pete Wilson · Posted: Sat Oct 17, 2015 1:33 am

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.

Rohit Umarjikar · Posted: Sat Oct 17, 2015 3:38 am

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.

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.

PeterHolland · Posted: Sat Oct 17, 2015 11:20 am

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.

Nic Clouston · Posted: Mon Oct 19, 2015 3:09 pm

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.

Bill Woodger · Posted: Mon Oct 19, 2015 3:21 pm

Can you tell us which OS you are converting to, and which COBOL compiler you are using?

Bill Woodger · Posted: Mon Oct 19, 2015 3:25 pm

Can you tell us which OS you are converting to, and which COBOL compiler you are using?

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

enrico-sorichetti · Posted: Mon Oct 19, 2015 4:32 pm

what happened when You googled with dibol

Akatsukami · Posted: Mon Oct 19, 2015 5:03 pm

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?

Bill Woodger · Posted: Mon Oct 19, 2015 5:42 pm

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?