HP Neoview Release 2.5 Software - Manual (Page 24)

MANAGEABILITY.METRICS.OVERALL_BAR_JOB_STATUS Table
Repository tables contain historical job operation information. For each backup job that runs
successfully, one row (per segment) is written to the BAR_JOB_STATUS table. Overall data for
each backup job is stored in the OVERALL_BAR_JOB_STATUS table.
Table 4-1 OVERALL_BAR_JOB_STATUS Field Definitions
Description Data Type Field Name
Name of platform (composed of the first five
characters of the system name).
Example: ARC01
CHAR(64) NO
DEFAULT PLATFORM_NAME
Start time of the overall backup job run in
UTC. PK; Leading clustering key. TIMESTAMP(6) NO
DEFAULT, NOT NULL,
NOT DROPPABLE OVERALL_START_UTC_TS
Start time of the overall backup job run in
LCT. TIMESTAMP(6) NO
DEFAULT OVERALL_START_LCT_TS
End time of the overall backup job run in
UTC. TIMESTAMP(6) NO
DEFAULT OVERALL_END_UTC_TS
End time of the overall backup job run in
LCT. TIMESTAMP(6) NO
DEFAULT OVERALL_END_LCT_TS
Overall current status of backup job run;
status of each segment affects the overall
status.
Example: If backup fails in one segment,
STATUS is set to BACKUP_FAILED.
Values are:
• BACKUP_FAILED
• BACKUP_IN_PROGRESS
• BACKUP_NOT_STARTED
• BACKUP_SUCCEEDED
• BACKUP_SUCCEEDED_
WITH_WARNINGS
• BACKUP_STATUS_ UNAVAILABLE
• BACKUP_STOPPED
CHAR(64) NO
DEFAULT STATUS
Error or warning number for the overall
current status. SMALLINT UNSIGNED
DEFAULT 0 ERROR_NUM
Error or warning text message. VARCHAR(4096)
DEFAULT “ ERROR_TEXT
Recovery point objective time for the overall
backup job run in UTC (this is the earliest of
the NSFR times). TIMESTAMP(6) NO
DEFAULT RECOVERY_POINT_OBJ_UTC_TS
Recovery point objective time for overall
backup job run in LCT (this is the earliest of
the NSFR times). TIMESTAMP(6) NO
DEFAULT RECOVERY_POINT_OBJ_LCT_TS
Unused INTERVAL SECOND(5)
NO DEFAULT USER_DISABLE_DDL_DURATION
Unused INTERVAL SECOND(5)
NO DEFAULT ACTUAL_DISABLE_DDL_DURATION
24 Repository Tables and Views for Backup Jobs