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
 

 

steps in converting IMS-DB calls to DB2.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
View previous topic :: :: View next topic  
Author Message
rajat_gupta

New User


Joined: 05 Apr 2007
Posts: 15
Location: india

PostPosted: Wed May 30, 2007 4:05 pm    Post subject: steps in converting IMS-DB calls to DB2.
Reply with quote

Hi all
can anybody help me out and list the steps involved in converting an IMS program to DB2 program.the DB2 tables are already existing.
Back to top
View user's profile Send private message

Devzee

Active Member


Joined: 20 Jan 2007
Posts: 684
Location: Hollywood

PostPosted: Wed May 30, 2007 6:33 pm    Post subject:
Reply with quote

I assumed you are migrating batch IMS DB program to DB2 program.

At a very high level:
1. In working storage Add DCLGEN for tables and remove IO areas.
2. Linkage section - No need of PCB masks
3. Procedure division - Remove using or Entry statement which ever defined
4. Instead of CBLTDLI calls code equivalent of this in DB2 statements. Converting IMS calls to DB2 equivalent is tricky or little complicated, bcos IMS is hierachical and DB2 is relational. You can do simpler using Db2 if you know exactly what business logic the IMS calls are used within program.
5. Create PLANS, delete PSBs
6. Also you need to consider if IMS program is BMP, Checkpoint restart etc.. in DB2

This is not complete list, once you start migrating you can come up with better steps.
Back to top
View user's profile Send private message
rajat_gupta

New User


Joined: 05 Apr 2007
Posts: 15
Location: india

PostPosted: Thu May 31, 2007 12:41 pm    Post subject:
Reply with quote

Thanks a lot Devzee.I have started following these steps told by u
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 -> IMS DB/DC All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Converting Variable block file to Fix... bhavana yalavarthi DFSORT/ICETOOL 10 Tue May 16, 2017 2:20 pm
No new posts Converting decimal to numeric using I... Balaryan DFSORT/ICETOOL 4 Thu Feb 02, 2017 11:27 pm
This topic is locked: you cannot edit posts or make replies. DB2 query Using Recursion, Converting... smilewithashu2 DB2 3 Tue Jan 03, 2017 12:50 pm
No new posts Converting multiple VB files to FB fi... Viswanath Reddy JCL & VSAM 6 Mon Aug 08, 2016 11:49 pm
No new posts Converting NULL column into NOT NULL ... Raghu navaikulam DB2 5 Sat Aug 06, 2016 3:45 pm


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