DB2 Version 9.7 for Linux, UNIX, and Windows

int_auto_rebinds - Internal Automatic Rebinds monitor element

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

Table 1. Snapshot Monitoring Information
Snapshot Level	Logical Data Grouping	Monitor Switch
Database	dbase	Basic
Application	appl	Basic

For snapshot monitoring, this counter can be reset.

Table 2. Event Monitoring Information
Event Type	Logical Data Grouping	Monitor Switch
Database	event_db	-
Connection	event_conn	-

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, packages 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 int_auto_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:

 
 int_auto_rebinds / total number of statements

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