Profile tables
You can create and populate profile tables to monitor threads and connections, customize certain subsystem parameters in particular contexts, set special registers, set global variables, and stabilize dynamic SQL statements.
Experienced administrators can create and populate profile tables to monitor and control various attributes of a Db2 subsystem. For an overview of how to use profile tables and a summary of the specific uses for profile tables, see Monitoring and controlling Db2 by using profile tables.
The profile tables and related indexes are created when you run job DSNTIJSG during Db2 installation, as described in Job DSNTIJSG. A complete set of profile tables and related indexes includes the following tables and indexes:
- SYSIBM.DSN_PROFILE_TABLE
- SYSIBM.DSN_PROFILE_HISTORY
- SYSIBM.DSN_PROFILE_ATTRIBUTES
- SYSIBM.DSN_PROFILE_ATTRIBUTES_HISTORY
- SYSIBM.DSN_PROFILE_TABLE_IX_ALL
- SYSIBM.DSN_PROFILE_TABLE_IX2_ALL
- SYSIBM.DSN_PROFILE_ATTRIBUTES_IX_ALL
In addition to the profile tables that are described below,
other Db2-supplied
user tables can be used in conjunction with monitor profiles, including
instances of the following EXPLAIN and run time information tables:
- PLAN_TABLE
- DSN_STATEMNT_TABLE
- DSN_FUNCTION_TABLE