Using the IMS Feature › DBRM - SQL Information › SQL Statement Overview (History)

SQL Statement Overview (History)

Select an SQL statement by using line command SO from either the DBRM SQL Overview panel or the SQL Summary panel to display a historical overview of the selected statement, as shown in the following panel.

APCXPSQH ----- PMA IMS Feature - SQL Overview ----------------- Row 1 to 3 of 3 
COMMAND ===>                                                   SCROLL ===> HALF
                                                                               
DBRM: TSTC4099  System: CICSSYS1  Action: FETCH     STMT#:   6227   Months: 03 
                                                                               
Line Commands: SD - SQL Details     TX - TX using the DBRM                     
                                                                               
                      Total     Total                         Total            
LC Date        Called ACTV%   CPU sec  CPU/Call RESP/Call  RESP sec            
-- ---------- ------- ----- --------- --------- --------- ---------            
   2011.01.03       1  6.20   14.3316   14.3316 39.855086   39.8550            
   2011.01.02       1  5.20   11.1317   11.1317 37.135021   37.1350            
   2011.01.01       1  6.40   14.7216   14.7216 40.007991   40.0079            
******************************* Bottom of data ********************************

SQL information is displayed for one SQL statement and one system ID for all available days.