DB2 DPF Backup Status Test
This test auto-discovers the logical partitions on the target DB2 database serverand for each logical partition, this test reports the statistics pertaining to the backups performed. Using this test, administrators can figure out the count of backups that failed and the count of backup jobs that were completed successfully. In addition, this test reports the maximum time taken to complete the backup jobs on each logical partition. By closely monitoring the measures reported by this test, administrators can pin point the logical partition on which maximum number of backup jobs failed and further analyze the reason behind such failures.
Target of the test : A DB2 database server with DPF enabled
Agent deploying the test : An internal agent
Outputs of the test : One set of results for every logical partition of each database on the DB2 database server
|
Measurement |
Description |
Measurement Unit |
Interpretation |
---|---|---|---|
Total backup |
Indicates the total number of backups performed for this logical partition during the last measurement period. |
Number |
This measure is a good indicator of backup load on the logical partition. |
Completed backup |
Indicates the number of backups completed successfully for this logical partition during the last measurement period. |
Number |
The detailed diagnosis of this measure lists the DB partition number EID, Start time, End Time, Duration(Minutes), Backup ID, Comment text, Number of tablespaces, Tablespace Names, Operation type, Object type, Location, Device type, SQL code, SQL warn and SQL state. |
Failed backup |
Indicates the number of backups failed for this logical partition during the last measurement period. |
Number |
Ideally, the value of this measure should be zero. Any value greater than zero, is a cause of concern, as it indicates the existence of a failed job. To know which job(s) has failed, use the detailed diagnosis capability of this measure. The detailed diagnosis of this measure lists the DB partition number EID, Start time, End Time, Duration(Minutes), Backup ID, Comment text, Number of tablespaces, Tablespace Names, Operation type, Object type, Location, Device type, SQL code, SQL warn and SQL state. Compare the value of this measure across the logical partitions to figure out the logical partition on which the maximum number of backup jobs failed. |
Maximum duration of completed backup |
Indicates the maximum time taken to complete the backup jobs on this logical partition during the last measurement period. |
Minutes |
Compare the value of this measure across logical partitions to figure out the logical partition on which the backup took too long to be completed. |