缓冲池及表空间

--create database partition group IBMDEFAULTGROUP on all dbpartitionnums;
--create database partition group IBMTEMPGROUP on all dbpartitionnums;
--create database partition group IBMCATGROUP on all dbpartitionnums;
--Create bufferpool IBMDEFAULTBP immediate  size 262144 pagesize  8K;
alter  bufferpool IBMDEFAULTBP deferred  size 262144 ;
Create bufferpool BP_SHARE_32K immediate  size -1 pagesize  32K;
alter bufferpool BP_SHARE_32K deferred size 131072;




Create SYSTEM TEMPORARY tablespace TS_SYSTMP_32K pagesize  32K managed by SYSTEM
using ( '/tmis/mtbs/systmp32k0',
        '/tmis/mtbs/systmp32k1')
extentsize  8
prefetchsize  128
bufferpool BP_SHARE_32K;




Create LARGE tablespace TS_PPD_8K pagesize  8K managed by DATABASE
using (DEVICE '/dev/rlv_md_ppd0'  20G,
       DEVICE '/dev/rlv_md_ppd1'  20G)
extentsize  8
prefetchsize  128
bufferpool IBMDEFAULTBP;




Create LARGE tablespace TS_PPX_8K pagesize  8K managed by DATABASE
using (DEVICE '/dev/rlv_md_ppx0'  20G,
       DEVICE '/dev/rlv_md_ppx1'  20G)
extentsize  8
prefetchsize  128
bufferpool IBMDEFAULTBP;




Create LARGE tablespace TS_PD_8K pagesize  8K managed by DATABASE
using (DEVICE '/dev/rlv_md_pd0'  20G,
       DEVICE '/dev/rlv_md_pd1'  20G)
extentsize  8
prefetchsize  128
bufferpool IBMDEFAULTBP;




Create LARGE tablespace TS_PX_8K pagesize  8K managed by DATABASE
using (DEVICE '/dev/rlv_md_px0'  20G,
       DEVICE '/dev/rlv_md_px1'  20G)
extentsize  8
prefetchsize  128
bufferpool IBMDEFAULTBP;




Create LARGE tablespace TS_LD_32K pagesize  32K managed by DATABASE
using (DEVICE '/dev/rlv_md_ld0'  10G,
       DEVICE '/dev/rlv_md_ld1'  10G)
extentsize  8
prefetchsize  128
bufferpool BP_SHARE_32K;




Create LARGE tablespace TS_LX_32K pagesize  32K managed by DATABASE
using (DEVICE '/dev/rlv_md_lx0'  10G,
       DEVICE '/dev/rlv_md_lx1'  10G)
extentsize  8
prefetchsize  128
bufferpool BP_SHARE_32K;




Create LARGE tablespace TS_ETLD_32K pagesize  32K managed by DATABASE
using (DEVICE '/dev/rlv_md_etld0'  5G,
       DEVICE '/dev/rlv_md_etld1'  5G)
extentsize  8
prefetchsize  128
bufferpool BP_SHARE_32K;