Log Analyzer SMF Audit reports not working returning no records found
book
Article ID: 95667
calendar_today
Updated On:
Products
Log Analyzer for DB2 for z/OS
Issue/Introduction
Log Analyzer for Db2 for z/OS (PLA) SMF Audit reports are not working as expected. There are no error codes or messages; reports are returning: NO RECORDS FOUND
Resolution
Documentation from the PLA User Guide related to SMF Audit Trace Overview:
+++++ Before you can produce an SMF Audit Trace report, you must first generate the data for the reports.
To produce an SMF Audit Trace report, complete the following tasks:
1.Use the AUDIT clause in the CREATE/ALTER table SQL statement to turn auditing on for the specific tables you want to audit.
2.Start a trace for the appropriate class using the SMF Audit Trace Reporting facility.
3.Stop the trace for the appropriate trace class using the SMF Audit Trace Reporting facility.
4.Perform an SMF dump of the SMF data set.
5.Use the SMF Audit Trace Reporting facility to report against the SMF data. +++++