-551 on SQL across sub systems in RLX

Products

• RLX SQL

Issue/Introduction

Is it possible to run SQL queries  across sub systems in RLX?

Receiving this error in RLX.

  DSNT408I SQLCODE = -551, ERROR:  XXXXADM DOES NOT HAVE THE PRIVILEGE TO 
            PERFORM OPERATION EXECUTE PACKAGE ON OBJECT RLX200.RLXSQL      
   DSNT418I SQLSTATE   = 42501 SQLSTATE RETURN CODE                        
   DSNT415I SQLERRP    = DSNXEAAL SQL PROCEDURE DETECTING ERROR            
   DSNT416I SQLERRD    = -210  0  0  -1  0  0 SQL DIAGNOSTIC INFORMATION   

Environment

Release : 20.0

Resolution

Yes, it is possible to run RLX across subsystems

 

From the message received

DSNT408I SQLCODE = -551, ERROR:  XXXXADM DOES NOT HAVE THE PRIVILEGE TO 
PERFORM OPERATION EXECUTE PACKAGE ON OBJECT RLX200.RLXSQL      

The message indicates that a GRANT authorization to the RLX collection id (RLX200) for the package is needed, 
since DB2 is showing an error about the authorization to package RLXSQL.