Using the IMS Feature › DBRM - SQL Information › SQL Statements Exceeding Thresholds

SQL Statements Exceeding Thresholds

SQL statements that exceed the threshold values can be displayed by:

• Selecting a specific plan by using line command SS on the Plan panel, or
• Selecting a history record for a plan by using line command SS on the Plan Overview panel

   APCDPSQO - PMA - IMS Feature DBRM SQL Overview ------------- Row 1 to 11 of 19 
   COMMAND ===>                                                   SCROLL ===> HALF
                                                                                  
   Line Commands:  SD -SQL Details  SO -SQL Statement Overview                    
                                                                                  
   Date   : 2011.01.15      DBRM ACTV%   :     28.29                              
   System : CICSSYS1             CPU sec :   65.4662                              
   DBRM   : TSTD4099             RESP sec:  118.5100                              
   Created:                      Thresh.%:      0.01                              
                                                                                  
                              Total     Total     Total                           
   LC Action    Stmt#  Called ACTV%   CPU sec  RESP sec  CPU/Call RESP/Call       
   -- -------- ------ ------- ----- --------- --------- --------- ---------       
      SELECT     5493      27 16.71   38.6073   53.7437  1.429901  1.990510       
      FETCH      6227       1  6.20   14.3316   39.8550 14.331662 39.855086       
      FETCH      5962     719  3.87    8.9418   10.6731  0.012436  0.014844       
  
  
  
  

The SQL Statements panel shows the plan name, measurement date, system, and the total CPU consumption and the threshold value for the plan statements. Up to 10 SQL statements are shown that exceed the threshold value. For each statement, the IMS Feature presents the CPU consumption (in % of the IMS region and in seconds), the action and the first part of the SQL statement.

If there are cumulative consumption values, the displayed threshold refers to the source value.