Appendix A. Set up scripts 347
CREATE REGULAR TABLESPACE SIEBEL_16K IN DATABASE PARTITION GROUP
IBMDEFAULTGROUP PAGESIZE 16384 MANAGED BY DATABASE USING(
DEVICE '/dev/rvpath0cont05lv' 131072,
DEVICE '/dev/rvpath0cont06lv' 131072
)EXTENTSIZE 32
PREFETCHSIZE 64
BUFFERPOOL BUFF16K;
CREATE REGULAR TABLESPACE SIEBEL_32K IN DATABASE PARTITION GROUP
IBMDEFAULTGROUP PAGESIZE 32768 MANAGED BY DATABASE USING(
DEVICE '/dev/rvpath0cont07lv' 65536,
DEVICE '/dev/rvpath0cont08lv' 65536
)EXTENTSIZE 32
PREFETCHSIZE 64
BUFFERPOOL BUFF32K;
A.2 Database scripts for Windows
This section provides sample DB2 database creation and configuration scripts for
a Windows operating system.
A.2.1 Setting DB UDB registry variables
db2set DB2_HASH_JOIN=NO
db2set DB2_CORRELATED_PREDICATES=YES ...