GSAM conversion in IMS DB to DB2 migration project

asukumar · New User Joined: 15 Apr 2009 Posts: 8 Location: bangalore

Dear All,

Please can you suggest me on this?

We are responding to a proposal for IMS DB to DB2 migration. The inventory has 4000 GSAM files. I understand GSAM files would be using for checkpoint/restart within IMS.

My question is - if we are eliminating the IMS completely, would there be any need to migrate them to flat files?

Again, GSAM files are sequential in nature. If required, can't we just use them as it is after migration to DB2?

Basically, I'm trying to understand what/how would we use GSAM files after migrating to DB2.

I have been searching through the forum for this. Please help me with your suggestions. As I said, this is for proposal. We don't have complete details yet. So any thoughts on your previous experiences would help.

thanks in advance.

enrico-sorichetti · Posted: Tue Feb 18, 2014 1:22 pm

the application design must be completely reviewed ...
and the application logic using GSAM databases must be REDESIGNED from scratch
USER must reposition on input files and cleanup unwanted record from output

see here for a quick and dirty explanation of GSAM behavior
ibmmainframes.com/about56674.html

but it is really a shame that an organization preparing such a complex proposal is completely unaware of such basic IMS concepts

pretty poor business ethics also, sponsoring a project without the proper skills

dick scherrer · Posted: Tue Feb 18, 2014 11:02 pm

Hello,

You need to review how/why each of these exist and make sure that similar functionality (if needed) is incorporated into the db2 environment.

Is there no one with an in depth knowledge of ims/gsam involved with the project?