MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

ims db to db2 conversion

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> IMS
View previous topic :: View next topic  
Author Message
nadh
Intermediate


Joined: 08 Oct 2004
Posts: 192
Topics: 89

PostPosted: Wed Oct 13, 2004 3:00 am    Post subject: ims db to db2 conversion Reply with quote

Hi,

can anyone send me the IMS DB to DB2 conversion code. I mean code showing the DLI call and corresponding DB2 CODE.

Its bit urgent.. and can send to this id hvj04@yahoo.com..

Thanks in advance.

venkat[/b]
Back to top
View user's profile Send private message Send e-mail
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12355
Topics: 75
Location: San Jose

PostPosted: Wed Oct 13, 2004 4:33 am    Post subject: Reply with quote

nadh,

I am assuming that the tables are already created for the corresponding segments in the IMS database . Relate the IMS calls to DB2.

GU, GHN, GHU are all simply SELECT in DB2

ISRT is equivalent to INSERT

REPL is equivalent to UPDATE

DLET is equivalent to DELETE.

So in your program wherever there is a IMS call , simply add the respective statement after it.

Hope this helps...

Cheers

Kolusu
_________________
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Bithead
Advanced


Joined: 03 Jan 2003
Posts: 550
Topics: 23
Location: Michigan, USA

PostPosted: Wed Oct 13, 2004 9:19 am    Post subject: Reply with quote

Remember that sequential reads thru segments in an IMS database should be converted to use cursors.

Straight replacement of IMS calls with DB2 calls often leads to inefficient and slower code.
Back to top
View user's profile Send private message
karthikbabudh
Beginner


Joined: 29 Apr 2005
Posts: 10
Topics: 6

PostPosted: Mon May 02, 2005 7:44 am    Post subject: Reply with quote

Hi Kolusu,
If Command codes are involved in a Call. then how to code that in DB2
_________________
Regards,
Karthik Babu.
Back to top
View user's profile Send private message
vjkumk
Beginner


Joined: 28 Sep 2005
Posts: 98
Topics: 33

PostPosted: Sun Aug 12, 2007 7:48 am    Post subject: Reply with quote

please anybody explain what is the equavalent db2 operations for ims command code calls .


cheers,
vj
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12355
Topics: 75
Location: San Jose

PostPosted: Mon Aug 13, 2007 6:10 am    Post subject: Reply with quote

vjkumk,

It depends. Command codes in IMS are equivalent to JOINS in DB2 if each segment in IMS is changed to a DB2 table. Sometimes you can achieve the end result by using a subquery also.

Kolusu
_________________
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
vjkumk
Beginner


Joined: 28 Sep 2005
Posts: 98
Topics: 33

PostPosted: Tue Aug 14, 2007 9:37 pm    Post subject: Reply with quote

Thanks kolusu.

cheers,vj
Back to top
View user's profile Send private message
misi01
Advanced


Joined: 02 Dec 2002
Posts: 615
Topics: 171
Location: Stockholm, Sweden

PostPosted: Wed Mar 29, 2017 3:36 am    Post subject: Reply with quote

I've done this twice; once for converting card purchases/ATM withdrawals from DL/1 to DB2 (a HUGE job) and once for a smaller, simpler system.

There is no simple, one size fits all methodology. First of all, your DBA will need to analyze the DL/1 database and possibly "convert" it to DB2 tables with all the normalization that includes. This in turn means that a DL/1 call does NOT necessarily convert straight off to a simple DB2 select. You might end up having to do a join between two or more tables. In addition, an insert might require that you specify a timestamp for your insert, something that might not be included in the old DL/1 code.

One very important piece of advice I WOULD give you though (depending on the importance of the system being converted). Ensure your code can flip-flop between DL/1 and DB2 and/or both. That means that when you go live, you can test your DB2 code, and at the first hint of problems, you simply revert to the DL/1 code instead and everything works as expected. (We had recourse to this when our first attempt failed)

Update It was only just now I noticed how OLD the original append was. The comments in THIS append still stand though if anyone else needs to go through such a conversion.
_________________
Michael
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> IMS All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group