DB Return code 22 and DQ025 error during DRAW

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

Getting DB Return Code: 22 

Ran a data query and got DQ025E during DRAW command.

Base that was used before it was obsoleted and a new on in place is still the same, but the contents are different still the same base 592.

CXX dictionary is showing record length - old table was much shorter.

Environment:
z/os, CA Datacom/DB 15.1
Cause:

This is normally a problem because a URT does not have SYNONYM specified. 

A DBOC INQ=???.xxx.??? confirmed this. 

 

Resolution:

From similar symptom:

" did a DBOC INQ=???.nnn.??? and discovered 2 urts with this table but SYNONYM NOT included, DQ was getting the wrong URT, she will code in SYNONYM in URT "

 

Customer bypass:

"Did a DBOC INQ to confirm the table does exist in other table. When we closed the other table DQRY ran fine."

 

Additional Information:

Return Code 22 - ELEMENT NAME NOT FOUND

Reason:

The element was not found for one of the following reasons:

â–  The element name specified in the Element List was not defined through DB-ELM-NAME in the CA Datacom Datadictionary element entity-occurrence.

â–  The end of the Element List was not indicated with the required five blanks.

â–  The Element List contained more names than the maximum specified in the MUF startup option. (Examine this possibility first if using the Accounting Facility which generates an element for each field specified.)

Action:

Determine the cause of the problem and implement the corresponding recovery procedure as follows:

â–  If the element was not defined, add the element entity-occurrence to CA Datacom Datadictionary and post it to the Directory.

â–  If the Element List format did not include five blanks as the end-of-list indicator, correct the format.

â–  If the Element List was too long, either reduce the size of the list or increase the maximum number of elements that can be accessed per request. To accommodate the requirements of this request, revise the MUF startup option MAXELRQ.