DB2 has an AUDIT function (db2audit). Look in the Admin. Guide to see the details. This will allow you to audit CHECKING for SUCCESS for each access to the table in question. This is not selective by table but this is probably the one configuration spec. that will limit performance impact as well as volume of output. Access will be select, update, insert, delete and the putput will specify the reason why it was successful. If you want more detail, you can specify for BOTH which will give give success of access as well as failure and reasons Why.
HTH, Pierre [EMAIL PROTECTED] wrote: > All, > > Can someone describe the steps (if it is even possible to do so) to track > select access to a DB2 UDB V7 table on an AIX box? > > We need to record every single occurrence of a read on a table. > > Any help would be appreciated. > > R/..Ed > > ---------------------- Forwarded by Ed Vetock/40/HQ/NFCU on 12/19/2001 > 04:15 PM --------------------------- > > Ed Vetock > 12/19/2001 03:59 PM > > To: [EMAIL PROTECTED] > cc: Timothy Brocke/40/HQ/NFCU@NFCU > > Subject: Auditing a DB2 UDB V7 table (Document link: Ed Vetock) > > All, > > Can someone describe the steps (if it is even possible to do so) to track > select access to a DB2 UDB V7 table on an AIX box? > > We need to record every single occurrence of a read on a table. > > Any help would be appreciated. > > R/..Ed > > - > ::: When replying to the list, please use 'Reply-All' and make sure > ::: a copy goes to the list ([EMAIL PROTECTED]). > *** You are subscribed to [EMAIL PROTECTED] > *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
begin:vcard n:Saint-Jacques;Pierre tel;cell:514-233-8679 tel;fax:514-737-1268 tel;work:514-737-4515 x-mozilla-html:FALSE org:SES Consultants Inc. adr:;;233 Simcoe Cr.;Mount-Royal;QC;H3P 1X1;Canada version:2.1 email;internet:[EMAIL PROTECTED] title:President fn:Pierre Saint-Jacques end:vcard
