Datacom DDTRSLM DDTRS0015E RC

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

Three CA Workload Automation CA 7® Edition - 12.0  (aka CA 7)  PTFs called for CA 7 job AL2DCA70 from CAL2JCL to be run: RO97207, SO04554, and SO05860. 
When AL2DCA70 was run, the DDTRSLM step gave RC=16 with error message DDTRS0015E but the return code "RC" displayed was blank so the cause was not able to be diagnosed.

How to diagnose the Datacom DDTRSLM utility error when the RC (return code) in the DDTRS0015E error message is blank?

For example:

DDTRS0015E INITDSF FAILED DSF COMMAND USRINITI, RC:    .                  
                                                                          
DDTRS0020I DDTRSLM IS TRYING TO ROLL-BACK THE DATABASE DUE TO ERROR(S):   
DDTRS0021I BACKOUT  SUCCESSFUL                                            
                                                                          
DDTRS0022I ROLLBACK SUCCESSFUL                                            

Environment

z/OS

Resolution

The Datacom DDTRSLM utility should display the DSF return code (RC) in the DDTRS0015E message.

This is resolved by applying the appropriate solution:

Datacom version 15.1 PTF SO04485
Datacom version 15.0 PTF SO04715
Datacom version 14.0 PTF SO07918 

After the solution is applied, rerun the DDTRSLM job and note the DSF RC received.

Refer to CA Datacom Messages section "DSF Return Codes" 
https://techdocs.broadcom.com/us/en/ca-mainframe-software/database-management/ca-datacom-messages/1-0/ca-datacom-db-messages/dsf-return-codes.html

 

Additional Information

In the case noted, after the relevant version of the Datacom PTF was applied to CA Datacom, the RC showed the DSF return code: UNA. 

Return code UNA means: 

USER NOT AUTHORIZED

Reason:

The user specified is not authorized to execute the request.

For users of products accessing CA Datacom®/AD, you may be executing a function that is not allowed. For example, the DDTRSLM utility uses the CREATE TABLE statement during the IMPORT function of transporting an SQL accessible table. The CREATE TABLE and ALTER TABLE functions are not available in an CA Datacom®/AD environment.

Action:

Correct the error and reissue the command, or contact the person responsible for CA Datacom® Datadictionary™ security administration for proper authorization.

The site determined that their security rules were written incorrectly for this Datacom MUF.
Once resolved, the DDTRSLM job ran to completion.