FIND TERMINATED BECAUSE: MAX WORK FILE BLOCKS EXCEEDED
Explanation: Your batch query required more find blocks than allowed by the current DQW file allocation.
User Response: Increase the size of the DQW table or decrease the number of partitions in the current DQW table allocation.
So,the DQW file is either - too small for the request or - the request is generating too many rows (output too large).
Environment
z/os, CA Datacom/DB 15.1
Resolution
Steps to enlarge the DQW file:
1- Use a DBOC CLOSE=003 command to close the URT in CICS.
2- Run a DBUTLTY step with SYSIN: ACCESS DBID=003,STATUS=OFF,USERS=WAIT COMM DBID=003,OPTION=CLOSE
3- Enlarge DQW file and execute DBUTLTY step to INIT and LOAD FORMAT=NONE the DQW file using SYSIN: INIT AREA=DQW,DBID=003 LOAD AREA=DQW,DBID=003,FORMAT=NONE
4-Run a DBUTLTY step with SYSIN: ACCESS DBID=003,STATUS=WRITE
6 - Issue a DBOC OPEN=003 command to open the URT in CICS
Note: to know how many partitions you currently have: Execute program DQWFINIT with input card DQW ??? . DQW in positions 1-3 and ??? in positions 5-7 . (Default is 3).
see knowledge document 000067739 for more info about number of DQW partitions: https://ca--c.na60.visual.force.com/apex/CustomKnowledgeEdit?articleId=ka00c000000yEAMAA2