According to the DB2 V8 CLI Guide and Reference, you can set the
optimization level using the DB2OPTIMIZATION CLI/ODBC Configuration
Keyword. The question is would the Stored Proc operate under that
optimization level and could you then reset it as soon as the Stored Proc
completed to have immediate effect. Possibly not because the stored proc
could be executing on a server while the CLI calling code could be on a
separate machine.
There is also a SET CURRENT QUERY OPTIMIZATION SQL statement, but I don't
know if it is a valid statement within an SQLPL stored proc.
Perhaps someone from the lab could address this.
Larry Edelstein
AC Slater wrote:
Its a SQL stored procedure ... invoked by CLI program.
"Larry" <no****@nospam.com> wrote in message
news:3F***************@nospam.com... What type of stored proc is it and how is it being invoked?
Larry Edelstein
AC Slater wrote:
Whats the simplest way to change a single stored procedures query
optimization level?
In UDB8 that is.
/F