SQL Performance Analysis: Enhanced Explain

This panel shows an Enhanced Explain report of the report selected in the SQL Performance Analysis: Available Reports panel.


________________ ZSQPO00  VTM     O2       V550./C DB51 11/07/13 13:10:25   2  
> Help PF1         Back PF3            Up PF7              Down PF8             
>                                                                               
>                  SQL PA Analysis: EXPLAIN Output                              
>                                                                               
> *-EXPLAIN   B-QLIMIT    C-QTRACE    D-SYSPRINT  E-ANLSQL    F-JOBERR          
>                                                                               
=============================================================================== 
 SQPO                                                                           
> Report=000061 Plan=**NONE** Package=**NONE** Date=2013-11-07 Time=13.09.10    
13:09:11.813               SQL Performance Analyzer               Version  4.1. 
 11-07-2013                Enhanced Explain Report                Level  41-413 
                                                                  APAR   PM7540 
                                                                                
                            SQL PA Parameters                                   
(ANLPARM)                                                                       
   VERSION V10R1                                                                
   DEGREES ONE                                                                  
   BUFFHIT 0                                                                    
   DBRMKEY +OFF+                                                                
   USEPLAN +OFF+                                                                
   QUALIFY                                                                      
   SYNONYM                                                                      
   EXPLAIN NEW                                                                  
   EEECALL SPA                                                                  
   QUERYNO 1                                                                    
   STOPQNO 999999999                                                            
   CONNECT CAF                                                                  
   REFRESH NO                                                                   
   VIADRDA +OFF+                                                                
   RETCODE NO                                                                   
   DELIMIT +OFF+                                                                
   DSN8EXP NO                                                                   
   NLSCODE +OFF+                                                                
   KEEPLAN NO                                                                   
   PROCESS +OFF+                                                                
   PROCESS +OFF+                                                                
   NUMBERS YES                                                                  
   REPORTS DET                                                                  
   SHOWALT NO                                                                   
   PRECISE NO                                                                   
   ADVISOR NO                                                                   
   OBJECTS NO

Navigation

You can scroll through the report using F7 (Up) and F8 (Down). F3 (Back) returns to the SQL Performance Analysis: Available Reports panel.

You can select a different report type by choosing one of the options from the menu.