Using the CICS Feature › SQL Statement Information - SQL Summary

SQL Statement Information - SQL Summary

The SQL Summary panel is displayed when option S is entered on the CICS Feature Menu.

APCXPSQL - PMA - CICS Feature SQL-Summary -------------------- Row 1 from 1803 
COMMAND ===>                                                   SCROLL ===> HALF
                                                                               
Line Commands: DO -DBRM Overview  SD -SQL Details  SO -SQL Overview            
                                                                               
DBRM: *         Date: 2011.01.15  System: *                                    
                                                                               
                          Total     Total                                      
LC Action   Stmt#  Called ACTV%   CPU sec  CPU/Call RESP/Call DBRM     System  
-- ------- ------ ------- ----- --------- --------- --------- -------- --------
   FETCH     6227       1  6.20   14.3316 14.331662 39.855086 TSTC4099 CICSSYS1
   SELECT    5493      27 16.71   38.6073  1.429901  1.990510 TSTC4099 CICSSYS1
   SELECT    6328       3  1.47    3.4009  1.133653  2.618793 TSTC4099 CICSSYS1
   OPEN       500       1  0.11    0.2770  0.277061  0.606578 TSACBB11 CICSSYS1

The SQL Summary panel provides a central overview about the DB2 activities for all DBRMs that exceed the threshold value.