DB Return code 22 and DQ025 error during DRAW

Products

• Datacom
• DATACOM - AD
• CIS
• COMMON SERVICES FOR Z/OS
• 90S SERVICES
• DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS
• COMMON PRODUCT SERVICES COMPONENT
• Common Services
• CA ECOMETER SERVER COMPONENT FOC
• Easytrieve Report Generator for Common Services
• INFOCAI MAINTENANCE
• IPC
• UNICENTER JCLCHECK COMMON COMPONENT
• Mainframe VM Product Manager
• CHORUS SOFTWARE MANAGER
• CA ON DEMAND PORTAL
• CA Service Desk Manager - Unified Self Service
• PAM CLIENT FOR LINUX ON MAINFRAME
• MAINFRAME CONNECTOR FOR LINUX ON MAINFRAME
• GRAPHICAL MANAGEMENT INTERFACE
• WEB ADMINISTRATOR FOR TOP SECRET
• Xpertware

Issue/Introduction

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.