Do Not Allow BRMS to Change the Job Query Time Limit to NOMAX - Q1AQRYEST

Owned by Kathy Kurth
Last updated: Dec 20, 2019 by Aaron Fistler
1 min read

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.

Copyright © Fortra, LLC and its group of companies. All trademarks and registered trademarks are the property of their respective owners.