DB2 10.5.0.1安装

1.查看缺失的补丁包

https://www.cndba.cn/hbhe0316/article/4770

[root@db01 server]# ./db2prereqcheck -v 10.5.0.1

2.配置好yum源，并安装缺少的包https://www.cndba.cn/hbhe0316/article/4770https://www.cndba.cn/hbhe0316/article/4770https://www.cndba.cn/hbhe0316/article/4770

[root@db01 server]# yum whatprovides libpam.so*

[root@db01 server]# yum install dapl sg3_utils libnes.x86_64  libmthca.x86_64 libipathverbs.x86_64 libibumad.x86_64 libibmad.x86_64 libcxgb3.x86_64 ibutils.x86_64 ibsim.x86_64 librdmacm.x86_64 libibcm.x86_64 pam-1.1.1-24.el6.i686 -y

如果是11.1.4.4还需要安装如下包：

yum install gcc cpp gcc-c++ kernel-devel ksh libstdc++.so.6 pam-1.1.8-22.el7.i686   perl-Sys-Syslog -y

问题：
Requirement not matched for DB2 database “Server” with pureScale feature. Version: “10.5.0.1”.
Summary of prerequisites that are not met on the current system:
DBT3588W The db2prereqcheck utility was unable to validate the configuration of the log_mtts_per_seg parameter on the following host machine: “db01”. Reason code: “1”. https://www.cndba.cn/hbhe0316/article/4770

解决办法：

[root@db01 server]# more /etc/modprobe.conf
/etc/modprobe.conf: No such file or directory
[root@db01 server]# echo "options mlx4_core log_mtts_per_seg=7" > /etc/modprobe.conf
[root@db01 server]# more /etc/modprobe.conf
options mlx4_core log_mtts_per_seg=7

3.安装DB2软件https://www.cndba.cn/hbhe0316/article/4770https://www.cndba.cn/hbhe0316/article/4770

[root@db01 server]# ./db2setup -u /home/db2server.rsp

[root@db01 home]# cat db2server.rsp 
*-----------------------------------------------------
* Generated response file used by the DB2 Setup wizard
* generation time: 2/12/16 2:47 PM
*-----------------------------------------------------
*  Product Installation 
LIC_AGREEMENT       = ACCEPT
PROD       = ENTERPRISE_SERVER_EDITION 
FILE       = /opt/ibm/db2/V10.1
INSTALL_TYPE       = TYPICAL
*-----------------------------------------------
*  Installed Languages 
*-----------------------------------------------
LANG       = EN


[root@db02 mnt]# cat /home/db2server.rsp 
*-----------------------------------------------------
* Generated response file used by the DB2 Setup wizard
* generation time: 2/12/16 2:47 PM
*-----------------------------------------------------
*  Product Installation 
LIC_AGREEMENT       = ACCEPT
PROD       = DB2_SERVER_EDITION
FILE       = /opt/ibm/db2/V10.5
INSTALL_TYPE       = TYPICAL
*-----------------------------------------------
*  Installed Languages 
*-----------------------------------------------
LANG       = EN

4.新建DB2组和用户

groupadd db2iadm1 && groupadd dasadm1 && groupadd db2fadm1
useradd -m  -g db2iadm1 db2inst1 -p wwwwww
useradd -m  -g db2fadm1 db2fenc1 -p wwwwww
useradd -m  -g dasadm1 dasusr1 -p wwwwww
mkdir /db2data
mkdir /db2log
mkdir /db2arch
chown db2inst1.db2iadm1 /db2*
cd /opt/ibm/db2/V10.5/instance 
./db2icrt -u db2fenc1 db2inst1
su - db2inst1
mkdir /db2data/reldb

5.创建库https://www.cndba.cn/hbhe0316/article/4770https://www.cndba.cn/hbhe0316/article/4770https://www.cndba.cn/hbhe0316/article/4770

db2 "CREATE DB reldb on /db2data using codeset UTF-8 territory us PAGESIZE 8192"
db2 "UPDATE DB CFG FOR reldb USING applheapsz 4096"
db2 "UPDATE DB CFG FOR reldb USING app_ctl_heap_sz 1024"
db2 "UPDATE DB CFG FOR reldb USING stmtheap 32768"
db2 "UPDATE DB CFG FOR reldb USING dbheap 2400"
db2 "UPDATE DB CFG FOR reldb USING locklist 1000"
db2 "UPDATE DB CFG FOR reldb USING logfilsiz 4000"
db2 "UPDATE DB CFG FOR reldb USING logprimary 12"
db2 "UPDATE DB CFG FOR reldb USING logsecond 20"
db2 "UPDATE DB CFG FOR reldb USING logbufsz 32"
db2 "UPDATE DB CFG FOR reldb USING avg_appls 5"
db2 "UPDATE DB CFG FOR reldb USING locktimeout 30"
db2 "UPDATE DB CFG FOR reldb using AUTO_MAINT off"

版权声明：本文为博主原创文章，未经博主允许不得转载。

Linux,oracle