代码改变世界

[DPF] DPF 常见的问题

2016-10-12 16:09  Ivan的一亩三分地  阅读(691)  评论(0编辑  收藏  举报

问题一: 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