Log Analyzer SMF Audit reports not working returning no records found
search cancel

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. 
+++++