[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 

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值