How to find out which table/URT has caused Datacom/DB RC 05(001) in CICS applications

Products

• Datacom
• DATACOM - AD

Issue/Introduction

Datacom/DB RC 05(001) is issued by Datacom CICS Service Facility and it means that the requested table was not in any User Requirements Table (URT). The reason for this error is usually a SYNONYM problem in the CICS URTs, but it could be a bad table name or a nonexistent table name in the Request Area.

As this return code is not originated by MUF, no PXX dump can be produced for this error, in order to find out the name and DBID of the involved table.

Resolution

If you do not know which URT is involved, do the following to isolate and determine the problem, if it is reproducible:

1. DBOC TRACE,RCBYPASS=00
   <enter>
   
   
2. DBOC TRACE,RCBYPASS=14
   <enter>
   
   
3. DBOC TRACE,RCBYPASS=91
   <enter>
   
   
4. DBOC TRACEON
   
   
5. RERUN test or wait awhile
   
   
6. DBOC INQ=TRACE
   
   
   This should show what the table name was. If the table name is invalid, fix the application and retry. If the table name is valid, issue the following:
   
   
7. DBOC INQ=????.ttt (where ttt is the table name) to check for SYNONYM problem.