 | Level: Introductory Aug 2002 DB2® Information Integrator™ enables your applications to query and retrieve data located on other relational and nonrelational sources. To help the federated optimizer make better decisions, you can use these utilities to gather statistics on relational and nonrelational nicknames.
get_stats (for relational and some nonrelational nicknames)
You can invoke this utility for these data sources: DB2 UDB, Oracle, Sybase, IBM Informix, Microsoft SQL Server, Teradata, ODBC, table-structured files, Excel, XML, and BioRs. However, there are some limitations involved for some of the data sources. See the readme for more information.
Supported platforms include:
- AIX
- Windows
- Sun
- HP-UNIX
- Linux
Download now
get_stats_nr (for nonrelational nicknames)
You can invoke this utility for these data sources: flat files, Excel, BioRs, Documentum, Blast, Hmmer, Extended Search, Entrez, and XML. See the readme for more information.
Supported platforms include:
Download now
For more information, see Performance of DB2 Information Integrator in a J2EE Environment with Multiple Data Sources by C.M.Saracco, Susanne Englert, and Ingmar Gebert (developerWorks, June 2003).
Rate this content
| | | |
