IBM Informix : integration through data federation / [Chuck Ballard ... et al.].

Format:

Book

Author/Creator:

Ballard, Chuck.

Contributor:

International Business Machines Corporation. International Technical Support Organization.

Series:

IBM redbooks.

IBM redbooks

Language:

English

Subjects (All):

Database management.

Information resources management.

IBM Database 2.

Physical Description:

1 online resource (270 p.)

Edition:

1st ed.

Place of Publication:

[S.l.] : IBM, International Technical Support Organization, 2003.

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.

Notes:

"August 2003."

Includes bibliographical references and index.

OCLC:

137342297