Title: How to locate and determine the cause of DB00501E Errors.

book

Article ID: 20280

calendar_today

Updated On:

Products

CA-11 CA Datacom CA DATACOM - AD CA CIS CA Common Services for z/OS CA 90s Services CA Database Management Solutions for DB2 for z/OS CA Common Product Services Component CA Common Services CA Datacom/AD CA ecoMeter Server Component FOC CA Easytrieve Report Generator for Common Services CA Infocai Maintenance CA IPC Unicenter CA-JCLCheck Common Component CA Mainframe VM Product Manager CA Chorus Software Manager CA On Demand Portal CA Service Desk Manager - Unified Self Service CA PAM Client for Linux for zSeries CA Mainframe Connector for Linux on System z CA Graphical Management Interface CA Web Administrator for Top Secret CA CA- Xpertware CA Scheduler Job Management

Issue/Introduction

This knowledge document provides instructions on how to locate and determine the cause of DB00501E errors received by CA Workload Automation Restart Option for z/OS Schedulers (CA 11).

 



Environment

z/OS, CA Datacom/AD 14.0 and higher 

Resolution

Refer to the CA-Datacom/DB Message Guide, and review the section titled CA-Datacom/DB Return Codes when a job fails with a DB00501Eerror while being processed by CA 11.

Each Return Code is documented with a chart that provides the reason and action which causes or generates the return code.

The DB00501E error will have the following format:

22.41..41 STC0331 CA11MUF:DB00501E -OPEN ERROR - RETURN CODE XX (###)

The most common DB00501E errors with their description and probable cause are listed below:

   
Return Code: 02 (52)Request was an OPEN and one of the tables is not defined to the Directory or the request was an OPEN and all the tables in the area are being backed up or extracted and are in an a "NOT LOADED" status.
If the table was not defined to the Directory, define the table in CA Datacom Datadictionary and post the definition to the Directory. If the table name was misspelled, correct the spelling.
Return Code: 25 (20)Request was an OPEN, and the table being opened references a database which is not defined to the Directory.
If an invalid database ID was specified in the request, correct it.
Return Code: 57 (1)The address passed to CA-Datacom/AD in a multi-tasking environment is invalid.
Ensure that the program specifically opens the User Requirements Table if OPEN=USER was specified in the DBURINF macro of this User Requirements Table.
Return Code: 68 (1)MULTI-USER FACILITY IS NOT UP.
Either the MUF is not up or your CUSLIB is not pointing to the correct MUF.
Return Code: 69 (71)Data in a table cannot be accessed because no current index exists for that table.
Rebuild the index with the RETIX option of DBUTLTY.
Return Code: 85 (2)The job has requested XCF access to a remote Multi-User Facility and there are insufficient tasks defined in the MUF startup option TASKS xcfnumber parameter to satisfy this request.
Return Code: 87 (2)The sender was not included in the XCFFROM list in the DBSIDPR macro.
Recycle MUF after correcting the DBSIDPR parameter XCFFROM.
Return   
Code 88(85)
A database was disabled from being opened by an ACCESS OFF or ACCESS READ console command, the DBUTLTY ACCESSOPTION=OFF/READ DISABLE.  
To enable a database from a user disable, execute either the ACCESS WRITE nnnn console command or the DBUTLTY ACCESS STATUS=WRITE,DBID=nnnn function.

Additional Information

please refer to the following documentation for more Datacom Return codes:

https://docops.ca.com/ca-datacom/15-1/en/message-search#modal=content&path=/ca-datacom-messages/en/ca-datacom-db-messages/ca-datacom-db-return-codes/ca-datacom-db-return-codes-quick-reference&title=IENBIERhdGFjb20vREIgUmV0dXJuIENvZGVzIFF1aWNrIFJlZmVyZW5jZQ==