I want to monitor all sql statements

[Christos Kalantzis]

Hello,

Is there a tool, open-source or other, that allows ALL db statements to
be logged?

I run db2 express 8.2 on Linux.
Can Query patroller be installed on express or is it limited to Enterprise?

Thank you,

Christos

[Mark]

Christos Kalantzis <ch*******@intertrade.com> wrote in message news:<FD*********************@weber.videotron.net> ...

Hello,

Is there a tool, open-source or other, that allows ALL db statements to
be logged?

I run db2 express 8.2 on Linux.
Can Query patroller be installed on express or is it limited to Enterprise?

Thank you,

Christos

GET SNAPSHOT FOR DYNAMIC SQL ON database-alias > filename

You will need to first turn on the monitor switch in the dbm
(instance) configuration.

UPDATE MONITOR SWITCHES USING STATEMENT ON

See the Command Reference manual.

[richard]

Christos Kalantzis <ch*******@intertrade.com> wrote in message news:<FD*********************@weber.videotron.net> ...

Hello,

Is there a tool, open-source or other, that allows ALL db statements to
be logged?

I run db2 express 8.2 on Linux.
Can Query patroller be installed on express or is it limited to Enterprise?

Thank you,

Christos

IBM: DB2 Event Monitor, to capture all of them.
BMC: performance tools for this.