Capturing SQL for analysis

blom0344 · #1 (**permalink**) 03-29-04, 02:16

I am very curious if and how it could 'capture' the SQL statements fired at my datamarts over a period of time.

Using snapshot statements allows me to see them when they are executing, but how to store them for analysis?

We are talking version 7.1. Workgroup edition here running on Windows NT

RKrick · #2 (**permalink**) 03-29-04, 02:52

Why don't you use an event monitor?
Give a look at www.db2click.com, "Tip of the month".

sathyaram_s · #3 (**permalink**) 03-29-04, 05:22

There will be yet another tip on event monitors using pipes in the next couple of days time ..

Cheers
Sathyaram

Quote:

Originally posted by RKrick
Why don't you use an event monitor?
Give a look at www.db2click.com, "Tip of the month".

blom0344 · #4 (**permalink**) 03-30-04, 03:43

Quote:

Originally posted by RKrick
Why don't you use an event monitor?
Give a look at www.db2click.com, "Tip of the month".

Okay, in database manager configuration parameters DFT_MON_STMT is switched to 'on'.

Can I (how?) collect information on SQL statements fired at the specific database with DB2 version 7, or is all of this just possible with version 8?

sathyaram_s · #5 (**permalink**) 03-30-04, 06:10

For event monitors to work, you do not have to switch on the monitor switch ....

Event monitoring is available on V7 also ....

On V8 there has been enhancements to event monitor, like writing the monitor records into a table .... IMHO, this is a perfromance killer when used in OLTP (many short transactions) ... DSS(few long transactions) workload will not make much difference ..

Cheers
Sathyaram

Quote:

Originally posted by blom0344
Okay, in database manager configuration parameters DFT_MON_STMT is switched to 'on'.

Can I (how?) collect information on SQL statements fired at the specific database with DB2 version 7, or is all of this just possible with version 8?

Internet Services

Web Development

Digital Marketing

Consumer Tech