DB2安装-DB2 11.5 for RHEL 9安装配置及升级迁移详细过程

1. 硬件环境检查

在安装DB2数据库之前，必须对服务器的硬件环境进行全面检查，确保满足DB2 11.5的最低要求。更多学习教程www.fgedu.net.cn

# 检查内存大小
# free -h
total used free shared buff/cache available
Mem: 32G 2.1G 28G 8.5M 1.8G 29G
Swap: 16G 0B 16G

# 检查磁盘空间
# df -h
Filesystem Size Used Avail Use% Mounted on
devtmpfs 16G 0 16G 0% /dev
tmpfs 16G 0 16G 0% /dev/shm
tmpfs 16G 8.5M 16G 1% /run
tmpfs 16G 0 16G 0% /sys/fs/cgroup
/dev/sda1 50G 15G 36G 30% /
/dev/sdb1 500G 20G 480G 4% /db2

# 检查CPU核心数
# nproc
16

# 检查系统架构
# uname -m
x86_64

生产环境建议：最小内存8GB（测试环境），生产环境建议32GB以上。磁盘空间：系统盘至少50GB，数据盘根据业务需求配置，建议至少200GB。CPU：测试环境至少4核心，生产环境建议8核心以上。

2. 操作系统检查

DB2 11.5支持RHEL 7.3+、RHEL 8.0+、RHEL 9.0+等操作系统。本文以RHEL 9为例。学习交流加群风哥微信: itpux-com

# 检查操作系统版本
# cat /etc/redhat-release
Red Hat Enterprise Linux release 9.0 (Plow)

# 检查内核版本
# uname -r
5.14.0-70.22.1.el9_0.x86_64

# 检查SELinux状态
# getenforce
Disabled

# 关闭SELinux（如未关闭）
# vi /etc/selinux/config
SELINUX=disabled

# 检查防火墙状态
# systemctl status firewalld

# 关闭防火墙（生产环境建议开放特定端口而非完全关闭）
# systemctl stop firewalld
# systemctl disable firewalld

3. 安装准备

在安装DB2之前，需要进行一系列准备工作，包括下载安装介质、创建用户和组、配置网络等。

# 下载DB2 11.5安装介质
# 从IBM官网下载DB2 11.5企业版安装包
# 下载地址：https://www.ibm.com/support/pages/db2-115-mod-1-fix-pack-0

# 创建DB2用户和组
# 创建组
# groupadd -g 901 db2iadm1
# groupadd -g 902 db2fadm1
# groupadd -g 903 dasadm1

# 创建用户
# useradd -u 901 -g db2iadm1 -G db2fadm1 db2inst1
# useradd -u 902 -g db2fadm1 -G db2iadm1 db2fenc1
# useradd -u 903 -g dasadm1 dasusr1

# 设置密码
# passwd db2inst1
# passwd db2fenc1
# passwd dasusr1

# 配置网络
# 确保服务器IP地址为192.168.1.51
# ip addr show eth0
2: eth0: mtu 1500 qdisc fq_codel state UP group default qlen 1000
inet 192.168.1.51/24 brd 192.168.1.255 scope global noprefixroute eth0
valid_lft forever preferred_lft forever
inet6 fe80::5054:ff:fe12:3456/64 scope link noprefixroute
valid_lft forever preferred_lft forever

风哥提示：DB2安装需要root权限，建议使用root账户进行安装。

4. DB2软件安装

现在开始安装DB2 11.5软件，按照以下步骤进行。

# 上传安装介质到服务器
# scp v11.5.0_linuxx64_server_t.tar.gz root@192.168.1.51:/db2

# 解压安装包
# cd /db2
# tar -xzf v11.5.0_linuxx64_server_t.tar.gz

# 运行安装向导
# cd server_t
# ./db2_install

DB2 installation is being initialized.

Default directory for installation of products:
/opt/ibm/db2/V11.5

***********************************************************
Do you want to choose a different directory to install [yes/no] ?
***********************************************************
no

Specify one of the following choices:
1. Install DB2 Server Edition
2. Install DB2 Connect Server

Enter your choice: 1

DB2 installation completed successfully.
For more information see the DB2 installation log at “/tmp/db2_install.log.12345”.

# 创建DB2实例
# /opt/ibm/db2/V11.5/instance/db2icrt -u db2fenc1 db2inst1
DBI1446I The db2icrt command is running.

DB2 instance “db2inst1” has been created successfully.

DBI1455I The db2icrt command completed successfully.

# 验证实例状态
# su – db2inst1
$ db2start
03/31/2026 10:00:00 0 0 SQL1063N DB2START processing was successful.
SQL1063N DB2START processing was successful.

$ db2ilist
db2inst1

5. 数据库创建

安装完成后，创建数据库fgedudb。

# 以db2inst1用户登录
# su – db2inst1

# 创建数据库
$ db2 create database fgedudb using codeset UTF-8 territory CN
DB20000I The CREATE DATABASE command completed successfully.

# 验证数据库创建
$ db2 list database directory
System Database Directory

Number of entries in the directory = 1

Database 1 entry:

Database alias = FGEDUDB
Database name = FGEDUDB
Local database directory = /db2/db2inst1
Database release level = 15.00
Comment =
Directory entry type = Indirect
Catalog database partition number = 0
Alternate server hostname =
Alternate server port number =

6. 参数配置

配置DB2数据库参数，优化性能。学习交流加群风哥QQ113257174

# 连接数据库
$ db2 connect to fgedudb
Database Connection Information

Database server = DB2/LINUXX8664 11.5.1000.615
SQL authorization ID = DB2INST1
Local database alias = FGEDUDB

# 配置数据库参数
$ db2 update db cfg for fgedudb using LOGFILSIZ 1000 LOGPRIMARY 10 LOGSECOND 10
DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.

