DbtuTools project - Documentation - Reference

dbtuwho

This is a tool that lists information about the current connections with additional information like the Idle Time.

                 .---------------------------------.
                 V                                 |
>>--- dbtuwho -------+-------------------------+---+---><
                     |                         |
                     |   +--- --dbalias ---+   |
                     |   |                 |   |
                     +---+--- --nname -----+---+
                     |   |                 |   |
                     |   +--- --nodenum ---+   |
                     |                         |
                     +---+--- --human ---+-----+
                         |               |
                         +--- --all -----+

Syntax diagram

Calling dbtuwho without any parameters, lists the applications currently connected to the instance (in an EEE environment it lists the applications connected to the current node; on the system catalog node all applications connected to any node are listed).

The parameters --dbalias, --nname and --nodenum enable additional fields in the output (see list later on).
The --human parameter prints fields in human readable format (for example when communicating with TCP/IP between client and server, the "Application ID" is displayed as an IP address instead).
The --all parameter enables all other options.

[db2ngx][ls0033][/db2/db2ng1][0] > dbtuwho

DBTUWHO V00.99/R010

(A) = Connection type

    DB       Auth     Appl.        Appl.  Application          Idle    Client   Client Application Id /                Server
(A) Name     Id       Name         Handle Status               Time    Login    PID    Network Informations            PID(s)
--- -------- -------- ------------ ------ -------------------- ------- -------- ------ ------------------------------- ------>
DB  NGX      DB2NGX   db2bp            46 UOW_waiting            5 min db2ngx    17962 *LOCAL.db2ngx.020727101828      3271
DB  NGX      SAPNG2   dw.sapNG2_DV 131124 UOW_waiting             18 h ng2adm    19311 AC171505.5B89.020725065559
DB  NGX      SAPNG2   dw.sapNG2_DV 131125 UOW_waiting             18 h ng2adm    19312 AC171505.5C89.020725065600      17969
DB  NGX      SAPNG2   dw.sapNG2_DV 131126 UOW_waiting             19 h ng2adm    19313 AC171505.6389.020725065601
DB  NGX      SAPNG2   dw.sapNG2_DV 131127 UOW_waiting             19 h ng2adm    19314 AC171505.6489.020725065602
DB  NGX      SAPNG2   dw.sapNG2_DV 131128 UOW_waiting             19 h ng2adm    19315 AC171505.6589.020725065603
DB  NGX      SAPNG2   dw.sapNG2_DV 131129 UOW_waiting             19 h ng2adm    19317 AC171505.6889.020725065604
DB  NGX      SAPNG2   dw.sapNG2_DV 131130 UOW_waiting             19 h ng2adm    19316 AC171505.6989.020725065605
DB  NGX      SAPNG2   dw.sapNG2_DV 131132 UOW_waiting             19 h ng2adm    19319 AC171505.6B89.020725065607
DB  NGX      SAPNG2   dw.sapNG2_DV 131131 UOW_waiting             19 h ng2adm    19318 AC171505.6A89.020725065606
DB  NGX      SAPNG2   dw.sapNG2_DV 131133 UOW_waiting             19 h ng2adm    19320 AC171505.6C89.020725065608
DB  NGX      SAPNG2   dw.sapNG2_DV 131134 UOW_waiting             19 h ng2adm    19322 AC171505.6D89.020725065609
DB  NGX      SAPNG2   dw.sapNG2_DV 131135 UOW_waiting             19 h ng2adm    19323 AC171505.6E89.020725065610
DB  NGX      SAPNG2   dw.sapNG2_DV 131136 UOW_waiting             19 h ng2adm    19325 AC171505.6F89.020725065611
DB  NGX      SAPNG2   dw.sapNG2_DV 131137 UOW_waiting             19 h ng2adm    19324 AC171505.7089.020725065612
DB  NGX      SAPNG2   dw.sapNG2_DV 131138 UOW_waiting             19 h ng2adm    19326 AC171505.7A89.020725065613
DB  NGX      SAPNG2   dw.sapNG2_DV 131139 UOW_waiting             19 h ng2adm    19327 AC171505.7C89.020725065614
DB  NGX      SAPNG2   dw.sapNG2_DV 131140 UOW_waiting             19 h ng2adm    19328 AC171505.8089.020725065615
DB  NGX      SAPNG2   dw.sapNG2_DV 131142 Connect_completed       19 h ng2adm    19331 AC171505.8389.020725065617      17967
DB  NGX      SAPNG2   dw.sapNG2_DV 131141 UOW_waiting             19 h ng2adm    19329 AC171505.8289.020725065616
DB  NGX      SAPNG2   dw.sapNG2_DV 131143 Connect_completed       19 h ng2adm    19330 AC171505.8589.020725065618      17968
DB  NGX      SAPNG2   dw.sapNG2_DV 131144 Connect_completed       19 h ng2adm    19332 AC171505.8689.020725065619      17989
DB  NGX      SAPNG2   dw.sapNG2_DV 131145 Connect_completed       19 h ng2adm    19333 AC171505.8B89.020725065620      17999
DB  NGX      SAPNG2   dw.sapNG2_DV 131146 UOW_waiting             18 h ng2adm    19334 AC171505.8C89.020725065521      17987,18514   
DB  NGX      SAPNG2   dw.sapNG2_DV 131147 Connect_completed       19 h ng2adm    19335 AC171505.9489.020725065522      18246
DB  NGX      SAPNG2   dw.sapNG2_DV 131148 Connect_completed       19 h ng2adm    19336 AC171505.9589.020725065523      17986

[db2ngx][ls0033][/db2/db2ng1][0] > _

Sample output

After collecting and parsing all data, every connection is listed (one connection for each line). For every connection you will find the following information:

The connection type (DB or DCS; currently only DB is implemented).
Optional: The coordination node number.
The database name (name of the database the application is connected to).
Optional: The client db alias (db alias the application is connected to).
The authentication ID (ID used for the connection to the database).
The application name (name of the executable which has established the connection).
The application handle (set by the Database Manager and usable to force the application, ...).
The application status (current status of the agent associated with the application).
The idle time (time since last change in application status; please note, the values are rounded down, so 119 secs are 1 min).
Optional: The client NNAME.
The client login (ID used to login at the client computer).
The client PID (process ID of the application running at the client side).
Inbound communication address (contains information related to the used communication protocol and information like the connection time).
The server PID's (process ID's of all the agents working for the connection on this node).