IBM BPM, V8.0.1, All platforms > Tuning > Tuning parameters
DataSource prepared statement cache size
The prepared statement cache optimizes the processing of prepared SQL statements and callable statements. The size of the cache can be tuned to avoid cache entries from being discarded.
To tune the size of the cache from the administrative console, navigate to Resources > JDBC > Data sources > datasource_name > WebSphere Application Server data source properties.
The BPEDB DataSource in IBM BPM makes extensive use of prepared statements. The statement cache size of this DataSource must be at least 128. The number of cache discards for a data source can be monitored using the Tivoli Performance Viewer in the administrative console.