Why does the SQL/Query Audit Report not show the detail SQL statement?
NetIQ Security Solutions for iSeries 8.0
VigilEnt Security Agent for iSeries 7.5
System Auditing and Reporting (SAR)
The SQL/Query Monitor does not show the detail SQL statement entered on the STRSQL prompt screen.
I entered a detail SQL statement on the Enter SQL Statements screen, but it's not showing in the SQL/Query Audit Report.
Subsystem ZPSAMON was not active, or it was active but monitor job PSASQLMON was not running under it.
It is recommended you start the subsystem and monitor in the system startup program and in scheduled job entries.
To start the subsystem and monitor, on an iSeries command line, type the following commands, pressing Enter after each:
To start the monitor (and subsystem, if necessary) in a scheduled job entry, type the following command and press Enter: