warehous数据库准备

 

1．创建用户

Useradd itmuser

Passwd itmuser

2．itmuser加入sysadmin_group中

查看sysadmin_group 组名

db2 get dbm cfg | grep SYSADM

SYSADM group name (SYSADM_GROUP) = DB2GRP1

3．创建数据库

Su – db2inst1

db2 create db WAREHOUS using codeset utf-8 territory us

db2 connect to warehouse

4.执行脚本shell，完成建bufferpool和tablespace的创建

-- CREATE a Bufferpool of page size 8K

CREATE BUFFERPOOL ITMBUF8K IMMEDIATE SIZE 250

PAGESIZE 8 K;

-- CREATE a Regular Tablespace using the 8K Bufferpool

CREATE REGULAR TABLESPACE ITMREG8K PAGESIZE 8 K

MANAGED BY SYSTEM

USING ('itmreg8k')

BUFFERPOOL ITMBUF8k;

-- CREATE a System tablespace using the 8K Bufferpool

CREATE SYSTEM TEMPORARY TABLESPACE ITMSYS8K PAGESIZE 8 K

MANAGED BY SYSTEM

USING ('itmsys8k')

BUFFERPOOL ITMBUF8k;

-- CREATE a User tablespace using the 8K Bufferpool

CREATE USER TEMPORARY TABLESPACE ITMUSER8K PAGESIZE 8 K

MANAGED BY SYSTEM

USING ('itmuser8k')

BUFFERPOOL ITMBUF8k;

5.分配权限（如果把itmuser移出sysadm组）

db2 "GRANT CONNECT ON DATABASE TO USER itmuser"

db2 "GRANT CREATETAB ON DATABASE TO USER itmuser"

6.日志出口及相关配置（redbook）

7.配置通讯协议和端口

db2set -i instance_name DB2COMM=tcpip

db2 update dbm cfg using SVCENAME port_number

db2stop

db2start

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22775238/viewspace-617544/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22775238/viewspace-617544/