Dynamic SQL Cache Statistics by Workstation Name

This panel provides information about the dynamic SQL cache by workstation name. 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 workstation name that owns the SQL cache storage when the displayed data is collected.

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


________________ ZEDDW    VTM     O2       V540./I SE11 05/05/13  4:06:51   2 
>  Help PF1    Back PF3     Up PF7     Down PF8     Sort PF10     Zoom PF11    
>                                                                              
> A-BY AUTHID   B-ALL STMTS   C-BY TXID   *-BY WSNM   E-BY EUID                
===============================================================================
>             Dynamic SQL Cache Statistics by Workstation Name                 
>                                                                              
 EDDW                                                                          
+ *                                                                            
+ Workstation id     Entries CPU Time     Elasped Time Wait Time    GetPages   
+ ------------------ ------- ------------ ------------ ------------ --------   
+ myWorkStation-this       1 00:00:17.612 00:00:18.155 00:00:00.000   395644   
+ BATCH                    4 00:00:00.001 00:00:00.113 00:00:00.064       24   
+ IBM-67119346B51          1 00:00:53.401 00:00:54.933 00:00:00.001  1186932   
+ RRSAF                 2571 00:00:00.145 00:00:00.150 00:00:00.000     5142   
+ TSO                      6 00:00:00.004 00:00:00.038 00:00:00.013       25   
===============================================================================

Navigation

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

Fields

Workstation ID
The workstation name that is used to execute the dynamic SQL statement.
Entries
The number of dynamic SQL statements that are cached for each workstation name.
CPU Time
The accumulated CPU time of all statements that are associated with the workstation name. This time includes CPU that is consumed on an IBM® specialty engine for all statements that are associated with this workstation name.
Elapsed Time
The accumulated elapsed time that is used for all statements that are associated with this workstation name.
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 workstation name.