SELECT BPNAME,NPAGES,PAGESIZE FROM SYSCAT.BUFFERPOOLS
修改缓冲池大小:
ALTER BUFFERPOOL <bp_name> SIZE <number_of_pages>
创建缓冲池时指定大小:CREATE BUFFERPOOL <bp_name> SIZE <number_of_pages> PAGESIZE <integer K>
删除 缓冲池:
$ db2 drop BUFFERPOOL PAY_SYS_POOL
举例:
$ db2 "CREATE BUFFERPOOL PAY_SYS_POOL SIZE 8192 PAGESIZE 8192" --创建缓冲池
DB20000I The SQL command completed successfully.
$ db2 "create tablespace EPS_SPACE_8K PAGESIZE 8K MANAGED BY DATABASE USING (FILE '/home/db2inst1/payment3/EPS_SPACE_8K' 100M) AUTORESIZE YES BUFFERPOOL PAY_SYS_POOL" --创建表空间
DB20000I The SQL command completed successfully.
$ db2move payment3 import ----导入数据