Hello DB2 Experts,

Here is an example...

I want to execute "db2pd -eve" and "db2pd -db TEST -dpsdbcb 3" when I see probe point sqlerFmpListener, probe:999 in db2diag.log. Like...


2012-01-01-01.05.02.328002-660 I154143A452 LEVEL: Error
PID : 2302160 TID : 772 PROC : db2fmp (C) 0
INSTANCE: db2inst2 NODE : 000
EDUID : 772 EDUNAME: db2fmp (C) 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerFmpListener, probe:999
MESSAGE : FMP exiting with error. Last agent registered:
DATA #1 : Hexdump, 4 bytes
0x00000001102C7EE8 : 0000 0000 ....

Please let me know how to capture these db2pd outputs as soon as we see this above probe point? Appreciate if you can share the details.

Thanks,
Jenny

db2pdcfg , take a look.

i think this probe point is used for db2 code developer to do some trace analysis。。。。
We can't add or change this probe point .
Why do you think the probe point has any relationship with the db2pd command?????

>>> db2pdcfg only works for SQL errors so wont work in this case.

Lets say instead of looking for probe points...we focus on MESSAGE FMP exiting with error. Last agent registered:

How to do that?

Can you explain your requirement more specificly?
I cannt get what do you want?

On v9.7:

C:\Documents and Settings\Administrator>db2pdcfg -catch diagstr="FMP exiting with error"
Error Catch #1
Sqlcode: 0
ReasonCode: 0
ADMCode: 0
DiagText: FMP exiting with error
ZRC: 0
ECF: 0
Component ID: 0
LockName: Not Set
LockType: Not Set
Current Count: 0
Max Count: 255
Bitmap: 0x8421
Action: Error code catch flag enabled
Action: Execute C:\PROGRA~1\IBM\SQLLIB\bin\db2cos.bat callout script
Action: Produce stack trace in db2diag.log

for prior versions you can use ZRC or ECF code.

schedule a script that will execute db2diag with a specific timeframe
eg 10 min interval schedule and execute db2diag for last 10 minutes
when you get the message - execute the command (with some delay)
or you check the diag.log all the time and act when error occures