Database Transition: Informix Dynamic Server to DB2 Universal Database

This IBM Redbook focuses on the considerations and methodology for transitioning from IBM Informix Dynamic Server (IDS) Version 9.4 to IBM DB2 Universal Database Version 8.2.

We address the basic topic areas of data, applications, and administration. We also include an overview of the architecture of the two products to give you a better understanding of how they are structured. This book provides information about feature and functionality mapping and SQL implementation as guidelines to help you understand the specific capabilities, and similarities, in areas such as data types, DML, DDL, and stored procedures. To aid in the transition preparation, we discuss application conversion considerations. There is an overview of the capabilities of the DB2 Migration Toolkit for Informix to show how it can make the transition much easier. We also describe other transition approaches to provide you with alternatives to consider and to give you flexibility.

With this information, you can understand the requirements, plan your transition, and proceed with the transition in an orderly and cost effective manner.