首页 > 代码库 > [DPF] DPF 常见的问题
[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 常见的问题