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.
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.
Important:
Do 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.
Do 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.
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'