Hi All,
I am using db2v7.2 aix 5.2
I compiled an application with DFT_QUERYOPT=1 and transfer .bnd file to production that has been set up with DFT_QUERYOPT = 5 and bound it, I want to know the access plan is regarding to DFT_QUERYOPT = 1 or DFT_QUERYOPT = 5? please advise

Thanks

I assume the access plan will be that of the instance against which you run the BIND command. I think you can even specify it when you run your BIND:

BIND ... QUERYOPT ...

If you bind the application again in your new environment, it will use the optimization class specified in the BIND command.

If the optimization class is not specified in BIND, then the value of DFT_QUERYOPT db config parameter will be used. You can see the QUERYOPT column in syscat.packages to determine the optimization class used for the package.

If you have static SQL, you should probably use at least optimization level 5. Even if you have dynamic SQL I would probably use level 2 or 3 at a minimum, especially if the statements are frequently repeated and are stored in dynamic package cache.

The value of dft_queryopt is used unless the SET CURRENT QUERY OPTIMIZATION statement or the QUERYOPT option on the bind command is used.

THANK YOU ALL for your help.