系统集成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" failed SQL1229N the current transaction has been rolled back because of a system error. SQLSTATE=40504 /etc/services db2c_db2inst1 60009/tcp db2_db2inst1 60010/tcp db2_db2inst1_1 60011/tcp db2_db2inst1_2 60012/tcp db2_db2inst1_END 60013/tcp db2nodes.cfg 0 db2node1 0 1 db2node1 1 2 db2node2 0 3 db2node2 1 rsh db2node2没问题，db2_all date没问题 db2start/db2stop force都没问题 希望诸位能帮忙解答写 |
IT合作社
附件：
dbm cfg.txt (5.8 KB)
sercices.txt (159 Bytes)
执行命令过程.txt (1.48 KB)
db2diag.log (56.44 KB)
7同行回答
浏览527
主机名太长的问题，修改主机名db2node1,db2node2，问题解决！收起
浏览522
解决了，是主机名太长的问题收起
浏览488
浏览513
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 不同导致的收起
浏览636