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

Document ID : KB000020280
Last Modified Date : 09/07/2018
Show Technical Document Details
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 
Instructions:

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==