Hp_metrics.bar_job_status_vw1 view, Hp_metrics.bar_job_status_vw1 – HP Neoview Release 2.5 Software User Manual

Page 29

Advertising
background image

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

Advertising