BMCHIST table
The BMCHIST table contains information about completed executions of the BMC utilities for Db2.
The following configuration or 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 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 |
BMCHIST table considerations for BMC AMI Copy
BMC AMI Copy uses the BMCHIST table to record completed COPY and COPY IMAGECOPY command executions.
HISTRETN is available as an BMC AMI Copy installation option or as an option on the OPTIONS command. HISTRETN tells BMC AMI Copy the number of days to keep entries in the BMCHIST table.
Warning
If you want to use BMCHIST, allocate adequate space for the table. BMC AMI Copy makes an entry in the table for every copied space. If you are copying a large number of partitions, you might need to increase the size of the BMCHIST table space from the standard size that was allocated during installation.
BMCHIST table considerations for BMC AMI Recover
For each execution of AFRMAIN, BMC AMI Recover writes a single row to the BMCHIST table.
DBNAME, SPNAME, and OBJNAME columns will always be blank.
BMC AMI Recover accumulates elapsed time for each of the following phases using the BMC AMI Recover phase shown:
PHASE_1: LOGSORT
PHASE_2: MERGE (includes RESTORE phase)
PHASE_3: SNAP
PHASE_4: REBUILD (includes UNLOAD phase)
PHASE_5: DB2UTIL (the time spent in DSNUTILB)
The elapsed time for each of the phases is a sum for all objects. The utility elapsed time, ELAPSED, is the duration from the start of the utility to until it finishes. Because BMC AMI Recover multitasks, the sum of the phases might be greater than the total elapsed time of the utility. The elapsed time columns have a limit of 24 hours.
Comments
Log in or register to comment.