IBM Support

DB2 agent attribute for Primary and Secondary Log Used Percent

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.

[{"Product":{"code":"SS3JRN","label":"Tivoli Composite Application Manager for Applications"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"ITCAM Agent for DB2 - 5724B96DO","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"7.1","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
17 June 2018

UID

swg21671252