RCM0225E UNABLE TO CONNECT TO SOURCE SUBSYSTEM ssid SHARE LEVEL OF NONE,SET WAS REQUESTED RC/MERGER TERMINATING

Products

• RC/Migrator for DB2 for z/OS
• RC/Merger for DB2 for z/OS

Issue/Introduction

A RC/Merger for Db2 for z/OS (RMM) job ends with this message during execution:

RCM0225E - UNABLE TO CONNECT TO SOURCE SUBSYSTEM ssid SHARE LEVEL OF NONE,SET. WAS REQUESTED. RC/MERGER TERMINATING.
CONNECT ERROR WAS USER authid IS NOT AUTHORIZED TO EXECUTE PLAN: RCMXxxxx

Where is the user-id (authid in this example) taken from?

Cause

If the user does have the appropriate authorization, the problem might be that the target subsystem is not authorized to access the source subsystem.

Resolution

When using Share Level NONE,SET (specified in Analysis Options) the source objects must be available in Exclusive mode. If not RC/Merger will attempt to connect to source SSID
to stop the object. The CREATEDBY of the source database is used as authid for this command. If this authid does not have sufficient authorization this error occurs.

If the user does have the appropriate authorization, the problem might be that the target subsystem is not authorized to access the source subsystem.