系统集成DPF
dpf创建数据库失败
刚刚弄dpf，不是很熟悉，在vmware上创建两台rhel5.4虚拟机 db2 V9.7照着这个帖子http://www.db2china.net/home/space.php?uid=27514&;do=blog&id=31383跌跌撞撞算是安装ok了但后续创建数据库失败报错为：attempt to create the database "sample" failedSQL1229N the current ...显示全部
查看其它 6 个回答stevenluffy的回答
sql1229n：
The service port numbers assigned for FCM (Fast Communication
Manager) communications are not the same on all nodes in the DB2
instance. Check the services file being used on all nodes to ensure
that the ports are the same. The ports are defined using the format:
DB2_ xxxx/tcp
DB2__END xxxx/tcp
db2diag.log:
2014-07-09-11.44.06.100065+480 I629021E463 LEVEL: Error
PID : 24982 TID : 47586010458432PROC : db2sysc 2
INSTANCE: db2inst1 NODE : 002
APPHDL : 2-52 APPID: *N2.db2inst1.140709034405
AUTHID : DB2INST1
EDUID : 35 EDUNAME: db2agent (instance) 2
FUNCTION: DB2 UDB, base sys utilities, sqleDssCreateDb, probe:10
DATA #1 :
iRC = 0xfffffb33; iRC2 = 0x81580016; SQLCODE = -1229
2014-07-09-11.44.06.176407+480 E629485E665 LEVEL: Error (OS)
PID : 24982 TID : 47586052401472PROC : db2sysc 2
INSTANCE: db2inst1 NODE : 002
EDUID : 15 EDUNAME: db2fcms 2
FUNCTION: DB2 UDB, oper system services, sqloPdbConnectSocket, probe:30
MESSAGE : ZRC=0x810F001D=-2129723363=SQLO_SOCKET_IN_USE
"Socket bound to an address already"
CALLED : OS, -, connect OSERR: EINVAL (22)
DATA #1 : String, 24 bytes
Unable to connect socket
DATA #2 : socket, 4 bytes
19
DATA #3 : sockaddr, 16 bytes
0x00000002003F4458 : 0200 1170 AC64 0A09 0000 0000 0000 0000 ...p.d..........
2014-07-09-11.44.06.277691+480 I630151E403 LEVEL: Severe
PID : 24982 TID : 47586052401472PROC : db2sysc 2
INSTANCE: db2inst1 NODE : 002
EDUID : 15 EDUNAME: db2fcms 2
FUNCTION: DB2 UDB, fast comm manager, sqkfTcpLink::asyncConnect, probe:20
RETCODE : ZRC=0x810F001D=-2129723363=SQLO_SOCKET_IN_USE
"Socket bound to an address already"
2014-07-09-11.44.06.319483+480 E630555E380 LEVEL: Error
PID : 24982 TID : 47586052401472PROC : db2sysc 2
INSTANCE: db2inst1 NODE : 002
EDUID : 15 EDUNAME: db2fcms 2
FUNCTION: DB2 UDB, fast comm manager, sqkfTcpLink::closeConn, probe:25
DATA #1 :
Link info: node 0; type 3; state 1; session 1; activated 1
2014-07-09-11.44.06.427124+480 I630936E415 LEVEL: Severe
PID : 24982 TID : 47586052401472PROC : db2sysc 2
INSTANCE: db2inst1 NODE : 002
EDUID : 15 EDUNAME: db2fcms 2
FUNCTION: DB2 UDB, fast comm manager, sqkfTcpServices::asyncLinkConnect, probe:10
RETCODE : ZRC=0x81590070=-2124873616=SQLKF_CONN_INIT_FAIL
"FCM connection initialization failed"
是不是主机的/etc/services 不同导致的
The service port numbers assigned for FCM (Fast Communication
Manager) communications are not the same on all nodes in the DB2
instance. Check the services file being used on all nodes to ensure
that the ports are the same. The ports are defined using the format:
DB2_
DB2_
db2diag.log:
2014-07-09-11.44.06.100065+480 I629021E463 LEVEL: Error
PID : 24982 TID : 47586010458432PROC : db2sysc 2
INSTANCE: db2inst1 NODE : 002
APPHDL : 2-52 APPID: *N2.db2inst1.140709034405
AUTHID : DB2INST1
EDUID : 35 EDUNAME: db2agent (instance) 2
FUNCTION: DB2 UDB, base sys utilities, sqleDssCreateDb, probe:10
DATA #1 :
iRC = 0xfffffb33; iRC2 = 0x81580016; SQLCODE = -1229
2014-07-09-11.44.06.176407+480 E629485E665 LEVEL: Error (OS)
PID : 24982 TID : 47586052401472PROC : db2sysc 2
INSTANCE: db2inst1 NODE : 002
EDUID : 15 EDUNAME: db2fcms 2
FUNCTION: DB2 UDB, oper system services, sqloPdbConnectSocket, probe:30
MESSAGE : ZRC=0x810F001D=-2129723363=SQLO_SOCKET_IN_USE
"Socket bound to an address already"
CALLED : OS, -, connect OSERR: EINVAL (22)
DATA #1 : String, 24 bytes
Unable to connect socket
DATA #2 : socket, 4 bytes
19
DATA #3 : sockaddr, 16 bytes
0x00000002003F4458 : 0200 1170 AC64 0A09 0000 0000 0000 0000 ...p.d..........
2014-07-09-11.44.06.277691+480 I630151E403 LEVEL: Severe
PID : 24982 TID : 47586052401472PROC : db2sysc 2
INSTANCE: db2inst1 NODE : 002
EDUID : 15 EDUNAME: db2fcms 2
FUNCTION: DB2 UDB, fast comm manager, sqkfTcpLink::asyncConnect, probe:20
RETCODE : ZRC=0x810F001D=-2129723363=SQLO_SOCKET_IN_USE
"Socket bound to an address already"
2014-07-09-11.44.06.319483+480 E630555E380 LEVEL: Error
PID : 24982 TID : 47586052401472PROC : db2sysc 2
INSTANCE: db2inst1 NODE : 002
EDUID : 15 EDUNAME: db2fcms 2
FUNCTION: DB2 UDB, fast comm manager, sqkfTcpLink::closeConn, probe:25
DATA #1 :
Link info: node 0; type 3; state 1; session 1; activated 1
2014-07-09-11.44.06.427124+480 I630936E415 LEVEL: Severe
PID : 24982 TID : 47586052401472PROC : db2sysc 2
INSTANCE: db2inst1 NODE : 002
EDUID : 15 EDUNAME: db2fcms 2
FUNCTION: DB2 UDB, fast comm manager, sqkfTcpServices::asyncLinkConnect, probe:10
RETCODE : ZRC=0x81590070=-2124873616=SQLKF_CONN_INIT_FAIL
"FCM connection initialization failed"
是不是主机的/etc/services 不同导致的
浏览643