How to Find which SQL Statement is executing

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Saroj kumar
    New Member
    • Aug 2011
    • 1

    How to Find which SQL Statement is executing

    Hi,
    I tried the following thing but I couldn't able to see the sql statement that is curently running. Could you please help me?

    1) db2 "update monitor switches using statement on UOW on"
    2) db2 list application show detail
    3) db2 get snapshot for application applid *LOCAL.stripat2 .110830155202
    4) it displays a lots of thing except the curently running the sql statement.
Working...