安装 DPF 遇到的问题？(问题不断更新中)

macrozeng · 发表于 2007-12-5 12:22

安装完了 DPF , 执行  对比 db2_all 没问题

[db2inst1@DPF1 ~]$ db2_all date

connect to address 172.16.11.111: Connection refused
Trying krb4 rsh...
connect to address 172.16.11.111: Connection refused
trying normal rsh (/usr/bin/rsh)
Wed Dec  5 11:28:20 CST 2007
DPF1: date completed ok

connect to address 172.16.11.111: Connection refused
Trying krb4 rsh...
connect to address 172.16.11.111: Connection refused
trying normal rsh (/usr/bin/rsh)
Wed Dec  5 11:28:23 CST 2007
DPF1: date completed ok

connect to address 172.16.11.112: Connection refused
Trying krb4 rsh...
connect to address 172.16.11.112: Connection refused
trying normal rsh (/usr/bin/rsh)
Wed Dec  5 11:23:17 CST 2007
DPF2: date completed ok

connect to address 172.16.11.112: Connection refused
Trying krb4 rsh...
connect to address 172.16.11.112: Connection refused
trying normal rsh (/usr/bin/rsh)
Wed Dec  5 11:23:20 CST 2007
DPF2: date completed ok

但是在 DPF1 上执行 db2stop 、db2start 、db2 create 分别是下面的结果

[db2inst1@DPF1 ~]$ db2stop
12/05/2007 11:29:02    2 0 SQL6036N  START or STOP DATABASE MANAGER command is already in progress.
12/05/2007 11:29:02    3 0 SQL6036N  START or STOP DATABASE MANAGER command is already in progress.
12/05/2007 11:29:06    0 0 SQL1032N  No start database manager command was issued.
12/05/2007 11:29:06    1 0 SQL1032N  No start database manager command was issued.
12/05/2007 11:29:06    2 0 SQL6036N  START or STOP DATABASE MANAGER command is already in progress.
12/05/2007 11:29:07    3 0 SQL6036N  START or STOP DATABASE MANAGER command is already in progress.
SQL6033W  Stop command processing was attempted on "4" node(s).  "0" node(s) were successfully stopped.  "2" node(s) were already stopped.  "2" node(s) could not be stopped.

[db2inst1@DPF1 ~]$ db2start
12/05/2007 11:29:16    2 0 SQL6036N  START or STOP DATABASE MANAGER command is already in progress.
12/05/2007 11:29:16    3 0 SQL6036N  START or STOP DATABASE MANAGER command is already in progress.
12/05/2007 11:29:18    1 0 SQL1063N  DB2START processing was successful.
12/05/2007 11:29:18    0 0 SQL1063N  DB2START processing was successful.
SQL6032W  Start command processing was attempted on "4" node(s).  "2" node(s) were successfully started.  "0" node(s) were already started.  "2" node(s) could not be started.

[db2inst1@DPF1 ~]$ db2 create db test
SQL1229N  The current transaction has been rolled back because of a system
error.  SQLSTATE=40504

而在另外一个节点 DPF2 上执行 db2start 和 db2stop 都报 File I/O error
[db2inst1@DPF2 ~]$ db2start
SQL1652N  File I/O error occurred.
[db2inst1@DPF2 ~]$ db2stop
SQL1652N  File I/O error occurred.

是不是哪里没设置好呢？

[ 本帖最后由 macrozeng 于 2007-12-7 17:04 编辑 ]

macrozeng · 发表于 2007-12-5 12:24

说下环境
VM 上的 RHEL4U5 下的 V9.1

[root@DPF1 ~]# cat /db2home/db2inst1/sqllib/db2nodes.cfg
0 DPF1 0 172.16.11.111
1 DPF1 1 172.16.11.111
2 DPF2 0 172.16.11.112
3 DPF2 1 172.16.11.112
[root@DPF1 ~]# cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
172.16.11.111 DPF1
172.16.11.112 DPF2

macrozeng · 发表于 2007-12-5 12:33

安装参考的文档是

http://www.ibm.com/developerwork ... es/dm-0504mcarthur/

[ 本帖最后由 macrozeng 于 2007-12-5 13:23 编辑 ]

macrozeng · 发表于 2007-12-5 12:55

刚刚又用 db2stop force 测试了一下，发现错误信息不同

[db2inst1@DPF1 ~]$ db2stop
12/05/2007 11:39:03    2 0 SQL6036N  START or STOP DATABASE MANAGER command is already in progress.
12/05/2007 11:39:03    3 0 SQL6036N  START or STOP DATABASE MANAGER command is already in progress.
12/05/2007 11:39:07    0 0 SQL1064N  DB2STOP processing was successful.
12/05/2007 11:39:08    2 0 SQL6036N  START or STOP DATABASE MANAGER command is already in progress.
12/05/2007 11:39:08    3 0 SQL6036N  START or STOP DATABASE MANAGER command is already in progress.
12/05/2007 11:39:08    1 0 SQL1064N  DB2STOP processing was successful.
SQL6033W  Stop command processing was attempted on "4" node(s).  "2" node(s) were successfully stopped.  "0" node(s) were already stopped.  "2" node(s) could not be stopped.

[db2inst1@DPF1 ~]$ db2stop force
12/05/2007 11:39:15    2 0 SQL6036N  START or STOP DATABASE MANAGER command is already in progress.
12/05/2007 11:39:15    3 0 SQL6036N  START or STOP DATABASE MANAGER command is already in progress.
12/05/2007 11:39:19    2 0 SQL1652N  File I/O error occurred.
12/05/2007 11:39:20    3 0 SQL1652N  File I/O error occurred.
12/05/2007 11:39:23    0 0 SQL1032N  No start database manager command was issued.
12/05/2007 11:39:24    1 0 SQL1032N  No start database manager command was issued.
12/05/2007 11:39:24    2 0 SQL1652N  File I/O error occurred.
12/05/2007 11:39:24    3 0 SQL1652N  File I/O error occurred.
SQL6033W  Stop command processing was attempted on "4" node(s).  "0" node(s) were successfully stopped.  "2" node(s) were already stopped.  "2" node(s) could not be stopped.