Db2 System Console and Message Traffic

This panel shows Db2 subsystem console messages and Internal Resource Lock Manager (IRLM) messages. You can also issue Db2 commands from this panel.

Note: If MGSUBSYS=ACTIVE is defined in the OMEGAMON for Db2 PE Collector Realtime Customer Options (OMPEOPTS) during configuration and customization, you can view messages when you select the Db2 CONSOLE option on the OMEGAMON® Classic Interface Realtime main menu.


________________ ZCODB22  VTM     O2       V550.#P DA41 11/05/13 11:55:32   2  
> Help PF1               Back PF3               Up PF7                Down PF8  
                                                                                
>       THREAD INFORMATION:  Enter a selection letter on the top line.          
                                                                                
> A-THREAD DETAIL B-LOCK COUNTS C-LOCK WAITS     D-LOCKS OWNED  E-GLOBAL LOCKS  
> F-CURRENT SQL   G-SQL COUNTS  H-DISTRIBUTED    I-BUFFER POOL  J-GROUP BP      
> K-PACKAGES      L-RES LIMIT   M-PARALLEL TASKS N-UTILITY      O-OBJECTS       
> P-CANCEL THREAD *-DB2 CONSOLE R-DSN ACTIVITY   S-APPL TRACE   T-ENCLAVE       
> U-LONG NAMES                  W-ACCEL ACTIVITY                                
=============================================================================== 
>                    DB2 SYSTEM CONSOLE AND MESSAGE TRAFFIC                     
                                                                                
> To issue a DB2 command, type the command after DCMD and press ENTER.          
                                                                                
>DCMD                                                                           
                                                                                
> Change 10 to the number of DB2 and IRLM messages you want to display.         
                                                                                
 DCNS10                                                                         
+                         Display DB2/IRLM Messages                             
+ 11.54 DSNV401I  -DA41 DISPLAY THREAD REPORT FOLLOWS -                         
+ 11.54 DSNV402I  -DA41 ACTIVE THREADS -                                        
+       NAME     ST A   REQ ID           AUTHID   PLAN     ASID TOKEN           
+       DISCONN  DA *  2398 NONE         NONE     DISTSERV 00E4  1746           
+        V471-DEIBMIPS.IPSATA41.CC37C15A0A69=1746                               
+       RRSAF    N        5              OMPEUSER          00F4     0           
+        V437-WORKSTATION=RRSAF, USERID=OMPEUSER,                               
+             APPLICATION NAME=*                                                
+       RRSAF    T     2136              OMPEUSER KO2PLAN  00F4  1718           
+        V437-WORKSTATION=RRSAF, USERID=OMPEUSER,                               
+             APPLICATION NAME=*                                                
+       RRSAF    T       51              OMPEUSER          00F4  1719           
+        V437-WORKSTATION=RRSAF, USERID=OMPEUSER,                               
+             APPLICATION NAME=*                                                
+       RRSAF    T    19205 OMEGAMON     OMPEUSER KO2PLAN  00C8    13          
+        V437-WORKSTATION=RRSAF, USERID=OMPEUSER,                              
+             APPLICATION NAME=OMEGAMON                                        
+       DISPLAY ACTIVE REPORT COMPLETE                                         
+ 11.54 DSN9022I  -DA41 DSNVDT '-DIS THREAD' NORMAL COMPLETION                       
===============================================================================

This panel might require special authorization before you can enter Db2 commands. Type /PWD on the top line of the panel, enter a valid password when requested, then press Enter. Then follow the instructions to issue Db2 commands.

Navigation

For additional information about:

Related topics, select one of the options at the top of the panel.
Other topics, use the PF keys.

Commands

DCMD: When you type a Db2 command and press Enter, OMEGAMON for Db2 PE displays a message that indicates whether the command was issued successfully. (Do not include the subsystem recognition character in the Db2 command. OMEGAMON for Db2 PE does this for you automatically.) When OMEGAMON for Db2 PE executes DCMD, it comments out the DCMD command to prevent accidental re-execution. To issue another Db2 command, replace the comment character (>) with a hyphen (-) and enter the command as described before.
DCNS10: Displays the last nn Db2 and IRLM messages. In this case, it displays the last 10 messages.