Environment
NetIQ Security Solutions for iSeries 8.1
PSDETECT
Situation
CPF5021 or RPG1255 when opening the Alert or Console Log in PSDETECT
Error messages that will be in the joblog of the user experiencing this issue:
CPF5021 Sender copy 30 21/03/13 09:48:42.033439 QSFPUT QSYS 0E7D QSFPUT QSYS 0E7D
Message . . . . : Incorrect relative record number or field selection error.
and
Message ID . . . . . . : RPG1255 Severity . . . . . . . : 99
Message type . . . . . : Inquiry
Date sent . . . . . . : 21/03/13 Time sent . . . . . . : 09:05:34
Message . . . . : Session or device error occurred (C G S D F).
Cause . . . . . : The RPG program PSM075R in library PSDETECT at statement
71700 detected a session or device error. Recovery may be possible. Examine
the major/minor return code value to determine the specific error that
Resolution
To clear the subfile PSM070P:
1) ENDSBS ZPSD *immed
2) Wait until all jobs have ended in the subsystem, then
3) CLRPFM FILE(PSDETECT/PSM070P)
4) Once it's finished, STRSBS PSDETECT/ZPSD
Cause
The OS has a limit of 9999 records in a subfile. When the number of records passes this number, it does not know how to handle the extra rows. PSM070P is the subfile in question for this issue.