BMCHIST table
This section describes the BMCHIST table, which contains information about completed executions of the BMC utilities for Db2. The installation options control use of the BMCHIST table:
- HISTORY (for BMC AMI Copy, BMC AMI Recover, and UNLOAD PLUS)
- BMCHIST (for REORG PLUS)
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.
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 |
Maintaining the BMCHIST table
When a utility completes successfully, it inserts a row into the BMCHIST table. Periodically, review BMCHIST and delete old rows to control its expansion.
To delete selected rows from the BMCHIST table based on the date that the utility completed, use the following sample SQL statement:
FROM creatorName.CMN_BMCHIST
WHERE DATE < 'yyyy-mm-dd';