DB2 Server for VSE & VM: Interactive SQL Guide and Reference

SHOW 



>>-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-----------------------------+
           |       (1)                          |
           '-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 parameters WAITING and USERS are not applicable to DB2 Server for VSE

SHOW is an operator command used primarily to monitor system activity. It is not allowed during an LUW, and you must end an LUW that is in progress before issuing SHOW.

The SHOW command can only be used when the target application server is a local application server. It cannot be used when the application server is a remote application server.

See the DB2 Server for VSE & VM Operation manual for a description of the keywords used on this command and for a description of the information displayed.

This command results in one or more displays.
DB2 Server for VSE

Instructions for proceeding to the next display of data or ending the display are provided in the status area.

DB2 Server for VM

Instructions for proceeding to the next display of data or ending the display are provided in the output area.

When using the SHOW DBSPACE command, replace dbspace-number with the number of the particular dbspace for which you want information.

The SHOW command is not available on non-DB2 Server for VSE & VM application servers or if you are using the DRDA protocol.
Note:If the national language of the application server differs from the national language that the user has set for the ISQL session, the messages generated by this operator command are issued in the national language of the application server.

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]