From: Toussi Davoud (davoud.toussi@EDB.COM)
Date: Mon Oct 21 2002 - 11:10:25 EDT
Hi,
I've prob. with DB2 on HACMP environment!?
Before I start db2 on standby server I change the hostname of standby server
to the production server (hostname prodsrv).
After that I do "db2start" as user db2as and db2inst1. When I try to connect
to the remote database I got the SQL30081N error.
I also copied all files from prodsrv:/var/db2 to standby server. The
/etc/services have also same info about port nr. The DB2 software is
installed on both servers.
Do you have any idea what could be the problem?
Here are some info from the database:
$ db2 list database directory
===========================================
System Database Directory
Number of entries in the directory = 2
Database 1 entry:
Database alias = WAS
Database name = WAS
Local database directory = /HAhome/db2inst1
Database release level = 9.00
Comment =
Directory entry type = Indirect
Catalog node number = 0
Database 2 entry:
Database alias = WAS1
Database name = WAS
Node name = DB2NODE
Database release level = 9.00
Comment =
Directory entry type = Remote
Catalog node number = -1
$ db2 list node directory
==================================================
Node Directory
Number of entries in the directory = 1
Node 1 entry:
Node name = DB2NODE
Comment =
Protocol = TCPIP
Hostname = prodsrv
Service name = db2cdb2inst1
Output from db2dump/db2diag.log file:
================================================
2002-10-21-16.44.11.963659 Instance:db2inst1 Node:000
PID:15246(db2bp) Appid:*LOCAL.db2inst1.021021144340
common_communication sqlcctcpconnr Probe:101
DIA3202C The TCP/IP call "connect" returned an errno="79".
Data Title:SQLCA PID:15246 Node:000
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -30081 sqlerrml: 31
sqlerrmc: 79 * * TCP/IP SOCKETS connect
sqlerrp : sqlearcn
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x000000FF (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
Data Title:DB2RA PID:15246 Node:000
5351 4c44 4232 5241 0000 0164 0105 0001 SQLDB2RA...d....
0003 001c 0000 0088 0000 0009 2ff2 2870 ............/ò(p
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 000d 0000 0004 ................
2ff2 1ce4 0000 0000 0000 0001 0000 0000 /ò.ä............
0000 0003 0000 0001 2005 5e4e 0000 0000 ........ .^N....
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0004 0000 0002 2ff2 1ce0 0000 0000 ......../ò.à....
0000 0001 0000 0000 0000 0004 0000 0004 ................
2ff2 1cdc 0000 0008 0000 0001 2006 6ea0 /ò.Ü........ .n
0000 0008 0000 0001 2ff2 1d04 0000 0000 ......../ò......
0000 0000 0000 0000 0000 00a8 4000 000c ...........¨@...
2ff2 1d40 0000 0401 8000 0001 2006 adfc /ò.@........ .ü
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0001 0000 0000 0000 0002 ................
0000 0003 2ff2 1cd0 0000 0000 0000 0000 ..../ò.Ð........
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0001 0000 0000 0000 0004 0000 0007 ................
2ff2 1e88 /ò..
Data Title:SQLCA PID:15246 Node:000
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -900 sqlerrml: 0
sqlerrmc:
sqlerrp : SQLEDBCN
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
Data Title:DB2RA PID:15246 Node:000
5351 4c44 4232 5241 0000 00e0 0105 0002 SQLDB2RA...à....
000c 000a 0000 0088 8000 0009 2ff2 27a0 ............/ò'
0000 0000 4000 0004 0000 0000 0000 000b ....@...........
4000 0004 2ff2 2420 0000 0002 4000 0003 @.../ò$ ....@...
2ff2 277c 0000 0008 4000 0001 2005 27b8 /ò'|....@... .'¸
0000 0008 4000 0001 2005 27d2 0000 0008 ....@... .'Ò....
4000 0001 2005 27c0 0000 0000 0000 0000 @... .'À........
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0001 4000 0004 2ff2 23f1 ....@.../ò#ñ
This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 22:16:16 EDT