QAQQINI - Query options file and performance of SQL

[rob@xxxxxxxxx]

Developer here is trying to shave some time off of a SQL operation in an 
imbedded rpg program.  Bulk of the time in the joblog based on the debug 
is spent in various CPI4339 - Query options retrieved file QAQQINI in 
library QUSRSYS.  Sure calls this alot.  Spends more time reading this 
file than access path considerations, OPEN's, PREPARE's, etc.  I can't 
think of anything to do, on my end, to reduce the CPI4339 times.  I 
suppose I need to point this out to IBM as 'an area of concentration of 
effort'.

Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com