README for HP Neoview Release 2.5 (R2.5)

Table 6 HP_METRICS.OVERALL_BAR_JOB_STATUS_VW1 (continued)
DescriptionData TypeField Name
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 DEFAULTSTATUS
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 DEFAULTRECOVERY_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 DEFAULTRECOVERY_POINT_OBJ_LCT_TS
UnusedINTERVAL SECOND(5) NO
DEFAULT
USER_DISABLE_DDL_DURATION
UnusedINTERVAL SECOND(5) NO
DEFAULT
ACTUAL_DISABLE_DDL_DURATION
HP_METRICS.OVERALL_BAR_JOB_STATUS_VW2
Table 7 HP_METRICS.OVERALL_BAR_JOB_STATUS_VW2
Returns aggregated data grouped by OVERALL_START_UTC_TS.Description:
PLATFORM_NAME
OVERALL_START_UTC_TS
OVERALL_START_LCT_TS
OVERALL_END_UTC_TS
OVERALL_END_LCT_TS
OVERALL_START_UTC_TS
STATUS
ERROR_NUM
ERROR_TEXT
RECOVERY_POINT_OBJ_UTC_TS
RECOVERY_POINT_OBJ_LCT_TS
USER_DISABLE_DDL_DURATION
ACTUAL_DISABLE_DDL_DURATION
TOTAL_NUM_FILES_DUMPED
TOTAL_NUM_FILES_NOT_DUMPED
TOTAL_NUM_BYTES_DUMPED
Columns Included:
NEO.HP_METRICS.OVERALL_BAR_JOB_STATUS_VW2Views Used:
24