db2 v9.7 dpf安装错误
[db2inst1@amldb sqllib]$ db2level
DB21085I This instance or install (instance name, where applicable:
"db2inst1") uses "64" bits and DB2 code release "SQL09078" with level
identifier "08090107".
Informational tokens are "DB2 v9.7.0.8", "s130316", "IP23433", and Fix Pack
"8".
Product is installed at "/opt/ibm/db2/V9.7".
[db2inst1@amldb ~]$ db2licm -l
Product name: "DB2 Enterprise Server Edition"
License type: "CPU Option"
Expiry date: "Permanent"
Product identifier: "db2ese"
Version information: "9.7"
Enforcement policy: "Soft Stop"
Features:
DB2 Database Partitioning: "Licensed"
DB2 Performance Optimization ESE: "Not licensed"
DB2 Storage Optimization: "Not licensed"
DB2 Advanced Access Control: "Not licensed"
IBM Homogeneous Replication ESE: "Not licensed"
Product name: "DB2 Connect Server"
License type: "Trial"
Expiry date: "08/10/2015"
Product identifier: "db2consv"
Version information: "9.7"
[db2inst1@amldb sqllib]$ vi db2nodes.cfg
0 amldb 0
1 amldb 1
2 amldb 2
[db2inst1@amldb sqllib]$ db2start
SQL6031N Error in the db2nodes.cfg file at line number "2". Reason code "14".
请教各位大神怎么解决
DB21085I This instance or install (instance name, where applicable:
"db2inst1") uses "64" bits and DB2 code release "SQL09078" with level
identifier "08090107".
Informational tokens are "DB2 v9.7.0.8", "s130316", "IP23433", and Fix Pack
"8".
Product is installed at "/opt/ibm/db2/V9.7".
[db2inst1@amldb ~]$ db2licm -l
Product name: "DB2 Enterprise Server Edition"
License type: "CPU Option"
Expiry date: "Permanent"
Product identifier: "db2ese"
Version information: "9.7"
Enforcement policy: "Soft Stop"
Features:
DB2 Database Partitioning: "Licensed"
DB2 Performance Optimization ESE: "Not licensed"
DB2 Storage Optimization: "Not licensed"
DB2 Advanced Access Control: "Not licensed"
IBM Homogeneous Replication ESE: "Not licensed"
Product name: "DB2 Connect Server"
License type: "Trial"
Expiry date: "08/10/2015"
Product identifier: "db2consv"
Version information: "9.7"
[db2inst1@amldb sqllib]$ vi db2nodes.cfg
0 amldb 0
1 amldb 1
2 amldb 2
[db2inst1@amldb sqllib]$ db2start
SQL6031N Error in the db2nodes.cfg file at line number "2". Reason code "14".
请教各位大神怎么解决
11同行回答
这是我的一test系统（我用的是ssh, 用ssh or rsh 那个没关系）
你可比较看看
[db2inst7@s0 ~]$ db2start
05/15/2015 15:28:18 2 0 SQL1063N DB2START processing was successful.
05/15/2015 15:28:18 1 0 SQL1063N DB2START processing was successful.
05/15/2015 15:28:19 0 0 SQL1063N DB2START processing was successful.
SQL1063N DB2START processing was successful.
[db2inst7@s0 ~]$
[db2inst7@s0 ~]$ cat ~/sqllib/db2nodes.cfg
0 s0 0
1 s0 1
2 s0 2
[db2inst7@s0 ~]$
[db2inst7@s0 ~]$ db2set -all
[i] DB2RSHCMD=/usr/bin/ssh
[i] DB2COMM=TCPIP
[g] DB2FCMCOMM=TCPIP4
[g] DB2SYSTEM=s0
[g] DB2INSTDEF=db2inst7
[g] DB2ADMINSERVER=dasusr1
[db2inst7@s0 ~]$
[db2inst7@s0 ~]$ grep db2inst7 /etc/services
DB2_db2inst7 60012/tcp
DB2_db2inst7_1 60013/tcp
DB2_db2inst7_2 60014/tcp
DB2_db2inst7_END 60015/tcp
db2c_db2inst7 50003/tcp
[db2inst7@s0 ~]$
[db2inst7@s0 ~]$ grep s0 /etc/hosts
192.168.1.30 s0
[db2inst7@s0 ~]$
[db2inst7@s0 ~]$ db2level
DB21085I Instance "db2inst7" uses "64" bits and DB2 code release "SQL09076"
with level identifier "08070107".
Informational tokens are "DB2 v9.7.0.6", "s120516", "IP23328", and Fix Pack
"6".
Product is installed at "/opt/ibm/db2/V9.7".
[db2inst7@s0 ~]$
[db2inst7@s0 ~]$ db2stop force
05/15/2015 15:29:44 0 0 SQL1064N DB2STOP processing was successful.
05/15/2015 15:29:44 1 0 SQL1064N DB2STOP processing was successful.
05/15/2015 15:29:45 2 0 SQL1064N DB2STOP processing was successful.
SQL1064N DB2STOP processing was successful.收起
你可比较看看
[db2inst7@s0 ~]$ db2start
05/15/2015 15:28:18 2 0 SQL1063N DB2START processing was successful.
05/15/2015 15:28:18 1 0 SQL1063N DB2START processing was successful.
05/15/2015 15:28:19 0 0 SQL1063N DB2START processing was successful.
SQL1063N DB2START processing was successful.
[db2inst7@s0 ~]$
[db2inst7@s0 ~]$ cat ~/sqllib/db2nodes.cfg
0 s0 0
1 s0 1
2 s0 2
[db2inst7@s0 ~]$
[db2inst7@s0 ~]$ db2set -all
[i] DB2RSHCMD=/usr/bin/ssh
[i] DB2COMM=TCPIP
[g] DB2FCMCOMM=TCPIP4
[g] DB2SYSTEM=s0
[g] DB2INSTDEF=db2inst7
[g] DB2ADMINSERVER=dasusr1
[db2inst7@s0 ~]$
[db2inst7@s0 ~]$ grep db2inst7 /etc/services
DB2_db2inst7 60012/tcp
DB2_db2inst7_1 60013/tcp
DB2_db2inst7_2 60014/tcp
DB2_db2inst7_END 60015/tcp
db2c_db2inst7 50003/tcp
[db2inst7@s0 ~]$
[db2inst7@s0 ~]$ grep s0 /etc/hosts
192.168.1.30 s0
[db2inst7@s0 ~]$
[db2inst7@s0 ~]$ db2level
DB21085I Instance "db2inst7" uses "64" bits and DB2 code release "SQL09076"
with level identifier "08070107".
Informational tokens are "DB2 v9.7.0.6", "s120516", "IP23328", and Fix Pack
"6".
Product is installed at "/opt/ibm/db2/V9.7".
[db2inst7@s0 ~]$
[db2inst7@s0 ~]$ db2stop force
05/15/2015 15:29:44 0 0 SQL1064N DB2STOP processing was successful.
05/15/2015 15:29:44 1 0 SQL1064N DB2STOP processing was successful.
05/15/2015 15:29:45 2 0 SQL1064N DB2STOP processing was successful.
SQL1064N DB2STOP processing was successful.收起
浏览1284
如果是新的系统， 你就试一下。
db2idrop db2inst1， 再来一次db2icrt收起
db2idrop db2inst1， 再来一次db2icrt收起
浏览1498
1.检查/etc/services 中是否配置每个node端口
db2inst1_tcp 60000/tcp
db2inst1_tcp_END 60020/tcp
如果端口没有配置话，先配置端口试试？
2.如果这样还是有问题的话，可能尝试service network restart。 dpf在安装和配置完成之后，需要重启网络多节点才能生效。收起
db2inst1_tcp 60000/tcp
db2inst1_tcp_END 60020/tcp
如果端口没有配置话，先配置端口试试？
2.如果这样还是有问题的话，可能尝试service network restart。 dpf在安装和配置完成之后，需要重启网络多节点才能生效。收起
浏览1567
是不是有多个 INSTANCE ?收起
浏览1504
浏览1542
浏览1499