I have a complex piece of query that compiles for about 7-8 seconds, follwed by 4-5 seconds execution.
How can I decrease the compile time? Are there any configuration parameters?

As this query is run from a tool, it is not possible to decrease the optimization level or to use parameter markers.

Environment : DB2 V8.2 - RH Linux

TIA
Soundh

You could try setting DB2_REDUCED_OPTIMIZATION (see documentation for possible values). Obviously, this is going to affect all queries, not just the one you're concerned about.

or try including set current query optimization 0 in your sql