HP-UNIX DB2安装配置

 

1、  运行DB2安装文件：./db2setup

2、  通常情况下，DB2安装过程中建议不要创建实例

3、  安装后查看基于现在的配置需要调哪些参数(重新配置HP内核)

/opt/IBM/db2/V8.1/bin64／db2osconf

使用：db2osconf 命令，得到OS Kernel配置的最佳参数！！！

WARNING[1]: nproc = 4096. nproc should be set to 5809.

WARNING[2]: maxfiles = 2048. maxfiles should be set to 2896.

WARNING[3]: nflocks = 4096. nflocks should be set to 11585.

WARNING[4]: msgseg = 16384. msgseg should be set to 32767.

WARNING[5]: msgmnb = 16384. msgmnb should be set to 65535.

WARNING[6]: msgmax = 8192. msgmax should be set to 65535.

WARNING[7]: msgtql = 4096. msgtql should be set to 4634.

WARNING[8]: msgmap = 4098. msgmap should be set to 4636.

WARNING[9]: msgmni = 4096. msgmni should be set to 4634.

WARNING[10]: semmnu = 4092. semmnu should be set to 5793.

WARNING[11]: shmmax = 16743656000. shmmax should be set to 23010693120.

WARNING[12]: shmmni = 512. shmmni should be set to 5793.

WARNING: msgmax = 8192. msgmax must be set to 65535.

WARNING: msgseg = 16384. msgseg must be set to 32767.

4、  有三种用于管理内核配置的主要命令：kconfig、kcmodule 和 kctune

    # kctune nproc=4300

5、  SAM

创建用户：db2as1, db2inst1 ,db2fenc1

创建组：  dasadm1 ，db2grp1 ，db2fgrp1

6、  创建db2inst1实例 (/opt/IBM/db2/V8.1/instance/)

./db2icrt -a SERVER -u db2fenc1 -w 64 db2inst1

7、  创建用户：eximtrx \ eximuser

8、  创建数据库：（给指定的数据库文件权限：chmod -R 777 eximuser）

create db eximdb on /eximdb/eximdb alias eximdb using codeset UTF-8 territory US collate using system with "EXIMDB";

9、  设置

Db2set  db2codepage =1208

db2set DB2COMM=TCPIP

db2 update dbm cfg using SVCENAME db2c_db2inst1

add a new line in:  /etc/services    with :  db2c_db2inst1 50000/TCP

10、              创建表空间、缓冲（eximtrx/eximuser的目录不应该建在用户指定的那个）

connect to eximdb;

create bufferpool eximtrx size 1000 pagesize 32k;

terminate;

 

connect to eximdb;

CREATE  REGULAR  TABLESPACE EXIMUSER PAGESIZE 32 K  MANAGED BY SYSTEM  USING ('/eximdb/eximuser' ) EXTENTSIZE 16 OVERHEAD 10.5 PREFETCHSIZE 16 TRANSFERRATE 0.14 BUFFERPOOL  EXIMTRX  DROPPED TABLE RECOVERY OFF;

COMMENT ON TABLESPACE EXIMUSER IS 'EXIMUSER';

 

CREATE  REGULAR  TABLESPACE EXIMTRX PAGESIZE 32 K  MANAGED BY SYSTEM  USING ('/eximdb/eximtrx' ) EXTENTSIZE 16 OVERHEAD 10.5 PREFETCHSIZE 16 TRANSFERRATE 0.14 BUFFERPOOL  EXIMTRX  DROPPED TABLE RECOVERY OFF;

COMMENT ON TABLESPACE EXIMTRX IS 'EXIMTRX';

11、              建表

12、              导数据

13、              数据库调优

14、              新建用户后，需将db2inst1/sqllib下的.db2profile复制到用户相应的目录下。并作下修改。

在profile的最下面加入：

. /home/db2inst1/sqllib/db2profile

以使用户能够使用DB2的命令。