BMCUTIL table
The BMCUTIL table contains information about utilities that are currently running or started.
The following table describes the contents of the BMCUTIL table. The utilities use the table to control the use of utility IDs. Each BMC utility must have a unique ID for restart purposes. If you have more than one BMC utility installed, all of these utilities should share the same BMCUTIL table.
The utilities insert rows into the BMCUTIL table during the UTILINIT phase and update the table as the job status changes. The utilities delete rows from the BMCUTIL table during the UTILTERM phase.
Column name | Data type | Description |
|---|---|---|
UTILID | CHAR(16) | Utility identifier |
STATUS | CHAR(1) | Execution status of the utility:
|
UTILNAME | CHAR(8) | Name of the executing utility:
|
PHASE | CHAR(8) | Current phase of the utility BMC AMI Copy does not use this column. (BMC AMI Check, BMC AMI Load, BMC AMI Reorg, BMC AMI Stats, and BMC AMI Unload) The value for this column is always UTILINIT. |
USERID | CHAR(8) | User ID executing the utility |
SSID | CHAR(4) | Db2 subsystem where the utility is running |
RESTART | CHAR(1) | Restart option:
DASD MANAGER PLUS does not use this column. (BMC AMI Check, BMC AMI Load, BMC AMI Reorg, BMC AMI Stats, and BMC AMI Unload) The value for this column is always N. |
NOTEID | CHAR(8) | TSO user ID to be notified DASD MANAGER PLUS, BMC AMI Check, BMC AMI Load, BMC AMI Reorg, BMC AMI Stats, and BMC AMI Unload do not use this column. |
DBNAME | CHAR(8) | (BMC AMI Recover and REORG PLUS) Name of the database containing the table or index space for which the last checkpoint was taken This value can be blank. The other utilities do not use this column. |
SPNAME | CHAR(8) | (BMC AMI Recover and REORG PLUS) Name of the table or index space for which the last checkpoint was taken This value can be blank. The other utilities do not use this column. |
SPSTATUS | CHAR(5) | (REORG PLUS) Space status before the utility stopped The other utilities do not use this column. |
COMMANDNO | SMALLINT | (BMC AMI Check, BMC AMI Load, BMC AMI Reorg, BMC AMI Stats, and BMC AMI Unload) Always 1 For all other utilities, this column is always 0. |
COMMAND | VARCHAR(256) | First 256 characters of the utility command text |
STATE | LONG VARCHAR | Utility state and sync information DASD MANAGER PLUS, BMC AMI Check, BMC AMI Load, BMC AMI Reorg, BMC AMI Stats, and BMC AMI Unload do not use this column. |
START_TIMESTAMP | TIMESTAMP | Starting timestamp of the utility BMC AMI Check, BMC AMI Load, BMC AMI Reorg, BMC AMI Stats, and BMC AMI Unload do not use this column. |