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

Some content is unavailable due to permissions.

, if the value is SUMMARY, the utility inserts only summary information about the

Some content is unavailable due to permissions.

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: BMC AMI Check Some content is unavailable due to permissions. BMC AMI Load Some content is unavailable due to permissions. BMC AMI Reorg BMC AMI Unload
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 ( Some content is unavailable due to permissions. ) or the PART option Note the following conditions: This column lists only three-digit partitions (any loaded partitions 1 through 999). Four-digit partitions (any loaded partitions from 1000 through 4096) are not stored in this column. For jobs that load only four-digit partitions, this column is empty. If the list of partitions exceeds 1011 bytes, the utility truncates the value that is stored in this column. For UNLOAD PLUS, if you specified LOGICAL PART, these partitions are the physical partitions that correspond to the logical partitions that you specified.
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

Some content is unavailable due to permissions.

Some content is unavailable due to permissions.

uses the BMCHIST table to record completed COPY and COPY IMAGECOPY command executions.

HISTRETN is available as an

Some content is unavailable due to permissions.

installation option or as an option on the OPTIONS command. HISTRETN tells

Some content is unavailable due to permissions.

the number of days to keep entries in the BMCHIST table.

BMCHIST table considerations for

Some content is unavailable due to permissions.

For each execution of AFRMAIN,

Some content is unavailable due to permissions.

writes a single row to the BMCHIST table.

DBNAME, SPNAME, and OBJNAME columns will always be blank.

Some content is unavailable due to permissions.

accumulates elapsed time for each of the following phases using the

Some content is unavailable due to permissions.

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

Some content is unavailable due to permissions.

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.