I am not sure I understand the issue. Can you confirm the following: 1. System audit is enabled and working 2. When you run a system-audit or compliance report and get a prompt to flush recent events to the audit trail you get no errors 3. You can see system-audit and compliance reports on the screen but cannot export them to a file : I posted this in the 24x7 board by mistake - reposting the same here : 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
|