Viewing the utility history catalog table
The SYSIBM.SYSUTILITIES catalog table stores runtime information on Db2 utilities. Db2 Automation Expert's user interface allows you to display and delete rows from this table on Db2 13 and later subsystems.
About utility history
SYSIBM.SYSUTILITIES contains real-time and historical information for utility executions. A row is inserted for each Db2 utility execution that contains information such as utility name, job name, starting and ending timestamps, elapsed time, CPU time, zIIP time, final return code, and other conditions.
Db2 Automation Expert's ISPF interface displays rows from the utility history table. You can filter the display to see only utilities run during a specific time period, as well as filter by utility name, job name, user ID, return code, and condition.
System requirements
- The SYSIBM.SYSUTILITIES table is only available on subsystems running Db2 13 function level 501 and later.
- The Db2 install option (DSNZPARM) UTILITY_HISTORY must be set to UTILITY to activate utility history information collection.
For more information, refer to the information on IBM® Documentation about the SYSIBM.SYSUTILITIES table.