RHEL 9.2安装DB2 11.5.9.0

##

RHEL 9.2安装DB2 11.5.9.0

1、起因

最近一个客户有DB2的需求，主要就是一些安装/运维的基础工作，虽然我不会，但还是接下来了。恶补了一下DB2的知识，网上和官网的资料都非常齐全。

客户需求驱动学习，与客户共同成长。

2、安装过程

由于太简单，就不贴过程了，官网的文档非常详细。

3、安装结果

[db2inst1@db2db01 ~]$ db2ls

Install Path                       Level   Fix Pack   Special Install Number   Install Date                  Installer UID
---------------------------------------------------------------------------------------------------------------------
/db2/app/db2                     11.5.9.0        0                            Sat May  4 03:08:27 2024 EDT             0

[db2inst1@db2db01 ~]$ cat /etc/redhat-release
Red Hat Enterprise Linux release 9.2 (Plow)

4、安装时的问题集

4.1、创建实例失败

[root@db2db01 ~]# /db2/app/db2/instance/db2icrt -a server -u db2fenc1 db2inst1
DBI1446I The db2icrt command is running.
DB2 installation is being initialized.

 The host name "db2db01" is invalid. Specify a valid host name.


A major error occurred during the execution that caused this program to
terminate prematurely. If the problem persists, contact your technical service
representative.

 
For more information see the DB2 installation log at "/tmp/db2icrt.log.18882".
DBI1264E This program failed. Errors encountered during execution were
   written to the installation log file. Program name:
   db2icrt. Log file name: /tmp/db2icrt.log.18882.

这个问题是因为创建的时候要检查/etc/hosts的内容，必须是ip和主机名要对应

如果主机名是db2db01,ip地址是192.168.5.30。但是在hosts文件中写成db2db01 192.168.5.130，那么就会失败，需要改成正确的

4.2、无法停止db2

[db2inst1@db2db01 ~]$ db2stop
05/04/2024 01:58:17   0  0  SQL1025N The database manager was not stopped because databases are still active.
SQL1025N The database manager was not stopped because databases are still active.


[db2inst1@db2db01 ~]$ db2 force application all
DB20000I The FORCE APPLICATION command completed successfully.
DB21024I This command is asynchronous and may not be effective immediately.
 

[db2inst1@db2db01 ~]$ db2stop
05/04/2024 01:58:59   0  0  SQL1064N DB2STOP processing was successful.
SQL1064N DB2STOP processing was successful.

5、总结

会DB2的DBA不多，但学习一些DB2的基础技能还是可以的。以免万一。

6、其他

是的，我又来招人了！！！

最近写文档已经写废了，事情太多了。需要交付的文档已经排队了。有兴趣写数据库文档的可以私我，有偿。

PS：没有作品集不要来找我，价格可以谈，按篇幅和难度计算，没有作品集还漫天要价的就不要来了。想发财，请买彩票！！！

我需要的作品类型参考链接：
https://www.modb.pro/db/1702855062607450112

简单易懂，可复现，这次不要求英语，但对表达能力有要求。