audit trails for table structure changes

How can find the table structure changes in unbuffered logging database ? Are there any audit trails in the systables to find out the regular table structure changes ? thanks Ravi Yarlagadda

Ravi; There are no audit trails in systables, but all DDL (Data Definition Language = structural changes) are recorded in the logical logs, regardless of the logging mode of the database. You can use the 'onlog' utility to examine the logical logs, and filter for specific tablespaces if you want, but you need to use this utility with caution - it can lock up your system while you're running it, so you need to know how it works before you use it. HTH... Mike =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Mike Lowe Certified Consulting Education Specialist Data Management Solutions IBM Software Group Tel: 303-773-5216 Tie Line: 565-5216 e-Fax: 413-674-2415 mlowe0@us.ibm.com WWW: ibm.com/software/data How can find the table structure changes in unbuffered logging database ? Are there any audit trails in the systables to find out the regular table structure changes ? thanks Ravi Yarlagadda

P.S. - the output from 'onlog' will be almost impossible for you to understand without help from tech support - you won't find the SQL that does the "ALTER TABLE" command - it's much lower level information than that. Mike =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Mike Lowe Certified Consulting Education Specialist Data Management Solutions IBM Software Group Tel: 303-773-5216 Tie Line: 565-5216 e-Fax: 413-674-2415 mlowe0@us.ibm.com WWW: ibm.com/software/data "Yarlagadda,...." <ryarlagadda@laba To: ids@iiug.org ttusa.com> cc: Sent by: Subject: audit trails for table structure changes [245] forum.subscriber@ iiug.org 02/05/2003 09:25 AM How can find the table structure changes in unbuffered logging database ? Are there any audit trails in the systables to find out the regular table structure changes ? thanks Ravi Yarlagadda