CA Dataquery online error MAX WORK FILE BLOCKS EXCEEDED

Products

• Datacom
• Datacom/DB
• Datacom/AD

Issue/Introduction

Running a CA Dataquery query online fails with error:

FIND TERMINATED BECAUSE: MAX WORK FILE BLOCKS EXCEEDED

Environment

Release : 15.0, 15.1

Component : CA Dataquery for CA Datacom

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 CA 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 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

See documentation section Tailoring the CA Dataquery System Option Table and  Overriding System Defaults.

For the same problem in batch see  Article 106078 .