DSN_PROFILE_HISTORY profile table

The profile history table, SYSIBM.DSN_PROFILE_HISTORY, contains all of the profiles that were in effect at some point in time. The schema is SYSIBM.

Begin program-specific programming interface information. Profiles are defined in the profile table, SYSIBM.DSN_PROFILE_TABLE. Profiles in the profile history table might no longer exist in the profile table. This table is used by optimization tools when diagnosing optimization problems.

The profile tables and related indexes are created when you run job DSNTIJSG during Db2 installation, as described in Job DSNTIJSG.
Important: Start of changeDo not manually insert data into this table. It is populated by START PROFILE command processing. Use care to delete rows only when they are no longer needed.End of change

The columns for SYSIBM.DSN_PROFILE_HISTORY are the same as the columns in SYSIBM.DSN_PROFILE_TABLE, except that the REMARKS column is named STATUS instead.

Important: Start of changeAlways check the status of any newly added profile table rows in the STATUS columns of DSN_PROFILE_HISTORY and DSN_PROFILE ATTRIBUTES_HISTORY tables after you issue the START PROFILE command. Successful completion of the START PROFILE command does not imply that all profiles started successfully. If the STATUS column of either history table contains a value that does not start with 'ACCEPTED', further action is required to enable the profile or the keyword action.End of change
End program-specific programming interface information.