Default language.

Dynamic SQL Miniplan summary report (THSQLDYS)

The following figure shows a sample of the Dynamic SQL Miniplan summary report (THSQLDYS).

Related topic

Accounting-reports

                       THSQLDYS: DYNAMIC SQL/MINIPLAN SUMMARY                           07/21/05 08:17:22    PAGE     1

   Expands      : S-Details                                                                                             
   Zooms        : X-Explain  (From Dyn SQL Stmt only following an S-Expand)                                             
   DS Group     :              Member :                                                                                 
   DB2 SSID     : DECE 8.1                                                                                              
   Period Begin : 07/21/05 06:57:36           IFCID 22 (Mini-plan)   :        8                                         
                                              IFCID 63 (Dynamic SQL) :        8                                         
   Event Time               Type     Auth     Plan     Conn     Corr                                                    
   ------------------------ -------- -------- -------- -------- ------------                                            
+  07/21/05 07:55:31.532231 DYN SQL  DMRQA02  DISTSERV SERVER   REXX.EXE                                                
+  07/21/05 07:55:31.534203 MINIPLAN DMRQA02  DISTSERV SERVER   REXX.EXE                                                
+  07/21/05 07:55:31.652252 MINIPLAN DMRQA02  DISTSERV SERVER   REXX.EXE                                                
+  07/21/05 07:55:32.128883 DYN SQL  DMRQA01  DISTSERV SERVER   REXX.EXE                                                
+  07/21/05 07:55:32.130850 MINIPLAN DMRQA01  DISTSERV SERVER   REXX.EXE                                                
+  07/21/05 07:55:32.130991 MINIPLAN DMRQA01  DISTSERV SERVER   REXX.EXE                                                
+  07/21/05 07:55:34.696692 DYN SQL  DMRQA02  DISTSERV SERVER   REXX.EXE                                                
+  07/21/05 07:55:37.711262 DYN SQL  DMRQA01  DISTSERV SERVER   REXX.EXE                                                
+  07/21/05 07:55:38.577798 DYN SQL  DMRQA02  DISTSERV SERVER   REXX.EXE                                                
+  07/21/05 07:55:38.580172 MINIPLAN DMRQA02  DISTSERV SERVER   REXX.EXE                                                
+  07/21/05 07:55:38.580395 MINIPLAN DMRQA02  DISTSERV SERVER   REXX.EXE                                                
+  07/21/05 07:55:40.716223 DYN SQL  DMRQA02  DISTSERV SERVER   REXX.EXE                                                
+  07/21/05 07:55:42.308246 DYN SQL  DMRQA01  DISTSERV SERVER   REXX.EXE                                                
+  07/21/05 07:55:42.310327 MINIPLAN DMRQA01  DISTSERV SERVER   REXX.EXE                                                
+  07/21/05 07:55:42.310377 MINIPLAN DMRQA01  DISTSERV SERVER   REXX.EXE                                                
+  07/21/05 07:55:44.351340 DYN SQL  DMRQA01  DISTSERV SERVER   REXX.EXE


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*