Question & Answer
Question
Which attributes of ITCAM agent for DB2 database should be used to monitor Primary and Secondary Log Used Percent for database?
Cause
DB2 monitoring agent attributes for Log Used Percent for Primary and Secondary logs are different based on the type of transaction logging (circular or archival) configured for the database.
Answer
Circular transaction logging:
In case of circular logging configuration, following attributes return valid value, and can be used to monitor the percent usage of primary and secondary transaction logs. These attributes should not be used if archival logging is enabled.
Primary Log Used Percent: KUD_DB2_Database01.pri_log_used_pct
Secondary Log Used Percent: KUD_DB2_Database01.sec_log_used_pct
Archival transaction logging:
In case of archival logging, use following attributes to monitor percent usage of primary and secondary transaction logs:
Current Primary Log Used Percent: KUD_DB2_Database01.curr_pri_log_used_pct
Current Secondary Log Used Percent: KUD_DB2_Database01.curr_sec_log_used_pct
Note: All four attributes mentioned above are included in two attribute groups Database01 (KUD_DB2_Database01) and Log (KUD_DB2_LOG). Either of the two attribute groups can be used to monitor the Log Used Percent, as these are calculated in exactly the same way.
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21671252