DQ001E - AN INTERNAL ERROR HAS BEEN DETECTED WITHIN DATAQUERY (DQPPGPR )

Document ID : KB000007307
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

This past weekend we increased the record size for one of our tables from 4000 bytes to 6000 bytes. I did change the DQOPTLST parameter BUFSIZE to 6000 from 4600.However, when we try to run a DQL query against this table we get the following error: 

DQ001E - AN INTERNAL ERROR HAS BEEN DETECTED WITHIN DATAQUERY (DQPPGPR ) 

 

Environment:
z/os .1; CA Datacom/DB 14.0
Cause:

"Need to increase BUFSIZE. Manual says to set the BUFSIZE to the largest record you have (which this person has done) but the BUFSIZE must be larger than that. I don't know how large. " 

BUFSIZE=4600 was working for your table 4000 row length. 

Let's try 

BUFSIZE=6600 for row length 6000 

Resolution:

Be sure to set DQOPTLST BUFSIZE parameter larger than the largest record length.

Additional Information:

None.