Remote Extract receives -551 on PACKAGE RCX1xxxx_RCX.RXA@CDDF for RC/Extract
Article ID: 195650
Updated On:
Products
Issue/Introduction
RC/Extract for Db2 for z/OS is setup on a Database Management for Db2 for z/OS r20 SSID to extract from a remote
Database Management for Db2 for z/OS 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 RCX1xxxx_RCX.RXA@-
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?
Resolution
The following authority is needed:
- Grant execute on the RCX plan under the local and remote SSID's.
- Explicit grant on the package RCX11xxxx_RCX.RXA@CDDF 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
Feedback
