Database Strategies: Using Informix XPS and DB2 Universal Database

An IBM Redbooks publication

Published 26 July 2005, updated 27 July 2005

cover image

ISBN-10: 0738493740
ISBN-13: 9780738493749
IBM Form #: SG24-6437-00
(478 pages)

More options

Rate and comment

Authors: Chuck Ballard, Weiren Ding, Carlton Doe, Glen Mules, Rajamani Muralidharan, Santosh Sajip, Nora Sokolof, Andreas Weininger


The acquisition of Informix by IBM has provided the opportunity for Informix customers to consider new alternatives to further enrich their data management systems infrastructure. They can now more easily take advantage of available products, services, and capabilities as they grow and change.

This IBM Redbooks publication focuses on strategies, techniques, capabilities, and considerations for using Informix Extended Parallel Server (XPS) and DB2 Universal Database (UDB). It provides detailed discussions and data to give a good understanding of the two products, their capabilities, and their similarities. XPS customers can choose to adopt a database strategy of coexistence or consider transitioning to DB2 UDB. The features and functionality of each DBMS are briefly described for a better understanding, in areas such as architecture, partitioning techniques, SQL considerations, configuration, indexing, data types, DML, and DDL. It also discusses products and tools to complement these database management systems. With this information, you can better decide which products satisfy your particular requirements, and better plan on how to achieve your objectives as you develop your database management system strategy. You will be better positioned to make informed decisions that can give you the best return on your DBMS investment.

Table of contents

Chapter 1. Introduction to this redbook
Chapter 2. XPS and DB2 UDB architectures
Chapter 3. Configuration
Chapter 4. Instance and database operations
Chapter 5. Data types
Chapter 6. Data partitioning and access methods
Chapter 7. SQL considerations
Chapter 8. Loading and unloading data
Chapter 9. Administration tools and utilities
Chapter 10. Planning the transition
Chapter 11. Application conversion considerations
Chapter 12. DB2 Migration ToolKit for Informix
Chapter 13. Large data volumes:A case study
Appendix A. Case study schemas definitions
Appendix B. Additional material

Follow IBM Redbooks

Follow IBM Redbooks