Profile tables

Start of changeYou can create and populate profile tables to monitor threads and connections, customize certain subsystem parameters in particular contexts, and stabilize dynamic SQL statements.End of change

Begin program-specific programming interface information.

Experienced administrators can create and populate profile tables to monitor a DB2® subsystem.

Start of changeThe profile tables and related indexes are created when you run job DSNTIJSG during DB2 installation or migration.End of change

A complete set of profile tables and related indexes includes the following objects:
  • 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.