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, 03:42 Jason Cai, <ibmm...@foxmail.com> wrote: > 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 following matters: > > Is it feasible to recover the IMS full image copy without an IMS DB > system, or is the presence of an IMS DB system an absolute necessity for > this migration process? > > Once we have successfully restored the IMS database files to disk, we are > considering two potential approaches: > a) Utilizing the IMS unload utility to convert the database files into a > PS format, followed by developing a program to read the PS file and import > the data into MySQL. > > b) Directly reading the IMS database files and writing the data into DB2, > and then subsequently converting the data from DB2 to MySQL. > > Are there any specific constraints or limitations that we should be aware > of, such as the mandatory requirement of an IMS DB system for this > migration? > > Are there any relevant tools or utilities available that could assist us > in this process and help streamline the migration? > > We would be immensely grateful if you could provide your insights on > which of the two approaches mentioned above would be more feasible, given > our current situation. Additionally, if there are any alternative methods > or strategies that you believe might be suitable for our specific case, we > would greatly appreciate your suggestions. > > Your expertise and knowledge in this area are highly valued, and any > advice or recommendations you can offer to help us navigate this complex > migration process effectively would be sincerely appreciated. > > Thank you in advance for your time and consideration. We eagerly await > your response and look forward to benefiting from your guidance. > > Best regards, > > Jason Cai > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
