STRDBMON failed with error msg id: CPF436A (NETIQKB70910)

  • Document ID:7770910
  • Creation Date:05-Feb-2008
  • Modified Date:20-Nov-2015
    • Micro Focus Products:
      Security Solutions for iSeries

Environment

NetIQ Security Solutions for iSeries 8.1

NetIQ Security Solutions for iSeries 8.0

PSAudit

System Auditing and Reporting

SQL/QRY Monitor

STRDBMON

Situation

SQL/QRY Monitor will not start after upgrading OS to newer version

STRDBMON failed with error msg id: CPF436A

No data on the SQL/QRY Report after upgrade to 8.1or 8.0

Resolution

Instructions for 8.0:

1.  Apply PTF 1A3008 if not already applied.  To check the PTF listing use command DSPPTF 1PSA001

2.  Run the instructions for 8.1


Instructions for 8.1, and 8.0 (after applying PTF 1A03008 for 8.0):

1.  Stop the SQL query monitor:  PSAUDIT/PSASQLMON ACTION(*STOP) OPTION(*IMMED)

2.  Check for locks on the SAR0514F file: WRKOBJLCK OBJ(PSAUDIT/SAR0514F) OBJTYPE(*FILE)

3.  RNMOBJ PSAUDIT/SAR0514F *FILE SAR0514Fxx

4.  CRTDUPOBJ OBJ(QAQQDBMN) FROMLIB(QSYS) OBJTYPE(*FILE) TOLIB(PSAUDIT) NEWOBJ(SAR0514F)

5.  GRTOBJAUT PSAUDIT/SAR0514F *FILE REFOBJ(PSAUDIT/SAR0514Fxx)

6.  Start the SQL query monitor: PSAUDIT/PSASQLMON ACTION(*START)

 

Cause

Format for file QAQQDBMN in QSYS changed with OS upgrade.

Additional Information

Formerly known as NETIQKB70910

PTFs are located at https://www.netiq.com/support/iseries/extended/hotfixes.asp   Click the 8.0 tab.  Registration is required to access Hotfixes for the NetIQ Security Solutions for iSeries products.