RG008E RC=-12,0006 DB2 SYSTEM ID NAME DB2 IS INVALID

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

Description:

Trying to do a request in RC/Query which accesses a remote system results in the message "DB2 SYSTEM ID NAME DB2 IS INVALID".
The LOCAL subsystem is DSN and the remote subsystem is DB2.

Solution:

The Local and remote subsystems are identified on the main product menu prior to accessing the product.

The default will be the following display which identifies the local subsystem that is active.
In this example, D91A is the active subsystem.

DB2 SSID ==> D91A LOCATION ==> LOCAL

To access the remote subsystem DB2 from the local active subsystem, change the LOCATION to the location name for the remote DB2 subsystem.
This LOCATION for the remote system is defined in the Sysibm.Locations table.

In this example, D91A is the active subsystem and DB2 is the location name associated with the remote subsystem.

DB2 SSID ==> D91A LOCATION ==> DB2