Error: SQL7019 encountered while running PSAUDIT reports. (NETIQKB46866)

  • 7746866
  • 02-Feb-2007
  • 08-Oct-2007

Resolution

fact
System Auditing and Reporting (SAR) 

fact
NetIQ Security Solutions for iSeries 8.0

fact
PSAudit 8.0 System Auditing and Reporting

fact
PSAudit 8.0

fact
VigilEnt Security Agent for iSeries 7.5

symptom
Error: SQL7019 encountered while running PSAUDIT reports.

symptom

Error: Specified server &1 is no longer the current server &2 is now the current server error appears in joblog



symptom
Error: RUN QUERY command failed with SQLCODE -7019

cause
This is a known issue on IBM OS/400 V5R2 and V5R3 where the cached *LOCAL RDB name is not updated when the RDB name is removed and re-added.

fix

To update the RDB name, either apply IBM PTF SI16116 or remove object QRWCACHE type *USERSPC from QSYS.

For more information about IBM APAR SE17904, see: http://www-912.ibm.com/n_dir/nas4apar.NSF/1be1a5b61b213a6c86256c23007048f4/693a2beb1f6a52a586256f3300700521?OpenDocument&Highlight=0,SE17904.



Additional Information

Formerly known as NETIQKB46866