Enabling DB2 Dynamic Statement Caching

Siebel CRM uses the DB2 global statement caching capability. Global statement caching allows dynamic SQL statements that are reexecuted to bypass the PREPARE phase after the first execution. Dynamic statements are prepared once, stored on a global statement cache, then reused many times. The Siebel application also maximizes the reuse of statement caching.

To enable global statement caching either

• Set the CACHEDYN parameter to YES in the macro DSN6SPRM when generating DSNZPARMs.

• Set CACHE DYNAMIC SQL to YES when installing DB2.