z/os ADABAS 742
We are getting occasional 3074 errors on our production database.
We have a program that has the following statement:
FIND-NUM. FIND NUMBER AT WITH CPNY-IVST-GRUP-TYPE-DATE-KEY
= #CPNY-IVST-GRUP-TYPE-DATE-KEY THRU #CPNY-IVST-GRUP-TYPE-DATE-END
I reckon this will process 325,209 unique index entries. This statement works OK but around the same time it is executing we get a number of 3074 errors on another program which has the following statement:
FIND (1) VAR-DATA WITH HOLD-RQST-VAR = HOLD-RQST-VAR
This should process one unique index entry only but note that HOLD-RQST-VAR contains a PE field.
We have LWKP2=3072 which based on the formula in the manuals should handle 2,176,175 records so we should be nowhere near blowing the limit. Furthermore, I didn’t think that the second statement would use work part 2. (Other parameters LS=50000, LWP=750000)