SEO

#1 (**permalink**) 02-26-2008, 10:16 AM

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

#2 (**permalink**) 02-26-2008, 10:16 AM

Hi Sean,

I am running DB2 for os/390. db2audit is not included in the product
as far as I know.

Amir

#3 (**permalink**) 02-26-2008, 10:16 AM

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

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

SEO

DB2 Catalog Tables Monitoring