Record History of Queries?

[paulbian]

Hi, I'm very much inexperienced with using DB2 besides the basic queries. There's a problem I'm dealing with, and the simplest solution seems to be recording all the queries that is executed on the database for a short period of time.

Is there an option for DB2 that would allow me to do so? As in:
1. start the process
2. queries made, for example, from a jsp
3. the queries made/history are recorded on file/displayed
4. stop the process and be able to review these actions.

I've been looking into DB2TRC, but I'm not sure if that is the right direction to take.

Any feedback would be appreciated

 

[blom0344]

You do not state on which platform you are working.
Perhaps DB2 query patroller is what you are after?

A really wonderful tool is:

http://chuzhoi_files.tripod.com/

to me it was really useful to monitor user sql aimed at my datamarts. It even gives on-the-fly statistics for a running SQL.

Ties Blom

 

[paulbian]

Thanks for your reply

In the end, I used the Event Monitor and Event Analyzer, didn't know about that neat feature.