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

Document ID : KB000023767
Last Modified Date : 14/02/2018
Show Technical Document Details

Question:

A RC/Merger job ends with this message during execution:

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

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

Answer:

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 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.