If you are 100% completely satisfied with the performance, availability and maintainability of the current IMS environment then converting makes little sense. If this is the only IMS application and you have other DB2 applications, then perhaps migrating the IMS application to DB2 makes sense to save yourself the license cost of IMS (because you could get rid of IMS completely).
Of course, if you migrate the data from IMS to DB2 it will become easier to access because of the flexibility of SQL and the ability to access the data however you choose (without having to code secondary indexes or restructure the database).
Regardless, if you decide to migrate be sure to take care to design a RELATIONAL database for the new DB2 environment and re-write the application to use SQL appropriately. Do not just simply convert segments to tables and replace your IMS data read/writes with SQL read/writes. You need to re-design both the database and the application to make sure your get the best advantage of DB2 in terms of usability and performance.
Dig Deeper on IBM DB2 management
Related Q&A from Craig S. Mullins
Our expert suggests that the best way to pass the SAP BW exam is to have hands-on job experience. But that's not all he has to say about ... Continue Reading
To export data from a DB2 table to a flat file, you need to run an export specifying the proper file format. The export utility exports data from a ... Continue Reading
Craig Mullins recommends two specific resources for learning how to create and support Binary Large Objects (BLOB) in DB2. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.