SQL Performance Analysis: SYSPRINT

 
________________ ZSQPO03  VTM     O2       V540./C DB51 11/07/13 13:14:07   2  
> Help PF1         Back PF3            Up PF7              Down PF8             
>                                                                               
>                  SQL PA Analysis: SYSPRINT Output                             
>                                                                               
> A-EXPLAIN   B-QLIMIT    C-QTRACE    *-SYSPRINT  E-ANLSQL    F-JOBERR          
>                                                                               
=============================================================================== 
 SQPO                                                                           
> Report=000061 Plan=**NONE** Package=**NONE** Date=2013-11-07 Time=13.09.10    
1 ============================================================================= 
0                 *** SQL Performance Analyzer * SQL PA * 5655-W60 ***          
                                                                                
 ANLSQLPA Program begins at: 13:09:11.813   on   11-07-2013 Version 4.1.35 41-4 
                                                                           PM75 
                                                                                
                                                                                
 ANL3042I Processing SQL from SYS1PMO.OCN8.F51.DB51.S000003E.ANLSQL             
                                                                                
 ANL1025I Because the QUALIFY parameter was set to blanks, pgm assumes Synonym  
          Pgm will use the PLAN_TABLE under the Primary Authid DB2PM    for thi 
          Automatic synonyms reaction is taken by pgm. Processing continues.    
                                                                                
 ANL0003T Parsed statement  100000001 Length (   39):                           
 SELECT COUNT(*) FROM SYSIBM.SYSCOLUMNS                                         
                                                                                
                                                                                
  DSNT404I SQLCODE = 20520, WARNING:  ATTEMPT TO USE A DEPRECATED FEATURE, REAS 
  DSNT418I SQLSTATE   = 01694 SQLSTATE RETURN CODE                              
  DSNT415I SQLERRP    = DSNXOD0Z SQL PROCEDURE DETECTING ERROR                  
  DSNT416I SQLERRD    = 20  0  1  1077172992  0  0 SQL DIAGNOSTIC INFORMATION   
  DSNT416I SQLERRD    = X'00000014'  X'00000000'  X'00000001'  X'40345B00'  X'0 
           INFORMATION                                                          
                                                                      
                                                                                
 ANL2021W The VERSION is set to V10R, but V11R was detected and used. Update th 
                                                                                
  SQL PA Analysis for Queryno 100000001                                         
                                                                                
  SELECT COUNT(*)                       
  FROM SYSIBM.SYSCOLUMNS                                                        
                                                                                
 ANL3017I No statistic for "  CARDF " on table SYSIBM  .SYSCOLUMNS              
          Optimizer default used for Queryno  100000001