By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,586 Members | 2,487 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,586 IT Pros & Developers. It's quick & easy.

get request dynamicaly

P: n/a
Hi

I try to get dynamicaly all requests made to DB2
I process like this:
1) I stop then start my instance of database in the db2 control center
2) I use : db2 update monitor switches using statement on
3) then: db2 get snapshot for dynamic sql on <MyDatabase>

I manage to get logs between instant t1 and t2, but i would like to see
dynamicaly request which come to db2. I mean i would like to see in a
console or a file for exemple request which come when i do an action on
the soft link to the database.

Could you help me ?

Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Even if it doesn't give you what you ask for try the Activity Monitor.
It's a GUI tool where you can monitor different tasks included various
output from the dynamic SQL cache.
You can set a refresh time, export data collected in html etc...

Hope this help.

Dario

Nov 12 '05 #2

P: n/a
Dario wrote:
Even if it doesn't give you what you ask for try the Activity Monitor.
It's a GUI tool where you can monitor different tasks included various
output from the dynamic SQL cache.
You can set a refresh time, export data collected in html etc...

Hope this help.

Dario

Also take a look at EVENT MONITORs

Cheers
Serge

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 12 '05 #3

P: n/a
Even if it doesn't give you what you ask for try the Activity Monitor.
It's a GUI tool where you can monitor different tasks included various
output from the dynamic SQL cache.

thanks i ll have a look

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.