NW0007Q is set to MAX16MB prior to 8.2.

  • 7012185
  • 23-Apr-2013
  • 26-Apr-2013

Environment

NetIQ Security Solutions for iSeries 8.1 and prior
Remote Request Management (RRM)

Situation

DataQueue NW0007Q is created with a maximum size of 16MB by default.  In environments that use collection, this can impact the performance of RRM, and should be increased to MAX2GB.

Resolution

Use the following on the iSeries to recreate the DataQueue with the larger setting:
  1. ADDLIBLE PSCOMMON
  2. ENDSBS ZPSSMON *IMMED
  3. DLTDTAQ DTAQ(PSCOMMON/NW0007Q)
  4. CRTDTAQ DTAQ(PSCOMMON/NW0007Q)  MAXLEN(85)   SIZE(*MAX2GB)   TEXT('(c) 1995-2013 NetIQ Corp., all rights reserved.') AUT(*ALL)
  5. CHGOBJOWN OBJ(PSCOMMON/NW0007Q) OBJTYPE(*DTAQ) NEWOWN(PSOBJOWN)
  6. GRTOBJAUT OBJ(PSCOMMON/NW0007Q) OBJTYPE(*DTAQ) AUTL(PSCOMMON)
  7. GRTOBJAUT OBJ(PSCOMMON/NW0007Q) OBJTYPE(*DTAQ) USER(*PUBLIC) AUT(*AUTL)

Starting with 8.2, this will be done automatically at install/upgrade.

Cause

Prior to 8.2, the default size when creating the DataQueue, was MAX16MB.