|
|
|
ReportCenter uses the JDBC API, which means that all SQL is dynamic.
There are several DB2 tuning parameters related to dynamic SQL performance, such as the CACHEDYN parameter and the KEEPDYNAMIC bind option.
Use of these parameters must be evaluated by your DBA, taking into account your specific environment.
The effectiveness of dynamic SQL caching depends, among other things, on the mix of applications in the DB2 subsystem. Applications with large volumes of dynamic SQL requests can swamp the statement cache, to the detriment of less active dynamic applications. Such caching also requires supporting buffer storage.
If your dynamic SQL cache resides in a data space, then there are related tuning variables to consider.
| Copyright © 2012 CA. All rights reserved. |
|