Download: Get Statistics Utilities

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.

August 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:

  • AIX
  • Windows

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).

static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management
ArticleID=186620
SummaryTitle=Download: Get Statistics Utilities
publish-date=082002