How do I clear data queue PSM100Q? (NETIQKB55135)

goal
How do I clear data queue PSM100Q?

fact
PSDetect 7.5

fact
PSDetect 8.0

fact
SQL/QRY Monitor

fact
System Auditing and Reporting (SAR)

fact
PSAudit 7.5

fact
PSAudit 8.0

fact
NetIQ Security Solutions for iSeries

fact
VigilEnt Security Agent for iSeries

symptom
When I run query or SQL command, error CPF950A appears in the joblog.

symptom
Error CPF950A: 'Storage limit exceeded for data queue PSM100Q in PSDETECT.'

cause
PSAudit SQL/QRY Monitor is configured to send alerts when SQL or Query commands are used, but PSDetect job PSDALTMON is not active in subsystem ZPSD to receive the alerts.

fix

If you have configured PSAudit SQL/QRY Monitor to send alerts when SQL or Query commands are used, then PSDetect job PSDALTMON must be active in subsystem ZPSD to receive the alerts from a PSDetect data queue, otherwise the data queue exceeds its maximum size.

To clear this error condition you must clear the PSDetect data queue and optionally configure PSAudit SQL/QRY Monitor to not send alerts when SQL or Query commands are used.

To clear the data queue, run the following command:

CALL PGM(QCLRDTAQ) PARM('PSM100Q' 'PSDETECT')

To configure PSAudit SQL/QRY Monitor to not send alerts when SQL or Query commands are used, refer to the steps below:

1. Starting from PSMENU, select options 1, 1, 7, and 28.
2. Enter a 9 (=End Alert) under the 'Opt' column of the first record.
3. Press F13, press Enter.

Formerly known as NETIQKB55135