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 |
USUSTATU![]() |
CHAR(1)![]() |
Reserved![]() |
I![]() |
| 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 |
USURLSNX![]() |
![]() CHAR(10)
FOR BIT DATA ![]() |
Latest utility start LRSN value![]() |
S![]() |
USURLSOX![]() |
![]() CHAR(10)
FOR BIT DATA ![]() |
Original utility start LRSN value![]() |
S![]() |
| USUR6 | CHAR(72)FOR BIT DATA ![]() |
Reserved | I |
| USUUSTRN | CHAR(27000)
FOR BIT DATA |
Utility-dependent restart information | S |
USUSTATU