HP Neoview Release 2.5 Software - Manual (Page 26)

Repository Views for Backup Jobs
This section describes the views that provide information about recent backup jobs:
• “HP_METRICS.OVERALL_BAR_JOB_STATUS_VW1 View” (page 26)
• “HP_METRICS.OVERALL_BAR_JOB_STATUS_VW2 View” (page 28)
• “HP_METRICS.BAR_JOB_STATUS_VW1 View” (page 29)
• “HP_METRICS.BAR_JOB_STATUS_VW2 View” (page 30)
• “HP_METRICS.BAR_JOB_STATUS_VW3 View” (page 31)
• “HP_METRICS.BAR_JOB_STATUS_VW4 View” (page 31)
• “HP_METRICS.BAR_JOB_STATUS_VW5 View” (page 32)
Each of the seven views can be accessed by super-group users, HP support, and users belonging
to ROLE.DBA.
TIP:
To query the repository views, use the HPDM SQL Whiteboard or Metric Miner. These tools
return formatted output. They also allow you to save queries and export query results to a
browser, spreadsheet, or file.
HP_METRICS.OVERALL_BAR_JOB_STATUS_VW1 View
The HP_METRICS.OVERALL_BAR_JOB_STATUS_VW1 view provides important status
information about the current backup job. This information includes the platform name, the
backup-job start time and end time, the job status (SUCCEEDED, FAILED, etc), error information,
and the RPO time.
Table 4-3 HP_METRICS.OVERALL_BAR_JOB_STATUS_VW1
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.
Primary Key; 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
26 Repository Tables and Views for Backup Jobs