Foglight for DB2 (Cartridge) 5.9.3.20


Metric	Description
IS_LICENSED	Indicates whether the installed product is licensed (1) or not (0).
INSTANCE_NAME	The name of the monitored instance.
PROD_RELEASE	The product release number.
INSTALLED_PROD	Represents the DB2 products that are installed on the system.

Log Activity Collection

The following table provides a list of the Log Activity metrics that are collected, and a description for each.


Metric	Description
DB_NAME	The name of the monitored database.
DBPARTITIONNUM	The database partition from which the data was retrieved for this row.
TOTAL_LOG_AVAILABLE_KB	Use this element with TOTAL_LOG_USED_KB to determine whether you need to adjust the following configuration parameters to avoid running out of log space: logfilsiz logprimary logsecond
TOTAL_LOG_USED_KB	The total amount of active log space currently used (in KB) in the database.
LOG_UTILIZATION	The percentage of used log within the entire available log.
SECONDARY_LOG_USED_TOP_KB	The maximum amount of secondary log space used (in KB). The value is zero if the database does not have any secondary log files (which is the case if there are none defined).
TOTAL_LOG_USED_TOP_KB	The maximum amount of total log space used (in KB). You can use this element to help evaluate the amount of primary log space that you have allocated. Comparing the value of this element with the amount of primary log space you have allocated can help you to evaluate your configuration parameter settings. Your primary log space allocation can be calculated using the following formula: logprimary * logfilsiz * 4096 You can use this element with SECONDARY_LOG_USED_TOP_KB and SECONDARY_LOGS_ALLOCATED to evaluate your current dependency on secondary logs.
SECONDARY_LOGS_ALLOCATED	You may use this element with SEC_LOG_USED_TOP and TOT_LOG_USED_TOP to show your current dependency on secondary logs. If this value is consistently high, you may need larger log files, more primary log files, or more frequent COMMIT statements within your application. As a result, you may need to adjust the following configuration parameters: logfilsiz logprimary logsecond logretain
LOG_READS	The number of log reads (pages) during the specified time range.
LOG_READS_RATE	The number of log reads (pages) per second during the specified time range.
LOG_READ_TIME_S	The total elapsed time spent by the logger reading log data from the disk.
LOG_WRITES	The number of log writes (pages) during the specified time range.
LOG_WRITES_RATE	The number of log writes (pages) per second during the specified time range.
LOG_WRITE_TIME_S	The total elapsed time spent by the logger writing log data to the disk.
NUMBER_LOG_WRITE_IO	The number of I/O requests issued by the logger for writing log data to the disk.
NUMBER_LOG_READ_IO	The number of I/O requests issued by the logger for reading log data from the disk.
NUMBER_LOG_PART_PAGE_IO	The number of I/O requests issued by the logger for writing partial log data to the disk.
NUMBER_LOG_BUFFER_FULL	The number of times agents that copy log records into the log buffer have to wait for log data to write to disk. This value is incremented each time an agent has to wait. For example, if two agents are waiting, the value is incremented by two.
NUMBER_LOG_DATA_FOUND_IN_ BUFFER	The number of times an agent reads log data from the buffer. Reading log data from the buffer is preferable to reading from the disk because the latter is slower. Use this element with the NUM_LOG_READ_IO element to determine if the LOGBUFSZ database configuration parameter needs to be increased.
APPL_ID_OLDEST_XACT	The application ID (which corresponds to the AGENT_ID value from the application snapshot) of the application that has the oldest transaction. This element can help in determining which application has the oldest active transaction. That application can be forced to free up log space. If it is taking up a great deal of log space, examine the application to determine if it can be modified to commit more frequently. There are times when there is not a transaction holding up logging, or the oldest transaction does not have an application ID (for example, an in-doubt transaction or an inactive transaction). In these cases, an application ID is not returned in the data stream.
LOG_TO_REDO_FOR_RECOVERY_KB	The amount of log (in KB) that has to be redone for crash recovery. When the snapshot is taken, this value is calculated based on the conditions at the time of the snapshot. Larger values indicate longer recovery times after a system crash. If the value seems excessive, check the LOG_HELD_BY_DIRTY_PAGES element to see if page cleaning needs to be tuned. Also, check if there are any long running transactions that need to be terminated.
LOG_HELD_BY_DIRTY_PAGES_KB	The amount of log corresponding to the difference between the oldest dirty page in the database and the top of the active log. When the snapshot is taken, this value is calculated based on the conditions at the time of the snapshot. Use this element to evaluate the effectiveness of page cleaning for older pages in the buffer pool. The cleaning of old pages in the buffer pool is governed by the softmax database configuration parameter. If the page cleaning is effective, then LOG_HELD_BY_DIRTY_PAGES_KB should be less than or approximately equal to: (softmax / 100) * logfilsiz * 4096. If this statement is not true, increase the number of page cleaners using the num_iocleaners configuration parameter. If the condition is true and it is desired that less log be held by dirty pages, then decrease the softmax configuration parameter.

Log File Collection

The following table provides a list of the Log File metrics that are collected.


Metric	Description
INSTANCE	The name of the monitored instance.
FULL_DIAG_LOG_PATH	The full path and name of the diag log file (the filename is db2diag.log).
DIAG_LOG_SIZE	The diag log file size.