I plan to adjust the setting for DFT_QUERYOPT and would like to find out what other things I need to do after the parameter is changed.

Are these steps necessary? Am I missing anything else?
1. Recycle instance
2. Run db2rbind
3. Execute FLUSH PACKAGE CACHE

Please advise and thank you in advance for your assistance.

Clara

pray......

Yes, prayers certainly helped : )

Thank you and I was able to resolve the temp tablespace full error after adjusting the DFT_QUERYOPT cfg parameter.

Thanks again!

No use. The queryopt value cannot be overruled. You will have to bind again, rebind of existing packages will have no effect.