RCX: Remote Extract receives -551 on PACKAGE [email protected]                                                                                                                         

book

Article ID: 195650

calendar_today

Updated On:

Products

CA RC Compare for DB2 for z/OS CA Database Management for DB2 for z/OS - Administration Suite CA Endevor SCM Interface for DB2 for z/OS CA Endevor SCM Interface for Remote DB2 for z/OS CA RC/Extract for DB2 for z/OS CA RC/Migrator for DB2 for z/OS CA RC/Merger for DB2 for z/OS CA RC/Query for DB2 for z/OS CA RC/Secure for DB2 for z/OS CA RC/Update for DB2 for z/OS

Issue/Introduction

An RC/EXTRACT is setup on an R20 SSID to extract from a remote R19 SSID.  

The following error occurs on the Target Definition Selection:

----------- RC/Extract Target Definition Selection ---------- 2020-07-17 13:32

COMMAND ===>                                                  SCROLL ===> PAGE

RX221E: No Target Definitions match selection criteria.  HELP for more info. 

 Extract Object ===> USER01.TESTOBM1.EXTOBJ                                  

 Target Definition:                                                           

   Creator      ===> USER01    (Blank or pattern for list)                   

   Name         ===> @TRGDEF1   (Blank or pattern for list)      

 

********************************* TOP OF DATA ******************************
DSNT408I SQLCODE = -551, ERROR:  USER01 DOES NOT HAVE THE PRIVILEGE TO    
         PERFORM OPERATION EXECUTE PACKAGE ON OBJECT [email protected]    
         CDDF                                                              
DSNT418I SQLSTATE   = 42501 SQLSTATE RETURN CODE                           
DSNT415I SQLERRP    = DSNXEAAL SQL PROCEDURE DETECTING ERROR               
DSNT416I SQLERRD    = -210  0  0  -1  0  0 SQL DIAGNOSTIC INFORMATION      
DSNT416I SQLERRD    = X'FFFFFF2E'  X'00000000'  X'00000000'                
         X'FFFFFFFF'  X'00000000'  X'00000000' SQL DIAGNOSTIC              
         INFORMATION    
=============

What authority needs to be granted for remote access in RC/Extract?

 

Environment

Release : 20.0

Component : CA RC/Extract for DB2 for z/OS

Resolution

The following authority is needed:

- Grant execute on the RCX plan under the local and remote SSID's.

- Explicit grant on the package [email protected] in  remote SSID to the user.  

- On the Local and Remote SSID's the user needs:

GRANT SELECT,UPDATE,DELETE,INSERT ON TABLE PTI.PTRCX_SRCDEF_REG  
GRANT SELECT,UPDATE,DELETE,INSERT ON TABLE PTI.PTRCX_TRGDEF_REG  
GRANT SELECT,UPDATE,DELETE,INSERT ON TABLE PTI.PTRCX_MDX_REGISTRY