SQL

By kimot, 22 May, 2023

CPF5272 - I/O error

You can also check actual settings on other files in your libraries.

First run this SQL to collect information about object sizes in all user libraries on your system.

CREATE TABLE YourLibrary.FileName AS (SELECT OBJNAME, OBJLIB,
OBJTYPE, OBJCREATED, OBJSIZE FROM TABLE                    
(QSYS2.OBJECT_STATISTICS('*ALLUSR','*ALL')) X ) WITH DATA

After this step you can list all files with *MAX4GB ordered by file size.

By kimot, 27 December, 2022

BRMS - when specific *USRPRF was saved 

SELECT obhsys, obhlib, obvol, obhseq, obhsvt, obhnam, obhtyp
From QUSRBRM/QA1AOD WHERE obhnam = 'user_profle_name'                
AND obhtyp ='*USRPRF'
SQL