SQL/QRY monitor job, AA0210C, locks objects and prevents jobs from ending. (NETIQKB38472)

Document ID:7738472
Creation Date:02-Feb-2007
Modified Date:24-Aug-2007
- Micro Focus Products:
  Security Solutions for iSeries

Resolution

fact
VigilEnt Security Agent for iSeries 5.4/7.0

fact
VigilEnt Security Agent for iSeries 7.5

fact
VigilEnt Security Agent for iSeries PSAudit 5.4

fact
VigilEnt Security Agent for PSAudit 7.5

fact
System Auditing and Reporting (SAR)

symptom
SQL/QRY monitor job, AA0210C, locks objects and prevents jobs from ending.

fix

PTFs 1A01551, G1A01501, G1C01516, and 1I01502 must be applied for SQL/QRY Auditing to run properly for version 5.4/7.0. Alternately, an upgrade to Release 7.5 (or later) will resolve the issue.

For Release 5.4/7.0 see the Technical Bulletin (.pdf) that is zipped with G1A01501 for an explanation of the functionality. PTF 1I01502 should be applied first, followed by 1A01551, and then G1A01501, followed by G1C01516.

Once all PTFs are applied, the menu path from a Command Line to the reporting is:

PSMENU, and press Enter.

Select Option 1 PSAudit, and press Enter.

Select Option 1 System Auditing and Reporting, and press Enter.

Select Option 5 Security Reports Menu, and press Enter.

Select Option 3 User and Object Reports Menu, and press Enter.

Select Option 9 SQL/QRY Audit Report, and press Enter.

Additional Information

Formerly known as NETIQKB38472