linux上安装db2

#确保正确的本机IP和主机名映射

sed -i "/`hostname`/c `` `hostname`" /etc/hosts;

grep `hostname` /etc/hosts;

if [ $? -ne 0 ]; then

 echo `hostname` >> /etc/hosts;

fi

sed -i "/`hostname`/c\

`ifconfig -a | grep inet | grep -Ev '127.0.0.1|inet6' | cut -d':' -f2 | cut -d' ' -f1 | head -n 1` `hostname`" /etc/hosts;

cat /etc/hosts;

###配置文件系统

### for  红帽 7

pvcreate /dev/sdc;

vgcreate datavg /dev/sdc;

lvcreate -L 100G -n lv_db2space datavg;

lvcreate -L 20G -n lv_db2home datavg;

lvcreate -L 10G -n lv_db2diag datavg;

mkfs -t xfs /dev/datavg/lv_db2space;

mkfs -t xfs /dev/datavg/lv_db2home;

mkfs -t xfs /dev/datavg/lv_db2diag;

mkdir -p /db2space;

mkdir -p /db2home;

mkdir -p /db2diag;

echo '/dev/datavg/lv_db2space /db2space xfs defaults 0 0' >> /etc/fstab;

echo '/dev/datavg/lv_db2home /db2home xfs defaults 0 0' >> /etc/fstab;

echo '/dev/datavg/lv_db2diag /db2diag xfs defaults 0 0' >> /etc/fstab;

mount -a

安装必须的包

yum install -y libstdc++.i686  pam.i686

安装 db2软件

解压

执行安装

./db2_install

选择安装到默认路径

按enter

选择 server

选择 no

创建实例

创建用户

groupadd  db2iadm1;

groupadd  db2fadm1;

useradd -m -g db2iadm1 -d /db2home/db2inst1 db2inst1;

useradd -m -g db2fadm1 -d /db2home/db2fenc1 db2fenc1;

useradd -m -d /home/fmdbrun  fmdbrun;

mkdir /db2diag/db2inst1/sqllib/db2dump

chown db2inst1:db2iadm1  /db2diag/db2inst1/sqllib/db2dump

创建实例

/opt/ibm/db2/V10.5/instance/db2icrt -a server  -u db2fenc1 db2inst1

## 授权 license

/opt/ibm/db2/V10.5/adm/db2licm -a xxx.lic

进入实例用户

---配置db2set ,其中编码根据实际库来配置

db2set DB2_TRUST_MDC_BLOCK_FULL_HINT=YES

db2set DB2_RESTRICT_DDF=TRUE

db2set DB2_MDC_ROLLOUT=DEFER

db2set DB2_LOAD_COPY_NO_OVERRIDE=NONRECOVERABLE

db2set DB2_LOGGER_NON_BUFFERED_IO=ON

db2set DB2SOSNDBUF=1048576

db2set DB2SORCVBUF=1048576

db2set DB2COMM=TCPIPdb2

db2set DB2CODEPAGE=1386

db2set DB2AUTOSTART=yes

db2 update dbm cfg using svcename DB2_db2inst1              ---这里是/etc/services  文件的配置信息

db2 update dbm cfg using DIAGPATH  '/db2diag/db2inst1/sqllib/db2dump/'

db2start   启动实例