PRTSQLINF

[Jon Paris <Jon.Paris@xxxxxxxxxxxxxx>]

I have a program with embedded SQL that when compiled on a V5R4 shows this at the end of the PRTSQLINF report.

DECLARE PRODCSR CURSOR FOR SELECT * FROM PRODUCT1                   
  SQL4021  Access plan last saved on 05/08/11 at 21:46:39.   <<<<<  Plan found       
  SQL4020  Estimated query run time is 1 seconds.                   
  SQL4010  Table scan access for table 1.                           
OPEN PRODCSR                                                        
FETCH NEXT FROM PRODCSR INTO : H ,: H ,: H ,: H ,: H ,: H ,: H ,: H 
FETCH NEXT FROM PRODCSR INTO : H ,: H ,: H ,: H ,: H ,: H ,: H ,: H 

Same program, same data on a V7 system and the access plan is reported as not found.


 DECLARE PRODCSR CURSOR FOR SELECT * FROM PRODUCT1 ORDER BY PRODCD     
   SQL5065  Access plan not found.     <<<<< No plan !!!                                
 OPEN PRODCSR                                                          
 FETCH NEXT FROM PRODCSR INTO : H ,: H ,: H ,: H ,: H ,: H ,: H ,: H   
 FETCH NEXT FROM PRODCSR INTO : H ,: H ,: H ,: H ,: H ,: H ,: H ,: H   
 CLOSE PRODCSR    


I'm guessing this may be related to the differences in the Query engine etc. over the releases - but I can't find anything that describes why this occurs. Searching IBM for SQL5065 only shows up DB2 V9 on Linux - not terribly useful. 

Anyone got any ideas?  
                                                   

Jon Paris
Partner400.com

Need the best in SQL education? Check out www.DB2foriDirections.com