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 )
"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.
BUFSIZE=6600 for row length 6000
z/os .1; CA Datacom/DB 14.0
Be sure to set DQOPTLST BUFSIZE parameter larger than the largest record length.