#----------------------------------------------------
# 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';