DB2 for LUW - Session Manager

Toolbar Operations - Depending on the Tab selected, there are different Toolbar Operations available.

Available Operations for Sessions tab
Refresh : Refreshes all the tab results from the database
Reconnect: Reconnects to the database server
Copy all w/ Headers and Row counts: Copies every data from the tab selected to paste the information anywhere else needed
Refresh Seconds: Enables the interval in which to refresh the tabs if you check the "Auto Refresh" box
Auto Refresh: Indicates whether to refresh the tab results automatically every X number of seconds determined by the "Refresh Seconds"
Expand All: Expands all tree nodes in the tree tab
Collapse All: Collapses all tree nodes in the tree tab
Kill Session: Allows to kill selected session
Group Sessions: Allows to group running sessions by Auth ID, Application, Client Protocol, Client Name, Inbound Address, Agent ID, Database, Application Status, Client Platform, and Connection Time, allowing to locate sessions easier

Available Operations for Sessions Stats
Refresh : Refreshes all the tab results from the database
Reconnect: Reconnects to the database server
Copy all w/ Headers and Row counts: Copies every data from the tab selected to paste the information anywhere else needed
Refresh Seconds: Enables the interval in which to refresh the tabs if you check the "Auto Refresh" box
Auto Refresh: Indicates whether to refresh the tab results automatically every X number of seconds determined by the "Refresh Seconds"

Available Operations for Locks tab
Refresh : Refreshes all the tab results from the database
Reconnect: Reconnects to the database server
Copy all w/ Headers and Row counts: Copies every data from the tab selected to paste the information anywhere else needed
Refresh Seconds: Enables the interval in which to refresh the tabs if you check the "Auto Refresh" box
Auto Refresh: Indicates whether to refresh the tab results automatically every X number of seconds determined by the "Refresh Seconds"

Sessions Tab - Provides a list of sessions currently held by the DB2-LUW server, as a tree view

Auth ID: Name of the ID authentication
Agent ID: Number of session
Inbound Address: IP address from the session
Database: Type of database
Application : Application being executed
Client Protocol: Type of client protocol
Client Platform: Type of client platform
Client Name: Client name from the session
Connection Time: Date and time of connection
Application Status: Current status of the application

Sessions Stats Tab - Provides a list of sessions currently held by the DB2-LUW server

Agent ID: Number of Agent ID
Auth ID: Name of the session
Database: Type of database
Application: Application being executed
Application Status: Current status of the application
Client Protocol: Type of client protocol
Client Platform: Type of client platform
Client Name: Client name from the session
Connection Time: Date and time of connection
Inbound Address: IP address from the session
 

Locks Tab - Provides a list of Transaction, DML and PL/SQL locks currently held by the DB2-LUW server, as a tree view

Session/Lock: Name of session or lock
Session ID: Session ID
User: Server user name(login) Process status
Lock Type: Indicates type of lock
Tablespace:Name of the tablespace
Schema: Owner of the lock
Table Name: Name of the table
Application: Name of the application
Client Workstation: Name of client workstation
Blocking: Indicates if the session is blocking another one IP address of the client host