47 lines
1.5 KiB
Bash
47 lines
1.5 KiB
Bash
#----------------------------------------------------
|
|
# ICS 建库脚本
|
|
# 此脚本需要在db2的实例用户下执行
|
|
#----------------------------------------------------
|
|
|
|
#数据库名称
|
|
dbname=db2mid
|
|
#数据库用户名
|
|
dbuser=midadm
|
|
#数据库数据保存目录
|
|
dbdatadir=/app/db2data/${dbname}
|
|
#数据库归档日志保存目录
|
|
dbarchlogdir=/app/icsdb2bk/${dbname}/archlog
|
|
#数据库表空间大小(单位:页)
|
|
#262144 * 8K = 2G
|
|
table_space_size=262144
|
|
#索引表空间大小（页)
|
|
index_space_size=131072
|
|
|
|
#----------------------------------------------------
|
|
|
|
|
|
test -d ${dbdatadir} && mkdir -p ${dbdatadir}
|
|
test -d ${dbarchlogdir} && mkdir -p ${dbarchlogdir}
|
|
|
|
db2set DB2CODEPAGE=1386;
|
|
export DB2OPTIONS='-t';
|
|
db2 << !
|
|
-- create database
|
|
CREATE database ${dbname} ON ${dbdatadir} USING CODESET GBK TERRITORY CN COLLATE USING SYSTEM PAGESIZE 8 K USER TABLESPACE MANAGED BY DATABASE USING ( FILE '${dbdatadir}/usrts1c1' ${table_space_size} ) EXTENTSIZE 16 PREFETCHSIZE 16 ;
|
|
--db2set db2codepage=1386;
|
|
--terminate;
|
|
-- create bufferpool ,pagesize 16k
|
|
connect to ${dbname};
|
|
-- create index tablespace
|
|
CREATE REGULAR TABLESPACE INDTS PAGESIZE 8 K MANAGED BY DATABASE USING ( FILE '${dbdatadir}/indts1c1' ${index_space_size}) EXTENTSIZE 16 PREFETCHSIZE 16 BUFFERPOOL "IBMDEFAULTBP";
|
|
-- grant previlige to user
|
|
GRANT USE OF TABLESPACE INDTS TO USER ${dbuser};
|
|
alter bufferpool ibmdefaultbp size 51200;
|
|
CONNECT RESET;
|
|
update db cfg for ${dbname} using logfilsiz 10000 logprimary 5 logsecond 10 softmax 200;
|
|
update db cfg for ${dbname} using LOGARCHMETH1 DISK:${dbarchlogdir};
|
|
backup database ${dbname};
|
|
quit;
|
|
!
|
|
|
|
export DB2OPTIONS='+t'; |