EDM Snapshot Static SQL Cache Statement Detail
This panel provides static SQL cache statement detail.
The statistical data requires that monitor class 1 and ifcid 400 are started.
________________ ZESS3 VTM O2 V550./I SE11 04/02/16 15:08:18 2
> Help PF1 Back PF3 Up PF7 Down PF8
>
>
===============================================================================
> EDM Snapshot static SQL cache statement detail
> statistics require that monitor class 29 or ifcid 400 be started
>
ESS3
+
+ Insert Date 2013-03-26 Insert Time 09.53.53.42663
+ Update Date 2013-03-26 Update Time 09.53.53.45808
+
+ Statement Number 5300 Times Executed 4792
+ Getpages 21 Rows Examined 0
+ Rows Processed 0 Sorts Performed 0
+ Index Scans 0 Tablespace Scans 0
+ Buffer Writes 0 Buffer Reads 1
+ Parallel Groups Created 0 AVG Actual Degree 0
+ AVG Estimated Degree 0 AVG Planned Degree 0
+
+ #RIDs Not Used/Storage 0 #RIDs Not Used/Limits 0
+ #RIDs Overflow/Storage 0 #RIDs Overflow/Limit 0
+ #RIDs HB Join/Storage 0 #RIDs HB Join/Limit 0
+ #RIDs No IX Access 0
+
+ Elapsed Time 00:00:00.014 CPU Time 00:00:00.004
+
+ Wait for Synch I/O 00:00:00.017 Wait for Lock 00:00:00.000
+ Synch Exec Switch 00:00:00.000 Wait time Log Writer 00:00:00.000
+ Wait Othr Thread Read 00:00:00.000 Wait Othr Thread Write 00:00:00.000
+ Wait time for Latches 00:00:00.000 Wait Time Page Latch 00:00:00.000
+ Wait for Drain Lock 00:00:00.000 Wait for Drain/Claim 00:00:00.000
+ Wait Glb L-Locks 00:00:00.000 Wait Glb P/P P-Locks 00:00:00.000
+ Wait Glb Child L-Locks 00:00:00.000 Wait Glb Page P-Locks 00:00:00.000
+ Wait Glb Other L-Locks 00:00:00.000 Wait Glb other P-Locks 00:00:00.000
+ Wait for PIPE lock 00:00:00.000 Wait for PQS lock 00:00:00.000
+ Total Wait Time 00:00:00.000
+
+ Expansion Reason ACCEL Eligible NO
+ Consistency token 0E5F1F1D09F140400154015E20130326
+ Collection DSNUTILS
+ Package DSNUTILS
+
+ INSERT INTO SYSIBM . SYSPRINT ( SEQNO , TEXT ) VALUES ( : H , : H )
===============================================================================Navigation
You can scroll through the information using F7 and F8 (if the information requires more than one panel).
For
additional options
- select one of the options from the panel
- use the PF keys.
Fields
- Insert Date / Insert Time
- The date and the time when the SQL statement is inserted in the EDM pool.
- Update Date / Update Time
- The date and the time when the SQL statement is last updated.
- Statement Number
- The number of the statement from the Db2 catalog.
- Times Executed
- The number of times this static SQL statement is executed.
- Getpages
- The number of pages that are returned.
- Rows Examined
- The number of rows that are examined.
- Rows Processed
- The number of rows that are processed.
- Sorts Performed
- The number of rows that are sorted.
- Index Scans
- The number of index scans that are performed.
- Tablespace Scans
- The number of tablespace scans that are performed.
- Buffer Writes
- The number of Buffer Write operations that are performed.
- Parallel Groups Created
- The number of parallel groups that are created.
- AVG Actual Degree
- The average actual degree of parallelism for all parallel groups. This value is calculated at execution time after buffer pool negotiation and system negotiation are taken into account.
- AVG Estimated Degree
- The average estimated degree of parallelism for all parallel groups. The values for the estimated degree are calculated at bind time. They are based on the cost formula. The value for the average estimated degree is calculated at execution time.
- AVG Planned Degree
- The average planned maximum degree of parallelism for all parallel groups. This value is calculated at execution time. It is the optimal degree of parallelism that can be obtained at execution time after host variables or parameter markers are resolved and before buffer pool negotiation and system negotiation are performed.
- # RIDs Not Used/Storage
- The number of times a RID list is not used because there is not enough storage available to hold the list of RIDs.
- # RIDs Not Used/Limit
- The number of times a RID list is not used because the number of RIDs exceeds the Db2 limits.
- # RIDs Overflow/Storage
- The number of times that a RID list overflows to a work file because a RID pool storage is not available to hold the list of RIDs.
- # RIDs Overflow/Limit
- The number of times that a RID list overflows to a work file because the number of RIDs exceeds internal limits.
- # RIDs HB Join/Storage
- The number of times that appending to a RID list for a hybrid join is interrupted because a RID pool storage is not available to hold the list of RIDs.
- # RIDs HB Join/Limit
- The number of times that appending to a RID list for a hybrid join is interrupted because the number of RIDs exceeds internal limits.
- # RIDs No IX Access
- The number of times that RID list retrieval for multiple index access is not done because Db2 cannot determine the outcome of index ANDing or ORing.
- Elapsed Time
- The accumulated In-Db2 elapsed time.
- CPU Time
- The accumulated In-Db2 CPU time. This time includes CPU consumed on a Specialty Engine (SE).
- Wait for Sync I/O
- The accumulated waiting time for synchronous I/O.
- Wait for Lock
- The accumulated waiting time for lock.
- Sync Exec Switch
- The accumulated waiting time for a synchronous execution unit switch.
- Wait time Log writer
- The accumulated waiting time for log writers.
- Wait Othr Thread Read
- The accumulated wait time for read activity done by another thread.
- Wait Othr Thread Write
- The accumulated waiting time for writing activity that is done by another thread.
- Wait time for Latches
- The accumulated waiting time for latch requests.
- Wait time Page Latch
- The accumulated waiting time for page latches.
- Wait time Drain Lock
- The accumulated waiting time for drain locks.
- Wait time drain/claim
- The accumulated waiting time for drain locks that are waiting for claims to be released.
- Wait Glb L-Locks
- The accumulated waiting time for global locks.
- Wait Glb P/P P-Locks
- Accumulated wait for global P/P P-Locks for the statement. Db2 12 or later.
- Wait Glb Child L-Locks
- Accumulated wait for global child L-Locks for the statement. Db2 12 or later.
- Wait Glb Page P-Locks
- Accumulated wait for global page P-Locks for the statement. Db2 12 or later.
- Wait Glb Other L-Locks
- Accumulated wait for global other L-Locks for the statement. Db2 12 or later.
- Wait Glb Other P-Locks
- Accumulated wait for global other P-Locks for the statement. Db2 12 or later.
- Wait for PIPE lock
- Accumulated wait for pipe wait. Db2 12 or later.
- Wait for PQS lock
- Accumulated time waiting for parallel queries to synchronize between parent and child tasks. Db2 12 or later.
- Total Wait Time
- A summary of all waiting times.
- Expansion Reason
- The reason that caused the expansion. The query contains an implicit
query transformation that is caused by one of the following items:
A- The SYSIBMADM.GET_ARCHIVE built-in global variable.
B- The current temporal BUSINESS_TIME special register.
S- The current temporal SYSTEM_TIME special register.
SB- The current temporal BUSINESS_TIME special register and the current temporal SYSTEM_TIME special register.
' '- The query does not contain an implicit query transformation that is caused by the current temporal BUSINESS_TIME special register, the current temporal SYSTEM_TIME special register, or the SYSIBMADM.GET_ARCHIVE built-in global variable.
N/A- No data available.
- ACCEL Eligible
- Statement is eligible to run on an accelerator. Db2 11 or later.
- Consistency token
- The consistency token of the package for this static SQL statement.
- Collection
- The collection ID of the package for this static SQL statement.
- Package
- The package ID for this static SQL statement.
- SQL Text
- If it can be found in the Db2 catalog tables for this statement, the SQL text is displayed.