Internal Automatic Rebinds

Snapshot Information Level
Database
Application

API Structure(s)
sqlm_dbase
sqlm_appl

Monitor Group
Basic
Basic

Resettable

Yes

Event Information Level
Database
Connection

API Structure(s)
sqlm_db_event
sqlm_conn_event

API Element Name
Element Type

int_auto_rebinds
counter

Description:  The number of automatic rebinds (or recompiles) that have been attempted.

Usage:  Automatic rebinds are the internal binds the system performs when an package has been invalidated. The rebind is performed the first time that the database manager needs to execute an SQL statement from the package. For example, plans are invalidated when you:

• Drop an object, such as a table, view, or index, on which the plan is dependent

• Add or drop a foreign key

• Revoke object privileges on which the plan is dependent.

You can use this element to determine the level of database activity at the application or database level. Since internal automatic rebinds can have a significant impact on performance, they should be minimized where possible.

You can also use this element to determine the percentage of rebind activity using the following formula:

 internal automatic rebinds / total number of statements

This information can be useful for analyzing application activity and throughput.

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]