SYSUTIL table

The SYSUTIL table stores status information about Db2 utilities that are active or stopped. Each record is uniquely identified by the utility identifier. Each row of the table contains the information for one utility execution step. When the utility completes, the corresponding entries in the SYSUTIL table are deleted. The schema is SYSIBM.

Name Data type Description Use
USUUID CHAR(16) UTILID value that was passed in a JOB statement parameter S
USUJOBNM CHAR(8) Job name from the JOB statement S
USUAUID CHAR(8) Authorization ID of the invoker S
USURDATE
CHAR(4)
FOR BIT DATA
Date of the utility S
USUREL CHAR(3) Utility release level at restart time S
USUIRQD CHAR(1) IBM® required field S
USULSIZE
CHAR(4)
FOR BIT DATA
List size S
USULCUR
CHAR(4)
FOR BIT DATA
The object that is currently being processed or was last processed S
USUUTNAM CHAR(8) Name of the currently executing utility S
USUPHASE CHAR(8) Current phase of the currently executing utility S
USUDSNU
CHAR(2)
FOR BIT DATA
Data set or piece number S
USUDSNU2
CHAR(2)
FOR BIT DATA
Ending number of the partition range S
Start of changeUSUSTATUEnd of change Start of changeCHAR(1)End of change Start of changeReservedEnd of change Start of changeIEnd of change
USUTREQ CHAR(1) Termination requested (Y or N) S
USUFORCE CHAR(1) Element of USO forced (Y or N) S
USURLOK CHAR(1) Reload was successful (Y or N) S
USUCMPOK CHAR(1) Compatibility check passed (Y or N) S
USURSFLG BIT(8) Utility restriction flags S
USURTFLG BIT(8) Term settings S
USURSFLG2 BIT(8) Utility flags S
USUPOS
CHAR(4)
FOR BIT DATA
Relative USM position in the SYSIN DD statement S
USUDONE
CHAR(8)
FOR BIT DATA
Number of objects processed S
USUCKSUM
CHAR(4)
FOR BIT DATA
USU checksum S
USUDBOB
CHAR(2)
FOR BIT DATA
DBID for the table space S
USUPSID
CHAR(2)
FOR BIT DATA
PSID for the table space or index space S
USUPSDD
CHAR(2)
FOR BIT DATA
Secondary PSID for RECOVER INDEX data page set S
USUCATMGFRM
CHAR(1)
FOR BIT DATA
Saved catalog level for the release from which migration is done, from the DBD01 header page S
USUOFLAG
CHAR(1)
FOR BIT DATA
Flags for object properties S
USUDBNAM CHAR(8) Database name S
USUSPNAM CHAR(8) Table space or index space name S
USUMEMBR CHAR(8) Member name S
USUOCATR
CHAR(1)
FOR BIT DATA
Saved catalog release level, from the DBD01 header page S
USUOCATV
CHAR(1)
FOR BIT DATA
Saved catalog version level, from the DBD01 header page S
USUOCATCV
CHAR(1)
FOR BIT DATA
Saved migration mode, from the DBD01 header page S
USUOCATH
CHAR(1)
FOR BIT DATA
Saved highest version of the catalog S
USUUDA
CHAR(150)
FOR BIT DATA
Utility-dependent data S
USURTIME
CHAR(4)
FOR BIT DATA
Latest utility start time S
USURLSN
CHAR(6)
FOR BIT DATA
Latest utility start LRSN S
USURDATO
CHAR(4)
FOR BIT DATA
Original utility start date S
USURTIMO
CHAR(4)
FOR BIT DATA
Original utility start time S
USURLSNO
CHAR(4)
FOR BIT DATA
Original utility start LRSN S
USUR5
CHAR(10)
FOR BIT DATA
Reserved I
USURCNTR
CHAR(31)
FOR BIT DATA
Generic counter or value holder S
Start of changeUSURLSNXEnd of change Start of change
CHAR(10)
FOR BIT DATA
End of change
Start of changeLatest utility start LRSN valueEnd of change Start of changeSEnd of change
Start of changeUSURLSOXEnd of change Start of change
CHAR(10)
FOR BIT DATA
End of change
Start of changeOriginal utility start LRSN valueEnd of change Start of changeSEnd of change
USUR6
Start of changeCHAR(72)
FOR BIT DATAEnd of change
Reserved I
USUUSTRN
CHAR(27000)
FOR BIT DATA
Utility-dependent restart information S