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 |
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.
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 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.