How to generate a RC/Query report that includes information from a Remote Db2 Catalog

Products

• RC/Query for DB2 for z/OS

Issue/Introduction

How to generate a RC/Query for Db2 for z/OS (RCQ) report that included information from a remote Db2 Catalog.

Resolution

Enter the remote location name in the LOCATION field on the RC/Query main menu and enter the local DB2 ssid in the DB2 ssid field.

Db2 ssid is the local subsystem and the LOCATION is set to the remote location. If you are unsure of location names, browse the SYSIBM.LOCATIONS
table and find the row corresponding to the remote subsystem. Use the LOCATION column from SYSIBM.LOCATIONS in the LOCATION field on the RC/Query Main Menu.

The following must be done for this to work:

1. DDF must be set up between the local and remote Db2 subsystems.

2. The CDBAPARM member SETUPxx must be customized with the appropriate LOCATION and LOCSSID parameters within the corresponding local subsystem's parameters.
In this example the SETUPxx member would look like the following:
                 ...
           SSID(ssid)
           LOCATION(LOCAL)
           LOCSSID(ssid)
           LOCATION(remote location)
           LOCSSID(remote ssid)
                 ...
                 ....

3. Once the remote location has been specified, navigate to RC/Query, or any other product, and interact with the product to produce the report you need. 
The information will be derived from the remote location identified by the remote location.