Tracing a Application using db2pd

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • BAS

    #1

    Tracing a Application using db2pd

    Guys,

    Assume i have taken the db2pd -locks output and there i have seen
    lockesculations


    like this


    +898 0x42D14020 37 000E28090028A50 20000000052 Row .NS W
    171 0 0x0000 0x40000000


    How do you trace the transaction or the application as we dont have the
    application id in this...

    Can anyone throw some light on this...

    Regards,
    Baskar

  • Asphalt Blazer

    #2
    Re: Tracing a Application using db2pd

    The second colum of the db2pd -locks is the transaction handle.

    db2pd -transactions -db <dbname| grep -i <tranhandle>

    will give you the app id as the second column.




    BAS wrote:
    Guys,
    >
    Assume i have taken the db2pd -locks output and there i have seen
    lockesculations
    >
    >
    like this
    >
    >
    +898 0x42D14020 37 000E28090028A50 20000000052 Row .NS W
    171 0 0x0000 0x40000000
    >
    >
    How do you trace the transaction or the application as we dont have the
    application id in this...
    >
    Can anyone throw some light on this...
    >
    Regards,
    Baskar

    Comment

    Working...