Details

Subject(s)

• Database management [Browse]
• Information resources management [Browse]
• IBM Database 2. [Browse]

Related name

• International Business Machines Corporation. International Technical Support Organization [Browse]

Series

IBM redbooks. [More in this series]

Notes

"August 2003."

Bibliographic references

Includes bibliographical references and index.

Language note

English

Contents

• Front cover
• Contents
• Notices
• Trademarks
• Preface
• The team that wrote this redbook
• Become a published author
• Comments welcome
• Introduction
• Executive summary
• Chapter 1. Data federation overview
• 1.1 The challenge of information integration
• 1.2 To federate or not to federate
• 1.3 Data federation examples
• 1.3.1 Data federation with DB2
• 1.3.2 Data federation with Informix
• 1.4 Considerations
• 1.4.1 Naming conventions
• 1.4.2 Data types
• Chapter 2. The data federation project
• 2.1 Environment and server configuration
• 2.1.1 Client configuration
• 2.1.2 Database connectivity using DB2 Information Integrator
• 2.1.3 Database connectivity using Informix EGM
• 2.1.4 Other configuration options
• 2.2 Schema definition
• 2.3 Naming conventions
• 2.3.1 Database servers
• 2.3.2 Database identifiers
• 2.3.3 References to remote tables within the federated database
• 2.3.4 User IDs
• Chapter 3. Overview of project data sources
• 3.1 DB2 UDB
• 3.1.1 DB2 UDB architecture
• 3.1.2 DB2 UDB functions and features
• 3.2 Informix Dynamic Server (IDS)
• 3.2.1 IDS architecture
• 3.2.2 Functions and features
• 3.3 Informix Extended Parallel Server (XPS)
• 3.3.1 XPS architecture
• 3.3.2 Functions and features
• 3.4 IBM Red Brick Warehouse
• 3.4.1 Red Brick architecture
• 3.4.2 Functions and features
• 3.5 Oracle9i and Microsoft Excel
• Chapter 4. DB2 Information Integrator
• 4.1 Product overview
• 4.1.1 Systems environment
• 4.1.2 Components and packaging
• 4.2 Installation and configuration
• 4.2.1 Pre-installation requirements
• 4.2.2 Installation instructions
• 4.2.3 Post-installation tasks
• 4.3 Creating and using wrappers and nicknames
• 4.3.1 Create a wrapper
• 4.3.2 Define a server
• 4.3.3 Define user mapping
• 4.3.4 Create and authorize nicknames.
• 4.3.5 Testing the connection to a data source
• 4.4 Considerations for use
• 4.4.1 Statistics and index specifications
• 4.4.2 Informix synonyms and I-STAR
• 4.4.3 Transaction support
• 4.4.4 User mapping authentication for Informix data sources
• 4.4.5 Pass-through
• 4.4.6 Data type mapping
• 4.4.7 Server options
• 4.4.8 Capacity planning for DB2 Information Integrator
• 4.5 Troubleshooting
• 4.5.1 Connecting to data sources
• 4.5.2 Error messages
• 4.5.3 Informix environment settings and DB2DJ.INI file
• 4.5.4 Capturing server options and nickname definitions
• 4.5.5 Access plans and the query optimizer
• 4.5.6 Diagnostic information to collect
• 4.5.7 Tracing DB2 Information Integrator wrapper calls
• Chapter 5. Informix Enterprise Gateway Manager
• 5.1 Product overview
• 5.1.1 Systems environment
• 5.2 Installation and configuration
• 5.2.1 Pre-installation requirements
• 5.2.2 Installation instructions
• 5.2.3 Configuration tasks
• 5.3 Considerations for use
• 5.3.1 Using non-Informix SQL statements
• 5.3.2 Object names in queries
• 5.3.3 Using views versus synonyms
• 5.3.4 Using Informix 4GL
• 5.3.5 Distributed transactions
• 5.3.6 Multiple data sources within a single application
• 5.3.7 Effect of accuracy of statistical information
• 5.3.8 Effect of Informix style system catalog
• 5.3.9 Oracle date and datetime conversion
• 5.3.10 Using cursors
• 5.3.11 Temporary files for cursor handling
• 5.3.12 Limiting the number of rows returned in a query
• 5.4 Troubleshooting
• Chapter 6. Data federation in action
• 6.1 Test application examples
• 6.1.1 Query 1 - Summarizing regional data
• 6.1.2 Query 2 - Federated views
• 6.1.3 Query 3 - Consolidating the data
• 6.2 Testing with DB2 Information Integrator
• 6.2.1 Join and insert testing with DB2 II
• 6.3 Testing with Informix Enterprise Gateway Manager.
• 6.3.1 Join and insert testing with EGM
• 6.3.2 Updating multiple data sources
• Chapter 7. Optimization in a federated environment
• 7.1 Performance options and considerations
• 7.2 Remote data source tuning
• 7.3 Server options in DB2 II
• 7.3.1 Pushdown
• 7.3.2 Maximal pushdown
• 7.3.3 Collating sequence
• 7.4 Use of Materialized Query Tables (MQTs)
• 7.5 Remote data source catalog statistics
• 7.6 Optimizer hints in query text
• Chapter 8. Hints and tips
• 8.1 Federated inserts with Informix
• 8.2 Using DATE columns for a Union operation
• 8.3 Use of current schema with DB2 Interactive Explain
• 8.4 DB2 problem determination series tutorial
• 8.5 Losing connection to a data source
• 8.6 Using views versus synonyms with data federation
• Appendix A. DB2 II and Informix EGM function summary
• Data federation summary table
• Appendix B. Nonrelational wrappers
• Microsoft Excel wrapper
• XML wrapper
• Glossary
• Abbreviations and acronyms
• Related publications
• IBM Redbooks
• Other publications
• Online resources
• How to get IBM Redbooks
• Help from IBM
• Index
• Back cover.

Show 136 more Contents items

OCLC

137342297

Statement on language in description

Princeton University Library aims to describe library materials in a manner that is respectful to the individuals and communities who create, use, and are represented in the collections we manage. Read more...