BUFFERPOOL - Physical reads, logical reads and timing information.
BUFFER POOL——物理读、逻辑读和定时信息。
More buffer pools can be added by using the CREATE BUFFERPOOL statement.
可以使用CREATEBUFFER pool语句添加更多的缓冲池。
Take a new snapshot, and calculate the new bufferpool hit ratio as follows
获取新的快照,并计算新的缓冲池命中率,如下
By default, one buffer pool is allocated and additional buffer pools may be added using the CREATE BUFFERPOOL command.
在默认情况下分配一个缓冲池,并可以使用CREATEBUFFER POOL命令添加其他缓冲池。
You must choose a buffer pool name according to the page size you want and activate it through -alter BUFFERPOOL command.
您必须根据您想要的页面大小选择一个缓冲池名称,并通过- ALTERBUFFER POOL命令激活它。
You can also use the new BUFFERPOOL configuration parameter to create a buffer pool that corresponds to the page size of the dbspace.
也可以使用新增的BUFFER POOL配置参数创建与dbspace页大小对应的缓冲池。
This may become necessary if the table was created in a tablespace with an inadequate page size or when a separate bufferpool should be used for accessing the table.
如果创建表的表空间的页面大小不合适,或者应该用另一个缓冲区池访问表,就可能需要执行这种数据转移。
Information you enter using the BUFFERPOOL configuration parameter or onparams utility supersedes any information previously specified with the deprecated parameters.
使用BUFFER POOL配置参数或onparams工具输入的信息代替了以前用过时的参数指定的信息。
You can use the new BUFFERPOOL configuration parameter or the onparams utility to define a buffer pool for pages that correspond to each unique page size in use by your dbspaces.
可以使用新的BUFFER POOL配置参数或者onparams工具为dbspace中所有特殊页大小对应的页定义缓冲池。
When you run queries for very large audit log tables, you can end up with a situation where your database system has to read thousands of pages into the bufferpool to compute the result.
当您在大型审核日志表格中运行查询功能时,您可能会在您的数据库系统不得不向缓冲池读入数千页面以进行计算时而结束。
When you run queries for very large audit log tables, you can end up with a situation where your database system has to read thousands of pages into the bufferpool to compute the result.
当您在大型审核日志表格中运行查询功能时,您可能会在您的数据库系统不得不向缓冲池读入数千页面以进行计算时而结束。
应用推荐