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

COUNTER



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

COUNTER is an operator command that is used primarily to monitor system activity. It is not allowed during a logical unit of work. Before typing COUNTER, you must end any logical unit of work that is in progress.

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.

*
specifies that all counters are to be displayed.

name
is the name of the counters to be specified. Valid names are:

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

For an explanation of these counters, see the DB2 Server for VSE & VM Operation manual.

The COUNTER command results in one or more displays. To proceed to the next display, press CLEAR. It is not possible to move backward. You must first type the END command, and then retype the COUNTER command. To exit from the COUNTER command, type END. The COUNTER command is not available on a non-DB2 Server for VSE & VM application server or if you are using DRDA protocol.
Note:If the national language of the application server differs from the national language that the user 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 ]