|
|
|
To display SQL statements that exceed the threshold values, select a DBRM by using line command SS.
APCDPSQO - PMA - CICS 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
For each statement, you can see the CPU consumption, the statement number of the SQL statement, the action and the first part of the actual SQL statement.
If there are cumulative consumption values, the displayed threshold refers to the source value.
| Copyright © 2011 CA. All rights reserved. | Tell Technical Publications how we can improve this information |