Hp_metrics.bar_job_status_vw1 view, Hp_metrics.bar_job_status_vw1 – HP Neoview Release 2.5 Software User Manual
Page 29
HP_METRICS.BAR_JOB_STATUS_VW1 View
The HP_METRICS.BAR_JOB_STATUS_VW1 view provides important information about online
dumps for each segment. This information includes the start time of the overall backup job, the
segment number, the online dump pass number, the platform name, the start time and end time
for each online dump pass, the synchronized file recovery time, and the total number of files
dumped during the online dump pass.
Table 4-4 HP_METRICS.BAR_JOB_STATUS_VW1
Description
Data Type
Field Name
Start time of the overall backup job run in
UTC.
Primary Key; Leading clustering key
TIMESTAMP(6) NO DEFAULT, NOT
NULL, NOT DROPPABLE
OVERALL_START_UTC_TS
Segment number
Primary Key
INT UNSIGNED NO DEFAULT, NOT
NULL, NOT DROPPABLE
SEGMENT_ID
Online dump pass number
Primary Key
This is always 1.
INT UNSIGNED NO DEFAULT, NOT
NULL, NOT DROPPABLE
PASS_NUM
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
LCT.
TIMESTAMP(6) NO DEFAULT
OVERALL_START_LCT_TS
Start time of the online dump pass in UTC.
TIMESTAMP(6) NO DEFAULT
START_UTC_TS
Start time of the online dump pass in LTC.
TIMESTAMP(6) NO DEFAULT
START_LTC_TS
End time of the online dump pass in UTC.
TIMESTAMP(6) NO DEFAULT
END_UTC_TS
End time of the online dump pass in LTC.
TIMESTAMP(6) NO DEFAULT
END_LTC_TS
Synchronized file recovery time in UTC.
TIMESTAMP(6) NO DEFAULT
NSFR_UTC_TS
Synchronized file recovery time in LTC.
TIMESTAMP(6) NO DEFAULT
NSFR_LTC_TS
Total number of files dumped by online
dump pass.
LARGEINT NO DEFAULT
NUM_FILES_DUMPED
Total number of files not dumped by
online dump pass.
LARGEINT NO DEFAULT
NUM_FILES_NOT_DUMPED
Reserved for future use.
LARGEINT NO DEFAULT
NUM_BYTES_DUMPED
Repository Views for Backup Jobs
29