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. The STATUS column has the following possible values:

  • 'REJECTED - DUPLICATED SCOPE SPECIFIED'
  • 'REJECTED - INVALID LOCATION SPECIFIED'
  • 'REJECTED - INVALID SCOPE SPECIFIED'
  • 'REJECTED - NO VALID RECORD FOUND IN ATTRIBUTE TABLE'
  • 'REJECTED - INVALID SCOPE SPECIFIED. FOR SYSTEM LEVEL MONITORING, ONLY IP ADDR, PRDID, ROLE AND/OR AUTHID, COLLECTION ID AND/OR PACKAGE NAME CAN BE SPECIFIED'
  • 'ACCEPTED - DOMAIN NAME IS RESOLVED INTO IP ADDRESS'
  • 'ACCEPTED'
End program-specific programming interface information.