Hi,
does anyone have any idea what the following entry in the DB2 diag log
means?
And more importantly - how significant that message is, does it have any
impact on the instance, database, performance, stability, etc.?

Regards,
Damir

2010-10-25-12.34.55.836631+120 I345513A1187 LEVEL: Warning
PID : 2200258 TID : 175298 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : PPZPROD
APPHDL : 0-52857 APPID: GAEF7653.GE09.10D945100337
AUTHID : PPZ
EDUID : 175298 EDUNAME: db2agent (PPZPROD) 0
FUNCTION: DB2 UDB, base sys utilities, sqeAgent::AgentBreathingPoint,
probe:16
CALLSTCK:
[0] 0x0900000004A6F3A4 pdLog + 0xEC
[1] 0x09000000045FA0F4 pdLog@glue41E + 0x94
[2] 0x09000000072F6D90 AgentBreathingPoint__8sqeAgentFi + 0x76C
[3] 0x09000000049091E8 AgentBreathingPoint__8sqeAgentFi@glue19E + 0x78
[4] 0x0900000004909128 sqldFetchDirect__FP13SQLD_DFM_WORK + 0x8E8
[5] 0x09000000050587FC sqldDataFetch__FP8SQLD_CCBP8SQLZ_RIDUlP7SQLI_CB +
0x61C
[6] 0x0900000004906834
..@147 (AT) sqliScanLeaf2 (DOT) fdpr.clone.19__FP7SQLI_CBP11SQLI_SFGLOB + 0x2F8
[7] 0x0900000004907770 sqlifnxt__FP7SQLI_CBP11SQLI_SFGLOB + 0x2B8
[8] 0x0900000004901C24
..sqlirdk.fdpr.clone.1991__FP8sqeAgentP10SQLI_IXPC RP9SQLD_IXCBUlP8SQLD_KEYP12SQLI_KEYDATAP9sqli_scan Pi
+ 0xC80
[9] 0x090000000490ADA4
..sqldIndexFetch.fdpr.clone.313__FP8SQLD_CCBP8SQLZ _RID + 0x1C0

On Oct 25, 5:22*am, "Damir" <damirwil... (AT) yahoo (DOT) com> wrote:
Hi Damir,

Here is the response from experts in this area:

---
The case we're hitting is one where the client app has dropped its
connection (or was killed) without properly terminating its connection
with DB2, so it's basically an edge case / abnormal behaviour on the
app side. In these cases we have always dumped a warning to the
db2diag.log indicating that we detected a dropped connection and are
rolling back whatever work it had in progress to help us diagnose
problems - the only difference here is that we're now also dumping a
stack as well indicating where we detected the client death.
---

Did you see a warning in db2diag.log that indicated "client connection
error" just prior to the stack dump above? If so, you may want to look
into why the application might not have shutdown cleanly. More
specific to your question, the above stack dump is mainly to assist
DB2 service if/when they are called to investigate a problem.

Naresh