View Single Post

   
  #3 (permalink)  
Old 02-26-2008, 10:16 AM
Anton Versteeg
 
Posts: n/a
Default Re: DB2 Catalog Tables Monitoring

You can audit tables on OS/390 with the AUDIT keyword (CREATE/ALTER table)
You cannot audit catalog tables.
See the online bookshelf for details:

http://www-3.ibm.com/software/data/d...0/v7books.html

Amir wrote:

>Hello,
>
>I need to monitor changes in the catalog tables.
>
>1. How can I trap changes in the SYSIBM.SYSTABLES (CREATE and DROP)?
> I prefer not to run heavy SMF trace.
>2. Is there a way to monitor if objects where dropped during cascaded
>revoke command?
>
>Thanks,
>Amir
>
>


--
Anton Versteeg
IBM Certified DB2 Specialist
IBM Netherlands


Reply With Quote