TRACEing DDL, DCL

Philip Sevetson

TRACEing DDL, DCL
We're encountering a need to audit our DCL and DDL -- we've had a couple
of grants disappear. Can anyone point me to the statistics/accounting
classes and IFC-IDs (Or other information?) which I need to have running
to capture this information?

--Phil Sevetson
Database Administration
Wakefern Food Corporation CISD
mailto:[login to unmask email]


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Venkat Srinivasan

Re: TRACEing DDL, DCL
(in response to Philip Sevetson)
Check IFCID 62. Look in DSNDQW01 member of SDSNMACS. you should get enough
info.
Regards,
Venkat

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Venkat Srinivasan

Re: TRACEing DDL, DCL
(in response to Venkat Srinivasan)
BTW, other than the IFICD info you wanted, you wd actually need an audit
trace and not a stats / acctg to find who is using the ddls.
Venkat

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm