The Operator Command Interface tool provides an interface between you and the
database to perform operator SHOW and COUNTER commands. With this tool, you do not need to directly enter ISQL commands, nor do you need to issue the commands from the VSE Operator Console. |Multiple screens are used to display the set of operator commands |that you can select. You can scroll between them using the Forward and |Backward function keys.
|This tool can be invoked by selecting option 1 from the main menu or |by using the CICS transaction ID "SQOM".
|The Operator Commands menus use this syntactical notation: |
Figure 2. DBA Operator Commands Screens
|
|+--------------------------------------------------------------------------------+ || | || mm/dd/yyyy CONTROL CENTER hh:mm:ss | ||*----------------------------- OPERATOR COMMANDS -----------------------------* | ||| OPTION ===> USER ID: MSTRSRV1 | | ||| PARMS ====> _________________________________________ CICS ID: SYSTVM1 | | ||| DATABASE => SQLDBA_____________ | | ||| | | ||| 1 SHOW ACTIVE | | ||| 2 SHOW ADDRESS module name | | ||| 3 SHOW BUFFERS | | ||| 4 SHOW CONNECT ( ALL | user-id | AGENT n | LUWID id | | ||| | ACTIVE | WAITING | INACTIVE ) | | ||| 5 SHOW DBCONFIG | | ||| 6 SHOW DBEXTENT | | ||| 7 SHOW DBSPACE dbspace number | | ||| 8 SHOW INDOUBT | | ||| 9 SHOW INITPARM | | ||| 10 SHOW INVALID | | ||| 11 SHOW LOCK ACTIVE | | ||| 12 SHOW LOCK DBSPACE ( ALL | dbspace number) | | ||| | | ||*------------------------------------------------------------------ SQC11A ---* | ||Default values are shown in turquoise. | ||ENTER OPTION, PARMS, AND DATABASE NAME AND PRESS ENTER | ||ENTER F1=HELP F3=EXIT F8=FWD | |+--------------------------------------------------------------------------------+
|
|+--------------------------------------------------------------------------------+ || | || mm/dd/yyyy CONTROL CENTER hh:mm:ss | ||*------------------------- OPERATOR COMMANDS -------------------------* | ||| OPTION => __ USER ID: MSTRSRV1 | | ||| PARMS => _________________________________________ CICS ID: SYSTVM1 | | ||| DATABASE => SQLDBA__________ | | ||| | | ||| 13 SHOW LOCK GRAPH ( auth-id | AGENT n ) | | ||| 14 SHOW LOCK MATRIX | | ||| 15 SHOW LOCK USER ( ALL | auth-id | AGENT n ) | | ||| 16 SHOW LOCK WANTLOCK ( ALL | auth-id | AGENT n ) | | ||| 17 SHOW LOG | | ||| 18 SHOW LOGHIST ( ALL | n ) ( SERVICE ) | | ||| 19 SHOW POOL ( ALL | SUMMARY | DELETED | n ) | | ||| 20 SHOW PROC ( proc-name | proc-name AUTHID auth-id | | ||| | * | * AUTHID auth-id ) | | ||| 21 SHOW PSERVER ( * | procsvr-name | GROUP * | GROUP svr-group-name )| | ||| 22 SHOW STORAGE | | ||| 23 SHOW SYSTEM | | ||| 30 COUNTER ( * | counter-name ) | | ||| | | ||*------------------------------------------------------------------ SQC11B ---* | ||Default values are shown in turquoise. | ||ENTER OPTION, PARMS, AND DATABASE NAME AND PRESS ENTER | ||ENTER F1=HELP F3=EXIT F7=BWD | |+--------------------------------------------------------------------------------+
The DBA Operator Commands menus are shown in Figure 2.
The database server you are currently working with is identified in the DATABASE field shown near the top of the screen.
To execute an operator command:
For example, if you want to issue a SHOW LOCK USER on AGENT1 command against the DB2PROD database, enter:
OPTION ===> 16
PARMS ====> AGENT 1
DATABASE => DB2PROD
The result of the command will be displayed. For example, if you issued the following SHOW ACTIVE command against server SQLDBA:
OPTION ===> 1
PARMS ====>
DATABASE => SQLDBA
you would see:
Figure 3. Show Active Command Display Screen
+--------------------------------------------------------------------------------+ | mm/dd/yyyy CONTROL CENTER hh:mm:ss | |*---------------------- OPERATOR COMMAND DISPLAY SCREEN ----------------------* | || COMMAND => SHOW ACTIVE | | || DATABASE => SQLDBA | | || | | || Status of agents: | | || Checkpoint agent is not active. | | || User Agent: 3 User ID: SVSCVSAX is NIW SUBS | | || Agent is not processing and is in communication wait. | | || User Agent: 4 User ID: SQLMSTR is R/O SUBS BDFF | | || Agent is processing an operator command. | | || User Agent: 5 User ID: SVSCVSAX is NIW SUBS | | || Agent is not processing and is in communication wait. | | || 2 agent(s) not connected to an APPL or SUBSYS. | | || ARI0065I Operator command processing is complete. | | || | | || | | || | | || | | || | | |*------------------------------------------------------------------ SQC12 ----* | | | | | |F1=HELP,F3=EXIT,F4=TOP,F5=BOT,F7=BWD,F8=FWD,F12=CANCEL | +--------------------------------------------------------------------------------+
| Note: | When the Operator Command Selection Menu (Figure 2) is being displayed, F1=HELP will display an explanation of the individual commands. When the Operator Command Display Screen (Figure 3) is being displayed, F1=HELP displays help information for the screen, not for the operator command results. |
For a complete description of each operator command and appropriate parameters, refer to the DB2 Server for VSE & VM Operation manual.