BRMS operation may fail with a CPF427F message indicating that the database query estimator has timed out. The query processing time limit can be changed using the Change Query Attributes (CHGQRYA) command. To override the current job's query processing time limit with a value of *NOMAX when BRMS operations are performed, run the following commands:
CRTDTAARA DTAARA(QUSRBRM/Q1AQRYEST) TYPE(*CHAR) LEN(1)CHGOBJOWN OBJ(QUSRBRM/Q1AQRYEST) OBJTYPE(*DTAARA) NEWOWN(QBRMS)
NOTE: After a BRMS operation is performed when data area Q1AQRYEST exists, the job's query processing time limit will still be set and in effect for other database operations.