应该打开因为系统performance监控总是需要的
两个参数的生效条件是不一样的。当 SYSCAT.BUFFERPOOLS 目录表中该缓冲池的 NPAGES 值为 -1 时,DB2 数据库配置参数 BUFFPAGE 控制着缓冲池的大小。否则会忽略 BUFFPAGE 参数,并且用 NPAGES 参数所指定的页数创建缓冲池。...
假设你的bufferpool size is ample large enough, 那就是SQL的问题: 就是说data reuse in bufferpool is low
看错误应该是insufficient memory 是不是指的bufferpool太大了?A的缓冲池是哪个?如果不是指定的新建的这个bufferpool,应该没问题
newly created table/partition remains same tablespace, and therefore same bufferpoolyou can extract DDL to confirm this
1. most of us will use the traditional way 2. if you know your data well and your application will benefit from sequential prefetch, you could set aside a portion of buffer pool for block-based I/O for better performance
create bufferpool bp16K size 10000 pagesize 16K感觉是数据库级的,如何看当前数据库下有几个bufferpool?