Results 1 to 8 of 8
  1. #1
    Join Date
    Aug 2010
    Location
    Sweden
    Posts
    8

    Unanswered: How to execute specific db2pd command when a certain function is seen in db2diag.log?

    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

  2. #2
    Join Date
    Aug 2011
    Posts
    46
    db2pdcfg , take a look.

  3. #3
    Join Date
    Nov 2011
    Posts
    334
    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?????

  4. #4
    Join Date
    Aug 2010
    Location
    Sweden
    Posts
    8
    Quote Originally Posted by amitrai4 View Post
    db2pdcfg , take a look.
    >>> db2pdcfg only works for SQL errors so wont work in this case.

  5. #5
    Join Date
    Aug 2010
    Location
    Sweden
    Posts
    8
    Quote Originally Posted by fengsun2 View Post
    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?????
    Lets say instead of looking for probe points...we focus on MESSAGE FMP exiting with error. Last agent registered:

    How to do that?

  6. #6
    Join Date
    Nov 2011
    Posts
    334
    Can you explain your requirement more specificly?
    I cannt get what do you want?

  7. #7
    Join Date
    Aug 2011
    Posts
    46
    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.

  8. #8
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    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
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •