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_con n_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
_Z11sqlqgRouter P17sqlqg_FMP_Re questPP15sqlqg_ FMP_ReplyP10sql ri_
ufob + 0x395A
[2] 0x053E3D20 sqlqg_fedstp_ho ok + 0x7E
[3] 0x0239524C _Z11sqlqgDyload P10sqlri_ufob + 0x10C
[4] 0x027592AF
_Z22sqlriFedInv okerTrustedP10s qlri_ufobP21sql riRoutineErrorI ntf
+ 0x95
[5] 0x02759433
_Z21sqlriFedInv okeInvokerP10sq lri_ufobP14sqlq g_Fmp_Info + 0xF9
[6] 0x023DE641
_Z21sqlqg_Call_ FMP_ThreadP17sq lqg_FMP_Request PP15sqlqg_FMP_R epl
y + 0x20B
[7] 0x023D3DAF _Z13sqlqgFedSta rtP14UnfencedSe rverc + 0x551
[8] 0x023CA48A _Z20sqlqgPassth ruPrepareP15sql ri_rpassthru + 0x10A
[9] 0x024DEA3C
_Z22sqlrj_passt hru_prepareP8sq lrr_cbP11sqlrrs tringP14sqlrr_c mpl
_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:
Thanks
/Lennart