SYSUTILITIES catalog table

The SYSUTILITIES table contains one row for each utility executed if collection of utility history information is active. The schema is SYSIBM.

FL 501

Rows in this table can be updated, inserted, and deleted.

Table 1. SYSIBM.SYSUTILITIES table column descriptions
Column name	Data type	Description	Use
EVENTID	BIGINT NOT NULL	Unique identifier for the utility execution. See Db2-supplied sequences for information about how this value is generated.	G
NAME	VARCHAR(60) NOT NULL	Utility name.	G
INSERTEDBY	VARCHAR(9) NOT NULL	Identifies how the row was added: DB2 Indicates that the row was inserted by IBM Db2 Utilities. blank or identifiable value Indicates that the row was inserted by a user or utility other than IBM Db2 Utilities.	G
JOBNAME	VARCHAR(24) NOT NULL	Job name of the utility.	G
UTLID	VARCHAR(48) NOT NULL	Utility ID	G
USERID	VARCHAR(24) NOT NULL	User ID of the utility invoker.	G
STARTTS	TIMESTAMP NOT NULL WITH DEFAULT	A local timestamp that indicates the start of utility execution.	G
ENDTS	TIMESTAMP	A local timestamp that indicates the end of utility execution.	G
ELAPSEDTIME	BIGINT	Elapsed time in microseconds.	G
CPUTIME	BIGINT	Total general processor CPU time in microseconds. Does not include zIIP time (if applicable).	G
ZIIPTIME	BIGINT	Total zIIP time in microseconds. When applicable and accounting class 1 trace is active.	G
RETURNCODE	INTEGER	Final return code from utility execution.	G
CONDITION	CHAR(1) NOT NULL WITH DEFAULT ' '	Condition of the utility execution: blank Default value. Indicates an active or stopped utility. E Indicates utility execution ended. F Indicates utility execution was terminated by the -START DATABASE SPACENAM ACCESS(FORCE) command. T Indicates utility execution was terminated by the -TERM UTILITY command.	G
RESTART	CHAR(1) NOT NULL WITH DEFAULT 'N'	Indicates whether utility execution was restarted: N Default value. Utility execution was not restarted. Y Utility execution was restarted.	G
NUMOBJECTS	INTEGER	The number of objects processed during utility execution (utility specific). For partitioned objects, each partition is counted. For the following utilities, each data set is counted when the utility is run at the data set level on non-partitioned table spaces: COPY COPYTOCOPY MERGECOPY MODIFY RECOVERY REPORT RECOVERY	G
LISTNAME	VARCHAR(18)	Name of the LISTDEF list, if applicable	G
STARTLOGPOINT	CHAR(10) FOR BIT DATA	Current log point at the start of the utility execution. The log point is an RBA for a non-data-sharing subsystem and an LRSN for a data sharing subsystem.	G
GROUP_MEMBER	VARCHAR(24)	Member name of the Db2 data sharing subsystem where the utility started. Column is null for a non-data-sharing subsystem	G
SORTNAME	VARCHAR(24)	DFSORT or DB2SORT, if applicable.	G
SORTCPUTIME	BIGINT	Sort CPU time in microseconds, if applicable and provided by the sort program.	G
SORTZIIPTIME	BIGINT	Sort zIIP time in microseconds, if applicable and provided by the sort program.
The table also contains one set of phase columns for each utility phase, with the following names and data types, where `n` is 1 to 14. PHASE`n`NAME VARCHAR(24) PHASE`n`ET BIGINT PHASE`n`CPUT BIGINT PHASE`n`ZIIPT BIGINT PHASE`n`DATA BIGINT Reserved for future IBM® use.