SQL Report for an update shows statement but has a ? for the data. (NETIQKB71519)

  • Document ID:7771519
  • Creation Date:10-Apr-2009
  • Modified Date:21-Jan-2014
    • Micro Focus Products:
      Security Solutions for iSeries

Environment

Security Solutions for iSeries 8.0

Security Solutions for iSeries 8.1

PSAUDIT

System Auditing and Reporting (SAR)

SQL/QRY Monitoring


 

Situation

SQL Report for an update shows statement but has a ? for the data.

The report of SQL/QRY Audit Report can't see the actual update value. It just displayed (?).

SQL/QRY Monitor report has ? instead of data

Random entries are missing from SQL/QRY Monitor Report

Resolution

The SQL/QRY monitor uses the IBM Database monitor (STRDBMON) to gather data about the queries used. The IBM Database monitor uses a "?" to replace variables. The actual value is listed after the query.  
 
For 8.0,  please refer to KB 7754444 (www.netiq.com/support/7754444)
 
For 8.1,  PTF 1A04001 and 1A04004 resolves issues where UPDATE and DELETE operstions were not showing the substitution variables.  PTF 1A04007 resolves an issue wehre RUNQRY statements were not being captured on V6R1 (IBM i 6.1).

Additional Information

Formerly known as NETIQKB71519