Menu
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.
In Oracle there is a utility program called "Top Session" which does the similar task. Is there any equivalent in DB2?
Thanks in advance, Kamal
551
The command Db2_all sends the command to all database partitions defined in the Db2nodes. cfg file, and also shows how long the instance has been activated. 2. You can determine the status of all the databases that have been activated by using one command.
The db2pd -dbptnmem command shows how much memory the Db2 server is currently consuming and, at a high level, which areas of the server are using that memory. Instance memory usage includes not only actual system memory consumption/commitment but also configured allowances that may not be in use/committed.
Maybe you are searching for below query.
SELECT
AUTHID,
APPL_NAME,
CLIENT_NNAME,
AGENT_ID,
APPL_ID,
APPL_STATUS
FROM
SYSIBMADM.APPLICATIONS
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With