DB2 Server for VSE & VM: Quick Reference

Operator Commands

The following operator commands can be used within ISQL, or entered from the database machine operator console. For the complete set of operator commands, see the DB2 Server for VSE & VM Operation manual.

COUNTER

Used primarily to monitor system performance.

>>-COUNTER----+-*-----------+----------------------------------><
              |  .--------. |
              |  V        | |
              '----name---+-'
 

Valid names are:

BEGINLUW	DBSSCALL	LDIRBUFF	PAGEREAD
CHKPOINT	DEADLCK	LOCKLMT	PAGWRITE
DASDIO	DIRREAD	LOGREAD	RDSCALL
DASDREAD	DIRWRITE	LOGWRITE	ROLLBACK
DASDWRIT	ESCALATE	LPAGBUFF	WAITLOCK

SHOW

Monitors system activity.

>>-SHOW----+-ACTIVE-----------------------------+--------------><
           +-ADDRESS--module_name---------------+
           +-BUFFERS----------------------------+
           |          .-ALL------------------.  |
           +-CONNECT--+----------------------+--+
           |          +-+--------+--userid1--+  |
           |          | '-USERID-'           |  |
           |          +-AGENT--agent_no------+  |
           |          +-LUWID--luwid1--------+  |
           |          +-ACTIVE---------------+  |
           |          +-INACTIVE-------------+  |
           |          |         (1)          |  |
           |          '-WAITING--------------'  |
           +-DBCONFIG---------------------------+
           +-DBEXTENT---------------------------+
           +-DBSPACE--dbspace_number------------+
           +-INVALID----------------------------+
           +-LOG--------------------------------+
           |          .-ALL-----.               |
           +-LOGHIST--+-integer-+---+---------+-+
           |                        '-SERVICE-' |
           +-LOCK--| lock parameters |----------+
           |       .-ALL---------.              |
           +-POOL--+-------------+--------------+
           |       +-SUMMARY-----+              |
           |       +-DELETED-----+              |
           |       '-pool_number-'              |
           +-STORAGE----------------------------+
           +-SYSTEM-----------------------------+
           |       (2)                          |
           '-USERS------------------------------'
 
lock parameters
 
   .-MATRIX----------------------------------------.
|--+-----------------------------------------------+------------|
   +-ACTIVE----------------------------------------+
   +-DBSPACE--+-ALL------------+-------------------+
   |          '-dbspace_number-'                   |
   +-GRAPH--+-+--------+--authorization_name--+----+
   |        | '-USERID-'                      |    |
   |        '-AGENT--agent_number-------------'    |
   |       .-ALL-----------------------------.     |
   +-USER--+---------------------------------+-----+
   |       +-+--------+--authorization_name--+     |
   |       | '-USERID-'                      |     |
   |       '-AGENT--agent_number-------------'     |
   |           .-ALL-----------------------------. |
   '-WANTLOCK--+---------------------------------+-'
               +-+--------+--authorization_name--+
               | '-USERID-'                      |
               '-AGENT--agent_number-------------'
 

Notes:

1. The SHOW CONNECT WAITING is not supported in the VSE environment.

2. The keyword USERS is not applicable to a VSE system.