Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.
Hi All,
Can any body help me in understanding why prepared statement cache size for example Statement cache size is 10 what does it mean? please suggest?
kalyan.
That is just a default setting. One needs to change this value based on how many unique SQL prepared statements are used. Generally, the way I modify this parameter is to use PMI to monitor the prepared statement cache discard count. When the cache is too small the count continues to rise. When the cache is the right size the discard count will remain at zero.
Some URLs for you to read regarding this topic:
https://www.ibm.com/support/knowledgecenter/SSAW57_8.5.5/com.ibm.websphere.nd.doc/ae/udat_jdbcdatasorprops.html
http://www-01.ibm.com/support/docview.wss?uid=swg21108496
There is another article that might also helps.
"Tuning Connection Pool Properties In WebSphere Application Server"https://www.ibm.com/developerworks/community/blogs/aimsupport/entry/tuning_connection_pool_properties_in_websphere_application_server?lang=en
Instead of directing you to articles, this is the number of SQL statements that are cached per connection to that specific datasource. This cuts down on the time it takes to create a statement from scratch. Most calls using a Datasource have a certain number of calls that are repeated and it is more effecient to cache them. However, each statement that is cached takes up some memory per connection.
Regards, Brian