如何在 DB2 (8.x) 中查找所有打开/活动的连接 [英] How to find all open/active connections in DB2 (8.x)

问题描述

我目前正在使用带有 FixPak 10 的 Db2 Enterprise Server V 8.2

I'm currently working with Db2 Enterprise Server V 8.2 with FixPak 10

我想检索一个实例的所有打开的活动连接的列表.

And I want to retrieve list of all the open active connections with an instance.

在 Oracle 中有一个名为Top Session"的实用程序可以完成类似的任务.DB2 中是否有任何等价物?

In Oracle there is a utility program called "Top Session" which does the similar task. Is there any equivalent in DB2?

提前致谢，卡马尔

推荐答案

从列表应用程序中获取更多详细信息:

To get more detailed information from list applications:

db2 list applications for database {dbName} show detail

对于具有大量活动连接的应用程序，将结果通过管道传送到 grep 以仅查找当前正在执行或锁定的线程很有用.

For applications with lots of active connections it is useful to pipe the results to grep to find only the threads currently executing or locked.

db2 list applications for database {dbName} show detail | grep -i "executing"

和

db2 list applications for database {dbName} show detail | grep -i "lock"

这篇关于如何在 DB2 (8.x) 中查找所有打开/活动的连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！