db2 外置设备建立数据库步骤

db2set db2comm=tcpip

db2set db2codepage=1386

db2set DB2_COLLECT_TS_REC_INFO=OFF

db2 terminate

 

db2 create db $DBM_NAME using codeset gbk territory CN collate using identity

 

db2 connect to $DB_NAME user $DB_USER

db2 drop tablespace userspace1

 

db2 create bufferpool BP32K all nodes size -1 pagesize 32K

 

db2 "create large tablespace tablespace_32K pagesize 32K managed by database using(device '/dev/rLR_gydbusr2' 99G) bufferpool BP32K"

#db2 "alter tablespace tablespace_32K add(file '/XXX' 99M)"

 

db2 "create system temporary tablespace TMP_32K pagesize 32K managed by system using ('$HOME/$LOGNAME/NODE0000/$DBM_NAME_TMP32K') bufferpool BP32K"