db2 安裝過程小結

工作需要，想了解一下IBM的DB2，今天安裝了一個DB2，發現DB2安裝要比ORACLE簡單的多

下載地址給出：

https://www6.software.ibm.com/sdfdl/v2/regs2/db2pmopn/db2_v101/expc/Xa.2/Xb.aA_60_-i75OlvODp6a7JNfXVtNEgmo0T1R59DF5j_g/Xc.db2_v101/expc/db2_v101_linuxia32_expc.tar.gz/Xd./Xf.LPr.D1vk/Xg.7917285/Xi.swg-db2expressc/XY.regsrvs/XZ.cOFZdu_Sd4tv9F06HjGrclhbKJw/db2_v101_linuxia32_expc.tar.gz

1、檢測安裝三個安裝包：

libaio

libstdc

compat-libstdc

2、如果需要的話，配置一下核心引數：

[root@xttdb ~]# cat /etc/sysctl.conf | grep -v '#'

net.ipv4.ip_forward = 0

net.ipv4.conf.default.rp_filter = 1

net.ipv4.conf.default.accept_source_route = 0

kernel.sysrq = 0

kernel.core_uses_pid = 1

net.ipv4.tcp_syncookies = 1

net.bridge.bridge-nf-call-ip6tables = 0

net.bridge.bridge-nf-call-iptables = 0

net.bridge.bridge-nf-call-arptables = 0

kernel.msgmnb = 65536

kernel.msgmax = 65536

kernel.shmmax = 4294967295

kernel.shmall = 268435456

kernel.shmall = 2097152

kernel.shmmax = 2147483648

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

fs.file-max = 65536

net.ipv4.ip_local_port_range = 1024 65000

net.core.rmem_default=262144

net.core.rmem_max=262144

net.core.wmem_default=262144

net.core.wmem_max=262144

3、如果想手動新增使用者，可以提前建立db2的使用者，個人比較懶，就在圖形介面裡直接預設配置了

[root@xttdb ~]# tail -3 /etc/passwd

dasusr1:x:505:101::/home/dasusr1:/bin/bash

db2inst1:x:506:102::/home/db2inst1:/bin/bash

db2fenc1:x:507:103::/home/db2fenc1:/bin/bash

4、解壓壓縮包，執行db2setup即可

[root@xttdb ~]# cd /opt/

[root@xttdb opt]# tar zxvf db2_v101_linuxia32_expc.tar.gz

[root@xttdb opt]# cd expc/

[root@xttdb expc]# ./db2setup

關鍵步驟貼圖如下

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/29320885/viewspace-1409043/，如需轉載，請註明出處，否則將追究法律責任。