BMCUTIL and BMCUTIL2 tables
The BMCUTIL and BMCUTIL2 tables contain information about utilities that are currently running or started. The utilities use the tables 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 and BMCUTIL2 tables.
The utilities insert rows into the BMCUTIL and BMCUTIL2 tables during the UTILINIT phase and update the tables as the job status changes. The utilities delete rows from the BMCUTIL and BMCUTIL2 tables during the UTILTERM phase.
This topic describes the following tables:
UTILID connects the BMCUTIL table to the BMCUTIL2 table.
BMCUTIL table
The following table describes the contents of the BMCUTIL table:
Column name | Data type | Description |
|---|---|---|
UTILID | CHAR(16) | Utility identifier |
STATUS | CHAR(1) | Execution status of the utility:
(DASD MANAGER PLUS) The value for this column is always X. |
UTILNAME | CHAR(8) | Name of the executing utility:
|
PHASE | CHAR(8) | Current phase of the utility The following products do not use this column:
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:
The following products do not use this column:
The value for this column is always N. |
NOTEID | CHAR(8) | TSO user ID to be notified The following products 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 | Always 1 for:
For all other utilities, this column is always 0. |
COMMAND | VARCHAR(256) | First 256 characters of the utility command text BMC AMI Recover, DASD MANAGER PLUS, BMC AMI Copy, BMC AMI Check, BMC AMI Load, BMC AMI Reorg, BMC AMI Stats, and BMC AMI Unload do not use this column. |
STATE | LONG VARCHAR | Utility state and sync information The following products do not use this column:
|
START_TIMESTAMP | TIMESTAMP | Starting timestamp of the utility The following products do not use this column:
|
BMCUTIL2 table
The following table describes the contents of the BMCUTIL2 table:
Column name | Data type | Description |
|---|---|---|
UTILID | CHAR(16) | Utility identifier |
JOBNAME | CHAR(8) | Name of the active job, whether initial job or restart |
JOBID | CHAR(8) | ID of the active job, whether initial job or restart |
SCHEMA_VERSION | SMALLINT | Version of the data being stored in the table |