Please post these questions in DB Tools forum : Hi, : I'm using your DB Audit product to track changes in a DB2 8.2 server. : I'm able to track DML changes (Data Audit) without any trouble, however, : I am having some trouble with the DDL changes(Sys Audit). : I have configured a schedule using the DB2 Task Center (to run every minute) : and it runs successfully every time. I've also enabled tracking of all : operations : in the "Set System Audit Options" dialog. This dialog also shows : the current : status of the Auditing to be "System audit is currently ENABLED". : I was expecting that operations like creation of new tables, alter tables etc : would get imported in the DB by the scheduled task and that I could export : them : to a file using the Export button in the DB Audit product. However, the : Export : always results in an empty file. All the reports related to Sys audit also : result in a "No Data Found" report. How can I debug this issue? : Where in the : file system does DB2 write out audit logs? Does the task that I've scheduled : load the DB and clean up the DB2 audit logs? : Thanks in advance, : Raj
|