[ HELP ] How to audit select statement on specify table for db2 LUW v8 or v9

#1

Hi All,

Any one know how to audit select statement on specify table for db2
LUW v8 or v9 ?

have db2 tools or 3rd party tools can solve ?

Thanks.

#2

wugon.net (AT) gmail (DOT) com wrote:

Quote:

Hi All,

Any one know how to audit select statement on specify table for db2
LUW v8 or v9 ?

have db2 tools or 3rd party tools can solve ?
I can't comment on tools or 3. party.

DB2 Viper 2 provides auditing capabilities that you can slice very
finely (table/user/....)

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

#3

On 10 4 , 12 54 , Serge Rielau <srie... (AT) ca (DOT) ibm.com> wrote:

Quote:

wugon.... (AT) gmail (DOT) com wrote:
Hi All,

Any one know how to audit select statement on specify table for db2
LUW v8 or v9 ?

have db2 tools or 3rd party tools can solve ?

I can't comment on tools or 3. party.
DB2 Viper 2 provides auditing capabilities that you can slice very
finely (table/user/....)

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Thanks your advices,
Where can I find the document about DB2 Viper 2 audit function ?
Thanks your support.

#4

wugon.net (AT) gmail (DOT) com wrote:

Quote:

Thanks your advices,
Where can I find the document about DB2 Viper 2 audit function ?
Thanks your support.
Google is your friend: "DB2 Viper 2 audit"

reveals a db2mag article and two you-tube video's on the topic.
And there there are online docs...

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

[ HELP ] How to audit select statement on specify table for db2 LUW v8 or v9

comp.databases.ibm-db2 comp.databases.ibm-db2

[ HELP ] How to audit select statement on specify table for db2 LUW v8 or v9 - 10-03-2007 , 11:15 AM

Re: [ HELP ] How to audit select statement on specify table for db2LUW v8 or v9 - 10-03-2007 , 11:54 AM

Re: How to audit select statement on specify table for db2 LUW v8 or v9 - 10-03-2007 , 09:09 PM

Re: How to audit select statement on specify table for db2 LUW v8or v9 - 10-05-2007 , 06:54 AM