[DPF] DPF 常见的问题

问题一： SQL6031N Error in the db2nodes.cfg file at line number "5". Reason code "12".

[db2inst1@ivan sqllib]$ db2start
SQL6031N Error in the db2nodes.cfg file at line number "5". Reason code "12".

The port value at line line of the db2nodes.cfg file in the sqllib directory is not in the valid port range defined for your DB2 instance id in the services file (/etc/services on UNIX-based systems).

Reason:

配置的端口问题

node 设置, cat sqllib/db2nodes.cfg

0 ivan.ibm.com 0
1 ivan.ibm.com 1
2 ivan.ibm.com 2
3 ivan.ibm.com 3
4 ivan.ibm.com 4
5 bela.ibm.com 0

端口设置， cat /etc/services

DB2_db2inst1   60004/tcp
DB2_db2inst1_1   60005/tcp
DB2_db2inst1_2   60006/tcp
DB2_db2inst1_END   60007/tcp

在当前server 上设置了5 个node，但是实际上端口设置了4个所以报错

问题二：DPF 启动时，报SQL5043N 错误

[db2inst1@ivan ~]$ db2start
10/11/2016 16:58:11     1   0   SQL1063N DB2START processing was successful.
10/11/2016 16:58:11     3   0   SQL1063N DB2START processing was successful.
10/11/2016 16:58:18     0   0   SQL5043N Support for one or more communications protocols specified in the DB2COMM environment variable failed to start successfully. However, core database manager functionality started successfully.
10/11/2016 16:58:19     2   0   SQL5043N Support for one or more communications protocols specified in the DB2COMM environment variable failed to start successfully. However, core database manager functionality started successfully.
SQL1063N DB2START processing was successful.

[db2inst1@ivan ~]$ cat sqllib/db2nodes.cfg
0 ivan.ibm.com 0
1 ivan.ibm.com 1
2 bela.ibm.com 0
3 bela.ibm.com 1

DB2_db2inst1   60004/tcp
DB2_db2inst1_1   60005/tcp
DB2_db2inst1_2   60006/tcp
DB2_db2inst1_3 60007/tcp
DB2_db2inst1_END   60008/tcp

查看了 svcename 的设置 DB2_db2inst1. 该端口用于分区的实例端口，而svcename 主要是FCM端口，用于分区管理的。
添加了一个特别的端口
DB2_FCM 50000/tcp

并设置svcename 为DB2_FCM

[db2inst1@ivan ~]$ netstat -na | grep -i 500
tcp 0 0 0.0.0.0:50000 0.0.0.0:* LISTEN

[db2inst1@ivan ~]$ netstat -na | grep -i 600
tcp 0 0 192.168.24.129:60004 0.0.0.0:* LISTEN
tcp 0 0 192.168.24.129:60005 0.0.0.0:* LISTEN

[root@bela ~]# netstat -na | grep -i 600
tcp 0 0 192.168.24.130:60004 0.0.0.0:* LISTEN
tcp 0 0 192.168.24.130:60005 0.0.0.0:* LISTEN

巴特西

[DPF] DPF 常见的问题

最新文章

热门文章