DB2 for z/OS -- data auditing

Chuck Hensel

DB2 for z/OS -- data auditing
Within the context of PCI, has anyone found a relatively easy way to perform
data auditing on given application table(s) to gather and provide PCI
auditors information about SELECT, INSERT, UPDATE and DELETE DML
actions on given table(s) ?

DB2 logging of SMF type 102 records are one item we are evaluating.
DB2 log file parsing is another.

Anyone have any other ideas ?
Thanks in advance...

---------------------------------------------------------------------------------
Welcome to the DB2 User Group - Indiana list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/DB2-UG-Indiana.html. From that page select "Join or Leave the list". The IDUG Listserv FAQ is at http://www.idugdb2-l.org. The DB2 User Group - Indiana List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Vanessa Reinstatler

Re: DB2 for z/OS -- data auditing
(in response to Chuck Hensel)





----- Original Message -----
From: DB2 User Group - Indiana List <[login to unmask email]>
To: [login to unmask email] <[login to unmask email]>
Sent: Fri Oct 09 16:53:24 2009
Subject: DB2 for z/OS -- data auditing

Within the context of PCI, has anyone found a relatively easy way to perform
data auditing on given application table(s) to gather and provide PCI
auditors information about SELECT, INSERT, UPDATE and DELETE DML
actions on given table(s) ?

DB2 logging of SMF type 102 records are one item we are evaluating.
DB2 log file parsing is another.

Anyone have any other ideas ?
Thanks in advance...

-----------------------------------------------------------------------------
----

Welcome to the DB2 User Group - Indiana list. To unsubscribe, go to the
archives and home page at
http://www.idugdb2-l.org/archives/DB2-UG-Indiana.html. From that page select
"Join or Leave the list". The IDUG Listserv FAQ is at
http://www.idugdb2-l.org. The DB2 User Group - Indiana List Admins can be
reached at [login to unmask email] Find out the latest on
IDUG conferences at http://conferences.idug.org/index.cfm

Cuneyt Goksu

Re: DB2 for z/OS -- data auditing
(in response to Vanessa Reinstatler)
Did you look at the "Tool Space" ?

I know at least two of them and may provide you details off list.

Regards,
Cuneyt

> -----Original Message-----
> From: DB2 User Group - Indiana List
> [mailto:[login to unmask email] On Behalf Of Chuck Hensel
> Sent: Friday, October 09, 2009 11:53 PM
> To: [login to unmask email]
> Subject: DB2 for z/OS -- data auditing
>
>
> Within the context of PCI, has anyone found a relatively easy
> way to perform
> data auditing on given application table(s) to gather and provide PCI
> auditors information about SELECT, INSERT, UPDATE and DELETE DML
> actions on given table(s) ?
>
> DB2 logging of SMF type 102 records are one item we are
> evaluating. DB2 log file parsing is another.
>
> Anyone have any other ideas ?
> Thanks in advance...
>
> --------------------------------------------------------------
> -------------------
>
> Welcome to the DB2 User Group - Indiana list. To unsubscribe,
> go to the archives and home page at
> http://www.idugdb2-l.org/archives/DB2-> UG-Indiana.html. From
> that page select "Join or Leave the
> list". The IDUG Listserv FAQ is at http://www.idugdb2-l.org.
> The DB2 User Group - Indiana List Admins can be reached at
> [login to unmask email] Find out the latest
> on IDUG conferences at http://conferences.idug.org/index.cfm
>

---------------------------------------------------------------------------------
Welcome to the DB2 User Group - Indiana list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/DB2-UG-Indiana.html. From that page select "Join or Leave the list". The IDUG Listserv FAQ is at http://www.idugdb2-l.org. The DB2 User Group - Indiana List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm