Hi,

I am doing some benchmarking on an SQL Query with DB2 for iSeries.
DB2 for iSeries automatically caches the access plan and ODP, which makes it almost impossible to measure the time the Optimizer takes to build an access plan.

Is there any way to bypass the cache, to tell DB2 that you don't want to use the cache for this statement? In the QAQQINI file maybe? Or with a statement?

Thanks,
Eric

I found it in the meantime: SYSTEM_SQL_STATEMENT_CACHE = *NO in QAQQINI...