CA Datacom/AD 15.x and CA 7 - RC 15(139)

Products

• CA Datacom - AD
• CA Workload Automation CA 7 Edition

Issue/Introduction

Running CA Datacom/AD 15.1 Multi-User . 

CA 7 fails due to security error : 

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

   PRODALT.DB00002.ATZ CL([email protected] )                               

   INSUFFICIENT ACCESS AUTHORITY                                  

   FROM PRODALT.DB00002.* (G)                                      

   ACCESS INTENT(READ   )  ACCESS ALLOWED(NONE   )                

 

SQL INITIALIZATION:  MUF IS SECURED                                            

DBSRPPR: Initializing Source Cache                                              

-- DATA BASE SQL ERROR SUMMARY  1/23/2021 20:44:32  --                         

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: 12376                                    

 

 

Cause

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

Environment

Release : 15.1 and 15.0 

Component : CA Datacom/AD

Resolution

Per CA 7 R&D there are only 3 SQL programs that could benefit from the SQL Source Cache .

Disable the SQL Source Cache in the MUF

by adding following cards in the MUF startup member AXDATIN1 :

SQL_SOURCE_CACHE_SIZE   0

SQL_SOURCE_CACHE_STMTS 0

Additional Information

SQL Source Cache