Browse Prior Art Database

Runstats for DiscoveryLink & Federated Database

IP.com Disclosure Number: IPCOM000016406D
Original Publication Date: 2002-Nov-08
Included in the Prior Art Database: 2003-Jun-21
Document File: 2 page(s) / 46K

Publishing Venue

IBM

Abstract

Runstats for DiscoveryLink Federated Database In DB2, two types of permanent tables are defined :

This text was extracted from a PDF file.
At least one non-text object (such as an image or picture) has been suppressed.
This is the abbreviated version, containing approximately 53% of the total text.

Page 1 of 2

Runstats for DiscoveryLink & Federated Database

In DB2, two types of permanent tables are defined :

- System catalog tables; - User tables.

System catalog tables contain information about all the objects stored into DB2 which are used by the DB2 engine during the processing of the queries. More particularly, these tables comprise :

- Table/index definitions; - Column/Data Types; - Statistical information about tables (ex: physical memory used for each table). This information is updated using the DB2 command "runstats".

User tables contain the data created by the DB2 user

DiscoveryLink is an IBM (International Business Machines Corporation) computer program to federate heterogeneous data sources. This middleware comprising DB2 EE v 7.2 + Relational Connect + LifeSciences Data Connect allows a connection to Oracle,

Sybase, SQL Server databases and to other data sources as if they were DB2 native. Some features in DiscoveryLink are lacking. The most important feature is the refresh (update) of statistics for remote databases (on DB2, Oracle, SQL Server, etc..). The problem is that it is not possible to perform a "runstats" command on a nickname object (a Remote Data Object). The only way to do so is to drop the nickname and to recreate it. The problem is that statistics are only automatically calculated during the nickname creation.

The present invention discloses a new "runstats" function to refresh the statistics for an existing nickname. This new "runstats" function performs special queries to analyze the remote catalog of the database related to the nickname (DB2, Oracle). Today, it is impossible to use the DB2 "runstats" command to update statistical information related to an e...