Skip to main content

Database Strategies: Using Informix XPS and DB2 Universal Database

An IBM Redbooks publication

Note: This is publication is now archived. For reference only.


Published on 26 July 2005, updated 27 July 2005

  1. .PDF (4.4 MB)

Share this page:   

ISBN-10: 0738493740
ISBN-13: 9780738493749
IBM Form #: SG24-6437-00

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

    menu icon


    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


    Others who read this also read