$ db2 update db cfg for fgedudb using BUFFPAGE 16384
DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.

$ db2 update db cfg for fgedudb using LOCKLIST 1024 MAXLOCKS 90
DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.

$ db2 update db cfg for fgedudb using SORTHEAP 2048
DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.

$ db2 update db cfg for fgedudb using AUTO_MAINT ON
DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.

$ db2 update db cfg for fgedudb using AUTO_TBL_MAINT ON
DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.

$ db2 update db cfg for fgedudb using AUTO_RUNSTATS ON
DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.

# 验证参数配置
$ db2 get db cfg for fgedudb | grep LOGFILSIZ
Log file size (4KB) (LOGFILSIZ) = 1000

$ db2 get db cfg for fgedudb | grep BUFFPAGE
Buffer pool size (pages) (BUFFPAGE) = 16384

$ db2 get db cfg for fgedudb | grep LOCKLIST
Lock list size (4KB) (LOCKLIST) = 1024

生产环境建议：参数配置应根据服务器硬件配置和业务需求进行调整。LOGFILSIZ和LOGPRIMARY应根据事务量设置；BUFFPAGE应根据内存大小设置，建议为总内存的20%-30%；SORTHEAP应根据排序操作的频率和大小设置。

7. 备份配置

配置DB2数据库备份策略，确保数据安全。

# 创建备份目录
# mkdir -p /backup/db2
# chown -R db2inst1:db2iadm1 /backup/db2

# 以db2inst1用户执行全库备份
# su – db2inst1
$ db2 backup database fgedudb to /backup/db2
Backup successful. The timestamp for this backup image is : 20260331100000

# 验证备份文件
$ ls -la /backup/db2/
-rw-rw—- 1 db2inst1 db2iadm1 1234567890 Mar 31 10:00 FGEDUDB.0.db2inst1.DBPART000.20260331100000.001

# 配置自动备份
# 使用DB2自动维护功能设置定期备份
$ db2 update db cfg for fgedudb using AUTO_DB_BACKUP ON
DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.

$ db2 update db cfg for fgedudb using NUM_DB_BACKUPS 10
DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.

$ db2 update db cfg for fgedudb using REC_HIS_RETENTN 30
DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.

8. 测试验证

创建测试表并执行SQL语句，验证数据库功能正常。更多学习教程公众号风哥教程itpux_com

# 连接数据库
$ db2 connect to fgedudb

# 创建测试表
$ db2 “create table fgedu_employees (id int, name varchar(100), salary decimal(10,2))”
DB20000I The SQL command completed successfully.

# 插入测试数据
$ db2 “insert into fgedu_employees values (1, ‘张三’, 5000.00)”
DB20000I The SQL command completed successfully.

$ db2 “insert into fgedu_employees values (2, ‘李四’, 6000.00)”
DB20000I The SQL command completed successfully.

$ db2 “insert into fgedu_employees values (3, ‘王五’, 7000.00)”
DB20000I The SQL command completed successfully.

# 查询测试数据
$ db2 “select * from fgedu_employees”

ID NAME SALARY
———– —————————————————————————————————- ———–
1 张三 5000.00
2 李四 6000.00
3 王五 7000.00

3 record(s) selected.

9. 升级迁移

DB2数据库的升级和迁移过程。

# 升级DB2版本
# 1. 下载DB2 11.5最新补丁包
# 2. 上传补丁包到服务器
# 3. 解压补丁包
# 4. 运行升级向导
# cd /db2
# tar -xzf v11.5.10_linuxx64_server_t.tar.gz
# cd server_t
# ./installFixPack -b /opt/ibm/db2/V11.5

# 验证升级结果
# su – db2inst1
$ db2level
DB21085I This instance or install (instance name, where applicable: “db2inst1”) uses
“64” bits and DB2 code release “SQL110510” with level identifier “060A010F”.
Informational tokens are “DB2 v11.5.10.0”, “s2305041500”, “DYN2305041500AMD64”,
and Fix Pack “10”.
Product is installed at “/opt/ibm/db2/V11.5”

# 数据库迁移
# 从旧版本DB2迁移到DB2 11.5

# 1. 在旧系统上备份数据库
# 2. 将备份文件复制到新系统
# 3. 在新系统上恢复数据库
$ db2 restore database fgedudb from /backup/db2 taken at 20260331100000
DB20000I The RESTORE DATABASE command completed successfully.

# 4. 执行数据库升级
$ db2 upgrade database fgedudb
DB20000I The UPGRADE DATABASE command completed successfully.

# 5. 验证迁移结果
$ db2 connect to fgedudb
$ db2 “select * from fgedu_employees”

风哥提示：数据库升级和迁移前，建议先在测试环境进行演练，确保升级过程顺利。同时，备份所有重要数据，以防万一。

10. 总结

本文详细介绍了DB2 11.5 for RHEL 9的安装、配置、升级和迁移过程。通过按照本文的步骤操作，可以成功部署DB2数据库并确保其稳定运行。from:fengge

生产环境建议：
– 定期备份数据库，建议每天执行一次全备份，每小时执行一次增量备份
– 监控数据库性能，定期检查数据库日志和错误信息
– 定期更新DB2补丁，确保系统安全性
– 合理规划数据库存储，避免空间不足
– 配置合适的参数，优化数据库性能

本文由风哥教程整理发布,仅用于学习测试使用,转载注明出处:http://www.fgedu.net.cn/10327.html

DB2安装-DB2 11.5 for RHEL 9安装配置及升级迁移详细过程

1. 硬件环境检查

2. 操作系统检查

3. 安装准备

4. DB2软件安装

5. 数据库创建

6. 参数配置

7. 备份配置

8. 测试验证

9. 升级迁移

10. 总结

相关推荐

联系我们