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

book

Article ID: 7307

calendar_today

Updated On:

Products

CA Datacom - DB CA Datacom CA Datacom - AD CA Datacom - Server

Issue/Introduction

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 ) 

 

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 

Environment

z/os .1; CA Datacom/DB 14.0

Resolution

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

Additional Information

None.