Dynamic SQL Cache Statistics by End User ID

This panel provides information about the dynamic SQL cache by end user ID. You can also look at the dynamic SQL cache by authid, end user ID, or transaction ID.

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

One line of output is produced for each end user ID that owns the SQL cache storage when the displayed data is collected.

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


 ________________ ZEDDU    VTM     O2       V540./I SE11 05/05/13  4:08:16   2  
>  Help PF1    Back PF3     Up PF7     Down PF8     Sort PF10     Zoom PF11     
>                                                                               
> A-BY AUTHID   B-ALL STMTS   C-BY TXID   D-BY WSNM   *-BY EUID                 
=============================================================================== 
>             Dynamic SQL Cache Statistics by End User ID                       
>                                                                               
 EDDU                                                                           
+ *                                                                             
+ End User id        Entries CPU Time     Elasped Time Wait Time    GetPages    
+ ------------------ ------- ------------ ------------ ------------ --------    
+ myUserID-this is         1 00:00:17.612 00:00:18.155 00:00:00.000   395644    
+ HONG                  2576 00:00:53.547 00:00:55.084 00:00:00.001  1192080    
+ HONG1                    6 00:00:00.005 00:00:00.150 00:00:00.078       43    
===============================================================================

Navigation

For additional information about
  • detailed dynamic SQL cache information for an end user ID, move the cursor to the line you want and press F11 (Zoom).
  • other topics, use the PF keys.

Fields

End user ID
The end user ID that is used to execute the dynamic SQL statement.
Entries
The number of dynamic SQL statements that are cached for each end user ID.
CPU Time
The accumulated CPU time of all statements that are associated with the end user ID. This time includes CPU that is consumed on an IBM® specialty engine for all statements that are associated with this end user ID.
Elapsed Time
The accumulated elapsed time that is used for all statements that are associated with this end user ID.
Wait Time
The accumulated wait time that is used for all statements that are associated with the authorization ID including the following items:
  • Wait for Synch I/O (QW0316W1)
  • Wait for Lock/Latch (QW0316W2)
  • Wait Synch Exec Switch (QW0316W3)
  • Wait for Global Locks (QW0316W4)
  • Wait Other Thread Read (QW0316W5)
  • Wait Other Thread Write (QW0316W6)
  • Wait for Latch Req (QW0316W7)
  • Wait Time Page Latch (QW0316W8)
  • Wait for Drain Lock (QW0316W9)
  • Wait for Drain/Claim (QW0316WA)
  • Wait for Log Writer (QW0316WB)
  • Wait global child L-Locks (QW0316WC)
  • Wait global other L-Locks (QW0316WD)
  • Wait global P/P P-Locks (QW0316WE)
  • Wait global page P-Locks (QW0316WF)
  • Wait global other P-Locks (QW0316WG)
  • Wait for PQS (QW0316_PQS_WAIT)
  • Wait for PIPE (QW0316_PIPE_WAIT)
GetPages
The accumulated GET PAGES for all statements that are associated with the end user ID.