Why does the SQL/Query Audit Report not show the detail SQL statement? (NETIQKB52339)

  • 7752339
  • 02-Feb-2007
  • 22-May-2007

Resolution

goal
Why does the SQL/Query Audit Report not show the detail SQL statement?

fact
NetIQ Security Solutions for iSeries 8.0

fact
PSAudit 8.0

fact
VigilEnt Security Agent for iSeries 7.5

fact
System Auditing and Reporting (SAR) 

fact
PSAudit 7.5

symptom
The SQL/Query Monitor does not show the detail SQL statement entered on the STRSQL prompt screen.

symptom
I entered a detail SQL statement on the Enter SQL Statements screen, but it's not showing in the SQL/Query Audit Report.

cause
Subsystem ZPSAMON was not active, or it was active but monitor job PSASQLMON was not running under it. 

fix

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:

STRSBS PSAUDIT/ZPSAMON
MONMSG CPF0000

To start the monitor (and subsystem, if necessary) in a scheduled job entry, type the following command and press Enter:

PSAUDIT/PSASQLMON ACTION(*START)



Additional Information

Formerly known as NETIQKB52339