【实战总结系列】之第六篇：创建DB2内容库

Oracle内容库的创建比较简单，主要是字符集注意是UTF8就可以了，使用dbca命令打开图形化界面即可一步一步的完成。

DB2的我一般是脚本来建，如下：

--创建数据库

db2 "create db cm110 using codeset utf-8 territory US"

db2 "CHANGE DB CM110 COMMENT WITH 'Content Store for Cognos10'"

db2 CONNECT TO CM110

--内容库配置

db2 "UPDATE DATABASE CONFIGURATION USING LOCKTIMEOUT 240 DEFERRED "

db2 "UPDATE DATABASE CONFIGURATION USING APPLHEAPSZ 1024 DEFERRED"

db2 CREATE BUFFERPOOL "C10_32K" SIZE 250 PAGESIZE 32 K

db2 CREATE BUFFERPOOL "C10_04K" SIZE 250 PAGESIZE 4 K

db2 connect reset

db2 connect to cm110

--创建表空间

db2 "CREATE TEMPORARY TABLESPACE C10_SYS_TEMP IN DATABASE PARTITION GROUP IBMTEMPGROUP PAGESIZE 32 K MANAGED BY SYSTEM USING('/home/db2inst1/NODE0000/CM110/C10_SYS_TEMP')  EXTENTSIZE 16 PREFETCHSIZE 16 BUFFERPOOL C10_32K"

db2 "CREATE USER TEMPORARY TABLESPACE C10_USR_TEMP IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 4 K MANAGED BY SYSTEM USING('/home/db2inst1/NODE0000/CM110/C10_USER_TEMP') EXTENTSIZE 8 PREFETCHSIZE 8 BUFFERPOOL C10_04K"

db2 "CREATE REGULAR TABLESPACE C10_REGULAR IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 4 K MANAGED BY SYSTEM USING ('/home/db2inst1/NODE0000/CM110/C10_REGULAR') EXTENTSIZE 8 PREFETCHSIZE 8 BUFFERPOOL C10_04K"

--创建用户对应的schema

db2 "CREATE SCHEMA C10User AUTHORIZATION C10User"

--用户授权

db2 "GRANT CREATETAB,BINDADD,CONNECT,IMPLICIT_SCHEMA ON DATABASE TO USER C10User"

db2 "GRANT CREATEIN,DROPIN,ALTERIN ON SCHEMA C10User  TO USER C10User WITH GRANT OPTION "

db2 "GRANT USE OF TABLESPACE C10_USR_TEMP TO USER C10User"

db2 connect reset

db2 terminate

此时DB2内容库创建完成，直接在Configuration配置上就可以直接用了。