前言:年底了,公司需要部署一套DB2环境+应用系统来对客户进行相关的功能模块演示操作,之前对DB2接触不多,利用这次机会,开启对DB2的探索学习之路。
DB2 数据库部署
硬件环境信息:
机器IP:10.162.64.78
OS版本:RHEL 6.6
内存:256G
1.文件系统划分
查看已经创建的PV,VG
# pvs
? PV ? ? ? ? VG ? ? ? ? Fmt ?Attr PSize ? PFree?
? /dev/sda3 ?VolGroup00 lvm2 a-- ?557.38g 379.38g
# vgs
? VG ? ? ? ? #PV #LV #SN Attr ? VSize ? VFree?
? VolGroup00 ? 1 ? 2 ? 0 wz--n- 557.38g 379.38g
创建LV
# lvcreate -L 20G -n lvdb2log VolGroup00
# lvcreate -L 30G -n lvdb2arch VolGroup00
# lvcreate -L 150G -n lvdb2data VolGroup00
格式化LV
# mkfs.ext4 /dev/VolGroup00/lvdb2log
# mkfs.ext4 /dev/VolGroup00/lvdb2arch
# mkfs.ext4 /dev/VolGroup00/lvdb2data
创建目录并挂载
# mkdir -p /oradata4
# mkdir -p /db2arch
# mkdir -p /db2log
# mount /dev/VolGroup00/lvdb2log /db2log
# mount /dev/VolGroup00/lvdb2arch /db2arch
# mount /dev/VolGroup00/lvdb2data /oradata4
# tune2fs -c 0 -i 0 /dev/VolGroup00/lvdb2log
# tune2fs -c 0 -i 0 /dev/VolGroup00/lvdb2arch
# tune2fs -c 0 -i 0 /dev/VolGroup00/lvdb2data
# echo "/dev/VolGroup00/lvdb2log /db2log ? ? ? ? ? ? ? ? ? ? ext4 ? ?defaults ? ? ? ?0 0" >> /etc/fstab
# echo "/dev/VolGroup00/lvdb2arch /db2arch ? ? ? ? ? ? ? ? ? ext4 ? ?defaults ? ? ? ?0 0" >> /etc/fstab
# echo "/dev/VolGroup00/lvdb2data /oradata4 ? ? ? ? ? ? ? ? ? ext4 ? ?defaults ? ? ? ?0 0" >> /etc/fstab
2.安装所需软件包
libstdc++.so.6
3.修改系统内核参数
# vi /etc/sysctl.conf
kernel.shmmax = 137438953472 ? ?--设置为物理内存的一半或稍大
kernel.shmall = 67108864
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
4.创建用户
# groupadd -g 1011 db2iadm1
# groupadd -g 1012 db2fadm1
# useradd -u 1016 -g db2iadm1 -d /home/db2inst1 -m ?db2inst1
# useradd -u 1017 -g db2fadm1 -d ?/home/db2fenc1 -m db2fenc1
# echo 'db2inst1' |passwd --stdin db2inst1
# echo 'db2fenc1' |passwd --stdin db2fenc1
# chown db2inst1:db2iadm1 /oradata4
# chown db2inst1:db2iadm1 /db2log
# chown db2inst1:db2iadm1 /db2arch
5.安装数据库
# tar zxvf v10.5fp7_linuxx64_universal_fixpack.tar.gz
# cd universal/
# ./db2_install
DBI1324W ?Support of the db2_install command is deprecated.
Default directory for installation of products - /opt/ibm/db2/V10.5
***********************************************************
Install into default directory (/opt/ibm/db2/V10.5) ? [yes/no]
yes
Specify one of the following keywords to install DB2 products.
? SERVER
? CONSV
? EXP
Enter "help" to redisplay product names.
Enter "quit" to exit.
***********************************************************
SERVER
***********************************************************
Do you want to install the DB2 pureScale Feature? [yes/no]
no
DB2 installation is being initialized.
......
The execution completed successfully.
For more information see the DB2 installation log at
"/tmp/db2_install.log.25687".
6.查看并安装license
# find / -name db2licm
/opt/ibm/db2/V10.5/adm/db2licm
# /opt/ibm/db2/V10.5/adm/db2licm -l
Product name: ? ? ? ? ? ? ? ? ? ? "DB2 Enterprise Server Edition"
License type: ? ? ? ? ? ? ? ? ? ? "License not registered"
Expiry date: ? ? ? ? ? ? ? ? ? ? ?"License not registered"
Product identifier: ? ? ? ? ? ? ? "db2ese"
Version information: ? ? ? ? ? ? ?"10.5"
# ./db2licm -a /install/isrs.lic
Product name: ? ? ? ? ? ? ? ? ? ? "DB2 Enterprise Server Edition"
License type: ? ? ? ? ? ? ? ? ? ? "CPU Option"
Expiry date: ? ? ? ? ? ? ? ? ? ? ?"Permanent"
Product identifier: ? ? ? ? ? ? ? "db2ese"
Version information: ? ? ? ? ? ? ?"10.5"
7.创建实例
修改/etc/hosts如下配置:
127.0.0.1 ? ?localhost
10