How to get the last executed SQL command for each DB connection
I am using DB2 8.2. And I am wondering how to get the last executed SQL command for each DB connection. I tried to get snapshot, but it seems that no such information can be retrieved from DB2 snapshot. Please advise if any related mechanism available. Thanks a lot.
Leave a comment...
- 1 Comments
- Look at the SNAPSHOT_STATEMENT function. You can find out about it by looking at the online documentation located at:
Look in the Reference->SQL->Functions->Table Functions
Andy#1; Tue, 11 Dec 2007 18:18:00 GMT