Tracing SQL against a table.

Glenn mackey

Tracing SQL against a table.
Hi,

I have been asked to look at reporting of all access made to a specific
table(s) - The auditors are in town.
This means all inserts, updates, deletes, selects and DDL.

I know the audit trace can help us to a limited degree but we need more.
I can get a log analyzer tool for the inserts etc.

To capture all Selects, I can start tracing - not sure how to limit that
to a specific table.

I thought this is a good time to ask how other sites meet this need.

Any information would be appreciated.

Glenn


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


DISCLAIMER:
This message and accompanying documents are covered by the
Electronic Communications Privacy Act, 18 U.S.C. 2510-2521, and
contains information intended for the specified individual(s) only.
This information is confidential. If you are not the intended
recipient or an agent responsible for delivering it to the intended
recipient, you are hereby notified that you have received this
document in error and that any review, dissemination, copying, or
the taking of any action based on the contents of this information
is strictly prohibited. If you have received this communication in
error, please notify us immediately by e-mail, and delete the
original message.

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Scott Sloss

Re: Tracing SQL against a table.
(in response to Glenn mackey)
I had to track all deletes done against a certain table once, and I
ended up using a trigger. Worked great and was less expensive that the
audit facility.

Obviously this won't work for selects, but I can dig up the sql if you
want.

Thanks,
Scott F. Sloss
SBS IT - DBA
(973) 712-3603
-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Mackey, Glenn
Sent: Wednesday, January 28, 2009 4:29 PM
To: [login to unmask email]
Subject: [DB2-L] Tracing SQL against a table.

Hi,

I have been asked to look at reporting of all access made to a specific
table(s) - The auditors are in town.
This means all inserts, updates, deletes, selects and DDL.

I know the audit trace can help us to a limited degree but we need more.
I can get a log analyzer tool for the inserts etc.

To capture all Selects, I can start tracing - not sure how to limit that
to a specific table.

I thought this is a good time to ask how other sites meet this need.

Any information would be appreciated.

Glenn


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


DISCLAIMER:
This message and accompanying documents are covered by the
Electronic Communications Privacy Act, 18 U.S.C. 2510-2521, and
contains information intended for the specified individual(s) only.
This information is confidential. If you are not the intended
recipient or an agent responsible for delivering it to the intended
recipient, you are hereby notified that you have received this
document in error and that any review, dissemination, copying, or
the taking of any action based on the contents of this information
is strictly prohibited. If you have received this communication in
error, please notify us immediately by e-mail, and delete the
original message.

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password.
You should have gotten an e-mail with the temporary password assigned to
your account. Please log in and update your member profile. If you are
not already an IDUG.org member, please register at
http://www.idug.org/component/juser/register.html

-----------------------------------------
This message and any attachments are intended only for the use of
the addressee and may contain information that is privileged and
confidential. If the reader of the message is not the intended
recipient or an authorized representative of the intended
recipient, you are hereby notified that any dissemination of this
communication is strictly prohibited. If you have received this
communication in error, notify the sender immediately by return
email and delete the message and any attachments from your system.

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html