Foglight for DB2 (Cartridge) 5.9.5.10


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.

Log Message Collection

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

Metric

Description

APPL_ID

The application ID that is related to the message in the notification log file.

DBNAME

The name of the monitored database.

DBPARTITIONNUM

The name of the monitored database.

FUNCTION

The name of the function that generated the message.

This metric is retrieved for version 10 and higher.

IMPACT

Qualifies the impact of this message from a user's perspective. This clarifies the impact that the event described by the message has on the business process DB2 is part of. The impact is determined according to DB2 definition. The possible values are:

•

•

•

•

•

This metric is reserved for version 10 and higher.

The message severity.

NULL (if the message severity could not be determined)

MSGTYPE

The message type.

PID

The process ID that caused this message.

The log message timestamp.

Messages Count Collection

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


Metric	Description
DB_NAME	The name of the monitored database.
CRITICAL_COUNT	The number of critical messages for the selected period.
FATAL_COUNT	The number of fatal messages for the selected period.
WARNING_COUNT	The number of warning messages for the selected period.
INFORMATIONAL_COUNT	The number of informational messages for the selected period.
OTHER_COUNT	The number of unknown messages for the selected period.

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

Foglight for DB2 (Cartridge) 5.9.5.10 - User Guide

Log Activity Collection

Log File Collection

Log Message Collection

Messages Count Collection