Datacom/AD RC 15(139) with CA 7

Products

• DATACOM - AD
• CA 7 Workload Automation

Issue/Introduction

Running  Datacom/AD 15.1 Multi-User ( MUF). 

CA 7 fails due to security error : 

ICH408I USER(CA7STC  ) GROUP(STC     ) NAME(CA7*STC*ID          )

   PRODALT.DB00002.ATZ CL(DC@ABLE )                               

   INSUFFICIENT ACCESS AUTHORITY                                  

   FROM PRODALT.DB00002.* (G)                                      

   ACCESS INTENT(READ   )  ACCESS ALLOWED(NONE   )                

MUF log shows: 

SQL INITIALIZATION:  MUF IS SECURED                                            

DBSRPPR: Initializing Source Cache                                              

-- DATA BASE SQL ERROR SUMMARY   --                         

SQLSTATE R158B OCCURRED WITH SQL ERROR CODE -118 IN PROG    GETEN AT LINE 972 (D DSERV)

ERROR MESSAGE TEXT:    DSF 'D000' DB RETURN COMMAND = REDKG  FILENAME = ATZ  KEYNAME = ATZKS PGM = RTV

RETURN CODE FROM DB:   <15(139)>, FROM DSF: <D000>                             

AUTH-ID.PLAN NAME:     SYSADM.SQLSCPLAN                                        

COMMAND(STATEMENT ID): QEXEC(STATEMENT 16)                                      

JOB NAME:              CA7, RUN UNIT: nnnnn  

Environment

Z/OS 

Datacom/AD 15.1

Workload Automation CA 7  12.x

Cause

CA 7 user-id  has no read access to tables in Datacom system database  DBID 2 , DATA-DICT.

Resolution

Install Datacom SQL 15.1 PTF LU00602 or higher.

Additional Information

For documentation , see SQL Source Cache.