I've setup federation between 2 9.5 servers and start getting:
2008-11-07-07.34.06.054433+060 I896702967G1283 LEVEL: Error
PID : 11832 TID : 3143625632 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : NYAVP10
APPHDL : 0-3942 APPID: *LOCAL.db2inst1.081107063407
AUTHID : DB2INST1
EDUID : 144 EDUNAME: db2agent (NYA)
FUNCTION: DB2 UDB, Query Gateway, sqlqgRouter_conn_lost_cleanup, probe:
25
DATA #1 : <preformatted>
Message: Fenced server is not null but not connected,
Cleanup failed for server: STUDERA
CALLSTCK:
[0] 0x02411C63 /home/system/db2inst1/sqllib/lib32/libdb2e.so.1 +
0x1C58C63
[1] 0x02415806
_Z11sqlqgRouterP17sqlqg_FMP_RequestPP15sqlqg_FMP_R eplyP10sqlri_
ufob + 0x395A
[2] 0x053E3D20 sqlqg_fedstp_hook + 0x7E
[3] 0x0239524C _Z11sqlqgDyloadP10sqlri_ufob + 0x10C
[4] 0x027592AF
_Z22sqlriFedInvokerTrustedP10sqlri_ufobP21sqlriRou tineErrorIntf
+ 0x95
[5] 0x02759433
_Z21sqlriFedInvokeInvokerP10sqlri_ufobP14sqlqg_Fmp _Info + 0xF9
[6] 0x023DE641
_Z21sqlqg_Call_FMP_ThreadP17sqlqg_FMP_RequestPP15s qlqg_FMP_Repl
y + 0x20B
[7] 0x023D3DAF _Z13sqlqgFedStartP14UnfencedServerc + 0x551
[8] 0x023CA48A _Z20sqlqgPassthruPrepareP15sqlri_rpassthru + 0x10A
[9] 0x024DEA3C
_Z22sqlrj_passthru_prepareP8sqlrr_cbP11sqlrrstring P14sqlrr_cmpl
_envPi + 0x258
errors in db2diag log.
It does not matter whether the federation takes place on the local
machine or on a remote host, I still get these errors. I can select
from the nicknames just fine, but I'm a bit annoyed by the errors in
the log.
Anyone have a clue on the cause? I've noticed someone else asking this
question, but there was no answer:
http://database.ittoolbox.com/groups...-entry-1956624
Thanks
/Lennart