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 [email protected] with the message: INFO IBM-MAIN
