Profile tables

Start of changeYou 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.End of change

Begin program-specific programming interface information.

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 with 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
End program-specific programming interface information.