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
 

 

Migration from IMS (DB) to DB2

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

New User


Joined: 24 Jul 2006
Posts: 99
Location: Los Angeles

PostPosted: Fri Jun 05, 2009 8:47 am    Post subject: Migration from IMS (DB) to DB2
Reply with quote

Hi All,

Not sure this post should have been in in IMS forum or DB2, please move it if this is not the right place for this topic.

This was asked to me in an interview.......Client wants to migrate from IMS (DB) to DB2. He said programming changes are ok but what about data, how we will move it or what exactly needs to be done, is there any specific tool or anything which you can think of.

I was not sure......can someone help me with this or is there any link ?

Thanks
Neelesh
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Jun 05, 2009 9:02 am    Post subject:
Reply with quote

Hello,

Quote:
He said programming changes are ok but what about data,
Either this is a trick question or the client is only interested in your database knowledge as it relates to handling the data.

If there is to be no change to the structure of the database, creating db2 tables from ims tables can be as simple as unloading the data from ims, defining the new tables to db2 and loading the data from the qsam files. Some thought will probably be needed to define the db2 indexes.

fwiw - the programming effort to convert from ims navigation to db2/sql takes more than just a little work. Not necessarily difficult, just a lot of it. . .
Back to top
View user's profile Send private message
neelesht

New User


Joined: 24 Jul 2006
Posts: 99
Location: Los Angeles

PostPosted: Fri Jun 05, 2009 9:13 am    Post subject:
Reply with quote

So, it doesn't matter whether we are migrating from IMS or just unloading and loading the data back to DB2......right ? (Except the Index and Table creation part)

Even I thought the programming effort would be much more.

Thanks Dick.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Jun 05, 2009 9:23 am    Post subject:
Reply with quote

You're welcome icon_smile.gif

It doesn't much matter if all of the db2 entities have already been defined. . .

Otherwise, all of the tables would need to be defined, permissions granted, etc. . .

I thought the question was somewhat "limited" icon_confused.gif
Back to top
View user's profile Send private message
neelesht

New User


Joined: 24 Jul 2006
Posts: 99
Location: Los Angeles

PostPosted: Wed Jun 24, 2009 5:31 am    Post subject:
Reply with quote

Hi,

Apologies for coming back so late.

So, transferring data from Hiererchial to RDMS is just unload and load.....nothing else.

I have just started on the project and still waiting for the requirement so dont have much idea and didnt find any good document on net.

Thanks
Neelesh
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Jun 24, 2009 6:44 am    Post subject:
Reply with quote

Hello,

Quote:
So, transferring data from Hiererchial to RDMS is just unload and load.....nothing else.
Possibly. . . But Only If the existing design is a "good" design and there is to be no change to the current table design.

As i mentioned originally, the question seems "limited".

You also seem to want to hear that this will be a snap of the fingers. It may, but it also may not. . . Better to plan on significant effort and then have a pleasant surprise rather than plan on a small effort and then having to manage both yours and your manager's disappointment.
Back to top
View user's profile Send private message
neelesht

New User


Joined: 24 Jul 2006
Posts: 99
Location: Los Angeles

PostPosted: Fri Jul 03, 2009 12:31 am    Post subject:
Reply with quote

Hey Dick,

Continuing our discussion......we came up with some approach and I will let you know what xactly is that approach before that I have a qns

Is there anyway to capture what was the last call I made to IMS e.g.

CALL 'CBLTDLI' USING FUNC-ISRT
PCB-YYYY
XXXX-SEG
UNQ-SEGMENT-SSA.

Now once I make this call and then call a para to determine the response of the DATABASE at that point of time how can I know which call I had made to DB (whether ISRT or REPL or GU or GN). I know this is more of a shop specific qns but still do you think that information is stored somewhere.

Thanks, I will surely let you guys know the approach we are finalizing for IMS to DB2 migration.

Regards
Neelesh
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Jul 03, 2009 1:31 am    Post subject:
Reply with quote

Hello,

Database modifications could be tracked (not in real-time, though) but i've never heard of anything that provides the "last request" info. One could conceivably write code that intercepted every call to CBLTDLI, recordrd the request and then recorded the response from ims before returning to the actuall caller. Not a trivial task to intercept and inter-leave all of the activity into and back from the database. . . icon_neutral.gif

How would this be part of converting to db2? Keep in mind that thousands upon thousands of applications have been converted to db2 with no need for something like this. . .

As always, if you explain things more clearly, someone has a better change at making a useful suggestion.
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 Db2 migration from V4/6 to V8/10 Venkatesh G DB2 1 Thu Jul 14, 2016 8:54 am
No new posts Data Migration from Fujitsu AIM/DB to... umakalikiri DB2 2 Fri Apr 15, 2016 12:26 pm
No new posts Fujitsu Cobol 85 to IBM Cobol (Any ve... umakalikiri COBOL Programming 4 Fri Apr 15, 2016 7:40 am
No new posts Natural/Adabas - Migration/Replatform Virendra Shambharkar Java & MQSeries 5 Tue Apr 05, 2016 2:37 pm
No new posts z/OS V2R2 Migration Impact on Existin... dexter.mozer All Other Mainframe Topics 4 Mon Feb 29, 2016 6:22 pm


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