DB2中每个应用程序/连接使用的事务日志数量 [英] Quantity of transaction logs used per application/connection in DB2

问题描述

我想知道数据库中每个连接使用的日志数量（活动日志）。

I would like to know the quantity of logs used (active logs) by each connection in the database.

我知道如何检索活动日志的数量数据库，但不适用于每个应用程序。了解数据库中活动日志的数量有助于我识别日志完整状况是否正在接近。

I know how to retrieve the quantity of active logs for the database, but not for each application. Knowing the quantity of active logs in the database helps me to identify if a log-full condition is approaching.

但是，我想知道哪个应用程序正在接近这种情况的日志完整。因此，我需要知道每个交易（每个应用程序）使用了多少日志，但是我没有为每个应用程序找到一个视图，快照或其他内容。

However, I want to know which application is approaching to this condition of log-full. For this reason, I need to know how much log is used by each transaction (each application), but I have not found a view, snapshot or something else for each application.

任何想法？

推荐答案

日志是由事务（工作单位）使用，而不是连接，所以 - 这样的东西，可能是吗？

Logs are used by transactions (units of work), not connections, so -- something like this, may be?

select 
  application_handle, uow_log_space_used 
from 
  table(sysproc.mon_get_unit_of_work(null,null))
order by 2 desc
fetch first 5 rows only

这篇关于DB2中每个应用程序/连接使用的事务日志数量的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！