beautypg.com

Manageability.metrics.bar_job_status table, Bar_job_status field definitions – HP Neoview Release 2.5 Software User Manual

Page 25

background image

MANAGEABILITY.METRICS.BAR_JOB_STATUS Table

For the MANAGEABILITY.METRICS.BAR_JOB_STATUS repository table, one row is written
per segment for each successful overall job.

Table 4-2 BAR_JOB_STATUS Field Definitions

Description

Data Type

Field 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

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

MANAGEABILITY.METRICS.BAR_JOB_STATUS Table

25