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
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
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