BMCHIST table
If the option value is NO, the utility bypasses any updates to the BMCHIST table. If the value is YES (or the utility does not use a configuration or installation option), the utility inserts rows into the BMCHIST table during the UTILTERM phase.
For BMC AMI Copy, if the value is SUMMARY, the utility inserts only summary information about the BMC AMI Copy execution into the BMCHIST table. This option provides less information than the YES option.
The following table describes the contents of the BMCHIST table:
Column name | Data type | Description |
|---|---|---|
DBNAME | CHAR(8) | Name of the database that contains the table or index space |
SPNAME | CHAR(8) | Name of the table or index space |
UTILNAME | CHAR(8) | Name of the utility:
|
UTILID | CHAR(16) | Utility identifier |
AUTHID | CHAR(8) | User ID that ran the utility |
DATE | DATE | Date that the utility completed |
TIME | TIME | Time that the utility completed |
ELAPSED | TIME | Elapsed time of the utility |
PARTITION | LONG VARCHAR | ALL, or the partition numbers as specified by the DSNUM option (BMC AMI Copy) or the PART option Note the following conditions:
|
OBJNAME | VARCHAR(27) | Fully qualified object name |
PHASE_1 | CHAR(8) | Name of utility phase 1 |
ELAPSED_1 | TIME | Elapsed time of phase 1 |
PHASE_2 | CHAR(8) | Name of utility phase 2 |
ELAPSED_2 | TIME | Elapsed time of phase 2 |
PHASE_3 | CHAR(8) | Name of utility phase 3 |
ELAPSED_3 | TIME | Elapsed time of phase 3 |
PHASE_4 | CHAR(8) | Name of utility phase 4 |
ELAPSED_4 | TIME | Elapsed time of phase 4 |
PHASE_5 | CHAR(8) | Name of utility phase 5 |
ELAPSED_5 | TIME | Elapsed time of phase 5 |