The data source statement cache size can be tuned using a few different methods.
可以使用一些不同的方法来调优数据库语句缓存大小。
However, you still need to be aware that the results depend on the current contents of the SQL statement cache.
不过，您仍然要记住，分析得到的结果仅取决于sql语句缓存的当前内容。
Data source statement cache size specifies the number of prepared JDBC statements that can be cached per connection.
数据源语句缓存大小指定每次连接可以缓存的经过准备的jdbc语句的数量。
The size you specify for the statement cache size should be relatively large. Typically this is in the range of 100-200.
您为语句缓存指定的大小应当相对较大，一般在100到200之间。
The size you specify for the statement cache size should be relatively large. Typically, this is in the range of 100-200.
您为语句缓存指定的大小应当相对较大，一般在100到200之间。
The number of nontransactional statements that used the binary log statement cache.
使用二进制日志缓存文件的非事务语句数量。
So when the same SQL statement is executed again, DB2 finds the previously created access plan in the statement cache and reuses the access plan.
因此，当同一个sql语句再次执行时，DB 2在语句缓存中找到此前创建的访问计划并重用它。
The DB2 optimizer stores the access plan created in the prepare phase in the SQL statement cache (also called package cache in DB2) for reuse purposes.
DB 2优化器将准备阶段中创建的访问计划存储在sql语句缓存(在DB 2中也称为包缓存)中以便重用。
The statement cache size can be configured by navigating to Resources => JDBC => Data sources => data_source => WebSphere Application Server data source properties.
要配置语句缓存大小，可以导航到Resources =>JDBC =>Datasources => data_source =>WebSphereApplicationServerdatasourceproperties。
The db2pd call gathers information about locks, transactions, applications, and the statement cache and stores this information in a text file for analysis purposes.
db 2 pd调用收集与锁定、事务、应用程序、语句缓存相关的信息，并将信息存储在一个文本文件中以供分析。
In a J2SE environment, if the statement cache is too small or the batch size too large, you may receive SQL exceptions resulting from inconsistencies in the statement cache.
在一个J2SE环境中，如果语句缓存太小或批量太大，您可能会因语句缓存中的不一致性而收到SQL异常。
In a J2SE environment, if the statement cache is too small or the batch size too large, you may receive SQL exceptions resulting from inconsistencies in the statement cache.
在一个J2SE环境中，如果语句缓存太小或批量太大，您可能会因语句缓存中的不一致性而收到SQL异常。
应用推荐