Dataquery online error MAX WORK FILE BLOCKS EXCEEDED

Products

• Datacom
• Datacom/DB

Issue/Introduction

Running an online query with Dataquery fails with error:

FIND TERMINATED BECAUSE: MAX WORK FILE BLOCKS EXCEEDED

Cause

When the error occurs online in CICS it indicates that the FNDBLKS limit has been reached.

If the error occurs in batch then the problem is the DQW table is too small, see Article 106078 

Resolution

Do one of the following: 

• Increase the user's override limit for FNDBLK. First display the user in the User Table Maintenance panel DQUU0, then press PF4 (ADDITIONAL OPTIONS) to display the Override System Defaults panel DQUM0. This has to be done for each user that needs the limit increased.
• Increase the system-wide FNDBLKS limit in the Dataquery System Option Table DQOPTLST. The source is in member DQOPTLST in the Datacom CUSMAC library. Sample JCL to assemble and link is in INSTJCL member BDCUSNEW.

If the above steps do not resolve the problem, it could be that the DQF table is too small and needs to be enlarged. Use the same procedure as described in Article 106078 to enlarge the DQW table.

Additional Information

For more informatio about the Dataquery options, see documentation section Tailoring the CA Dataquery System Option Table and  Overriding System Defaults.