Take a new snapshot, and calculate the new bufferpool hit ratio as follows
获取新的快照,并计算新的缓冲池命中率,如下
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.
如果创建表的表空间的页面大小不合适,或者应该用另一个缓冲区池访问表,就可能需要执行这种数据转移。
BUFFERPOOL - Physical reads, logical reads and timing information.
BUFFER POOL——物理读、逻辑读和定时信息。
By default, one buffer pool is allocated and additional buffer pools may be added using the CREATE BUFFERPOOL command.
在默认情况下分配一个缓冲池,并可以使用CREATEBUFFER 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页大小对应的缓冲池。
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中所有特殊页大小对应的页定义缓冲池。
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中所有特殊页大小对应的页定义缓冲池。
应用推荐