One point which might seem obvious, and if it's been discussed I apologise
for repeating, but IMS DB supports a hierarchical structure, so in a
typical DB a root segment may have zero, one or many child segments.
Exhoing others, you really will need an IMS expert.
Roops
On Fri, 17 May 2024,
-From: Jason Cai
> > Date: 17/05/2024 09:21 (GMT+00:00) To: IBM-MAIN@LISTSERV.UA.EDU,
> Andrew
> > Wilkinson Cc: Jason Cai <
> > ibmm...@foxmail.com> Subject: Re: Assistance with Converting IMS DB to
> > MySQL DB Dear Andrew,Thank you for your suggestion. I have some tho
w
> Original message From: Jason Cai
> Date: 17/05/2024 09:21 (GMT+00:00) To: IBM-MAIN@LISTSERV.UA.EDU, Andrew
> Wilkinson Cc: Jason Cai <
> ibmm...@foxmail.com> Subject: Re: Assistance with Converting IMS DB to
> MySQL DB Dear Andrew,Thank you for your sug
need an IMS
expert to do this cleanly.Cheers,Andrew
Original message From: Jason Cai Date:
17/05/2024 09:21 (GMT+00:00) To: IBM-MAIN@LISTSERV.UA.EDU, Andrew Wilkinson
Cc: Jason Cai
Subject: Re: Assistance with Converting IMS DB to MySQL DB Dear Andrew,Thank
you for your
ch segment. That also can be easier to process than an
IMS unload.
-Original Message-
From: IBM Mainframe Discussion List On Behalf Of
Jason Cai
Sent: Friday, May 17, 2024 3:21 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: Assistance with Converting IMS DB to MySQL DB
Dear Andrew,
Thank yo
Jason,
See embedded notes. My suggestion is that you should engage a consultant
who is knowledgeable in IMS and relational data bases to accomplish
this. It is non-trivial and full of pitfalls.
Tom Harper
Phoenix Software International
On 5/16/2024 7:42 PM, Jason Cai wrote:
Dear all,
Dear Andrew,
Thank you for your suggestion. I have some thoughts on the IMS segment layout
and defining SQL columns, and I’d like to confirm with you:
If I have the DBD (Database Description), is it sufficient to correctly define
the SQL columns? Or do I need the application copybook in
Jason,There is an important step you did not list: understanding the IMS
segment layout so that you can define the SQL columns correctly.For that you
will need the application copybook.Cheers,Andrew
--
For IBM-MAIN subscribe /
Dear all,
We are currently undertaking a project to convert some 15-year-old IMS
database, for which we have some full image copy on tape, to a MySQL database
on a Linux platform.
To ensure the success of this migration, we would greatly appreciate your
expertise and guidance on the
