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 an installation option), the utility inserts rows into the BMCHIST table during the UTILTERM phase. There is no option for LOADPLUS.
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(for COPY PLUS) 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 |