473,395 Members | 1,530 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

sqlqgRouter_conn_lost_cleanup in db2diag.log


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
Nov 7 '08 #1
0 1531

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: Shawn | last post by:
We are on IBM DB2 7.1 ON WINDOWS. The db2diag.log is not working and no new line written into it for few days. The last lines in db2diag.log shows: Warning: active log held by dirty pages....
3
by: richardshen | last post by:
Instead of watching it manually.
2
by: soccertl | last post by:
I wrote code that parses the db2diag.log to look for errors that would require us to generate a message to a service center indicating something is wrong. My problem is trying to figure out what...
4
by: Praveen_db2 | last post by:
Hi All I am getting strange errors in my db2diag.log can any one tell me what these errors mean?? Following is the code from my db2diag.log...
14
by: Gio Galma | last post by:
how I can invoke the db2diag utility in a Windows environment? in my D:\Program Files\IBM\SQLLIB\BIN directory I can see only db2diag.dll, and it seems there isn't the command line version; which...
1
by: oddbande | last post by:
We have just upgraded a test enviroment to db2 9, and have set both the notifylevel and diaglevel to 3. But even so I get a lot of these messages in my db2diag.log: ...
5
by: Norm | last post by:
Does anyone have any suggestions for securing against this vulnerability: http://nvd.nist.gov/nvd.cfm?cvename=CVE-2007-1027 Fixes are not yet available from IBM. They will be in FP2 for V9...
6
by: KG | last post by:
Hi, Does anyone knows how to recover the test file db2diag.log. By mistake I have delete the contents of db2diag.log, wondering if I could restore the contents of my db2diag.log.
0
by: eddy82 | last post by:
Hi All, I have this db2start in my db2diag.log everyday around the same time. But no db2stop in the db2diag.log or in the db2.nfy. I already check and no corruption or cronjob running during...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.