暂时无法在支持网站上提交享有定期维护的产品表单。 如果您需要我们立即提供帮助，请与技术支持部门联系。 对于由此给您带来的不便，我们深表歉意。
获得即时帮助
完成注册
登录
请求定价
联系销售人员
您已选择一个产品捆绑包。 您能否选择单个产品以便我们更好地满足您的请求。 *
技术支持工程师目前正忙，无法回应您的消息。 如果需要即时服务，请通过我们的服务请求表提交请求。
以下文章可根据您的描述解决您的问题。
The following table provides a list of the Log Activity metrics that are collected, and a description for each.
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:
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.
The following table provides a list of the Log File metrics that are collected.
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.
The following table provides a list of the Log Message metrics that are collected, and a description for each.
APPL_ID
The application ID that is related to the message in the notification log file.
DBNAME
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.
MSG
The message text.
MSGNUM
The message number.
MSGSEVERITY
The message severity.
Values:
C (critical)
E (error)
W (warning)
I (informational)
NULL (if the message severity could not be determined)
MSGTYPE
The message type.
PID
The process ID that caused this message.
PROCESSNAME
The process name.
TID
The thread ID.
TIMESTAMP
The log message timestamp.
The following table provides a list of the Messages Count metrics that are collected, and a description for each.
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.
您可以在附属支持站点上查找适用于戴尔*产品*的在线支持帮助。单击“继续”，转至适用于*产品*的正确支持内容和帮助。
The document was helpful.
选择评级
I easily found the information I needed.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. 使用条款 隐私 Cookie Preference Center
Quest Software门户不再支持IE 8、9和10，建议将您的浏览器升级到最新版本的Internet Explorer或Chrome。
要升级到IE 11，请单击此处
要升级到Chrome，请单击此处
如果继续使用IE 8、9和10，您将无法充分利用我们所有出色的自助服务功能。
