Dynamic SQL Cache Statement Summary by Key Field

This panel displays the statements in dynamic SQL cache that belong to a specific key value. The key type and the key value are displayed in the heading like this: key_type : key_value.

The following key types are supported:

Key type: Key value
Authorization ID: QW0316X4
Transaction ID: QW0316T2
Workstation Name: QW0316XF
End User ID: QW0316XE

With this panel, you can identify problem statements in the dynamic SQL cache.

To sort the output by column, move the cursor under a column heading and press the sort key (PF10).

 ________________ ZEDD2    VTM     O2       V540.#P DC11 05/19/16 18:51:02   2  
>  Help PF1    Back PF3    Up PF7     Down PF8    Sort PF10    Zoom PF11        
>                                                                               
=============================================================================== 
>       Dynamic SQL Cache Statement Summary by Key Field                        
>                                                                               
 EDD2                                                                           
+             Authorization Id: HONG2                                           
+                                                                            *  
+                                                                          ACEL 
+Len  CPU Time     SQL Text                                                 DPS 
+---- ------------ ------------------------------------------------------- ---- 
+  34 00:00:40.278 SELECT * FROM SYSIBM.SYSCOLUMNS A1                      N Y  
+  34 00:00:00.000 SELECT COUNT(*) FROM HONG.RLOCKTB1                      N Y  
+  34 00:00:44.894 SELECT * FROM SYSIBM.SYSCOLUMNS B1                      N Y  
+ 130 00:00:00.017 SELECT CURRENT APPLICATION ENCODING  SCHEME, INTEGER(CU N Y  
+  34 00:00:00.000 SELECT COUNT(*) FROM HONG.RLOCKTB2                      N Y  
+  72 00:00:00.000 SELECT COUNT(*) FROM SYSIBM.SYSKEYS NOWTWO              N N  
+  72 00:00:00.000 SELECT COUNT(*) FROM SYSIBM.SYSKEYS JUSTONE             N N  
===============================================================================

Navigation

For additional information about

detailed dynamic SQL cache information for an transaction ID, move the cursor to the desired line and press F11 (Zoom).
the statistics detail for a particular statement, place the cursor on the row that contains the statement and press PF11.
other topics, use the PF keys.

Fields

Each field reflects the data that is available when collection is executed.

Length: The statement length of the SQL text in dynamic SQL cache.
CPU Time: The accumulated CPU time. This time includes CPU time that is consumed on an IBM® specialty engine.
SQL text: The first 60 bytes of the SQL text of the statement.
ACEL: IDAA flag.
DPS: Dynamic Plan Stability flag (dynamic SQL only). DB2 12 only.

Feedback