PM-Rnn.n SYSTEM71 CA, Inc. V71 08.348 11:54:20.91 CMD--> Window : 02 02 08:25 SSQ Specific SQL Information Row Level Information Statistic Information Fetched 75 Select Locks 0 Inserted 30 Update Locks 11 Updated 11 Pages Read 3 Deleted 6 Pages Written 46 Pages Requested 52 Sort Information CALC With Overflow 0 # of Sorts 1 CALC No Overflow 0 High Rows 26 VIA With Overflow 0 Low Rows 26 VIA No Overflow 0 # Rows Sorted 26 Rows Requested 52 Rows Current of Tran 0 Access Module Information Total # of DBMS Calls 210 Recompiles 2 # of Fragments Stored 0 SQL Statement Information # Processed 3
Screen Description
The Specific SQL Information screen displays SQL statistics for a specific interval.
Using this Screen
To request the SQL Information screen, press [PF9].
What To Look For
Look for values that seem higher than average. Investigate further by looking at the SQL statements processed during the interval.
|
Copyright © 2014 CA.
All rights reserved.
|
|