DB2 relationship facilitator

The following panel is displayed when you select Option 1, Relationships, from the File-AID/RDX Primary Option Menu and your profile specifies Db2 as the default driving object type (see also Default driving object type). The following panel also displayed when you enter the Db2 command in the MVS Relationship Facilitator.

Related topics

Invoking-File-AID-RDX

Relationship-file-contents

File-AID/RDX -------- DB2 Relationship Facilitator -------------------------
Option ===>                                                   Scroll ===> CSR
                                                          SITE Profile: RDXMENU
Primary commands: menu-option, MVS Relationship Facilitator

    1 BROWSE ALL       - Browse all existing Relationships
    2 EDIT AR          - Edit existing Application Relationships
    3 ADD AR           - Add new Application Relationships
    4 LIST RDX         - List DB2 objects from RDX Relationship File
    5 LOAD RI          - Load RI Relationships defined to DB2
    6 LIST DB2         - List DB2 objects from DB2 Catalog
    A ALLOCATE         - Allocate Relationship File
    L BATCH RI LOAD    - Batch Job to Load RI Relationships
    P PRINT            - Print the Relationship File

Specify a Table Name or pattern:
  SSID               ===> *                    (* or pattern for selection list)
  Location           ===> *                    (* or pattern for selection list)
  Creator            ===> *                    (* or pattern for selection list)
  Table Name         ===> *                    (* or pattern for selection list)

Specify Relationship Information:
  File name          ===> FRSAMP.RELATION

Use this screen to specify the name of the table or view for which you want to maintain relationships and the File-AID/RDX relationship file that contains the information about those relationships. Then enter one of the menu options to specify the action you want to perform. When pressing Enter without selecting an option, File-AID/RDX selects option 4, List RDX, and lists all matching entries found in the relationship file. File-AID/RDX issues a message when the relationship file does not contain any entries for the specified Db2 object.

Menu Options

The following File-AID/RDX-specific menu options are valid on this screen:

1 - Browse All

Browse Relationship File. Select Option 1 to search the relationship file for previously stored relationships that match the specified object.

Option 1, Browse All, enables you to view a list of all objects defined to your relationship file that are “related” to the object (MVS file or Db2 table or view) you specify. You can then select a single relationship about which you want to view detailed information from the list. For more information, see Relationship Detail.

When browsing existing relationships you can also modify, delete, and add new application relationships.

2 - Edit AR

Edit Application Relationships. Select Option 2 to search the relationship file for previously stored application relationships.

Option 2, Edit AR, enables you to view a list of all objects defined to your relationship file that are “related” to the object (MVS file or Db2 table or view) you specify. From the list, you can then select a single relationship about which you want to view detailed information. For more information, see Application Relationship Detail.

3 - Add AR

Add Application Relationship. Select Option 3 to add an application relationship. Displays the Add Relationships — Specify Object Types so you can specify the parent and dependent object types for the new relationship. See Add Relationships — Specify Object Types.

4 - List RDX

(Default) List all Db2 objects from the Relationship File. Select Option 4 to search the relationship file for matching Db2 objects.

Option 4, List RDX, enables you to view a list of all Db2 objects defined to your relationship file that “match” the object specification. See Db2 Object List.

5 - Load RI

Select Option 5 to maintain the relationship file for Db2 RI information. Option 5 enables you to load or refresh Db2-defined RI information in your relationship file using information from the Db2 catalog. In addition, you can delete RI relationship data from the relationship file. See Db2 RI Update Online Options.

6 - List DB2

Search the Db2 Catalog and Relationship File. Select Option 6 to find objects in the Db2 catalog that match your specified pattern.

Option 6 enables you to view a list of all objects in the Db2 catalog that match the specified pattern. It also checks the relationship file and informs you whether it includes an entry for the object. See Db2 Object List.

A - Allocate

Displays the Allocate Relationship File panel where you can allocate a new relationship file. The File-AID/RDX relationship file is the repository that stores the RI and AR relationship definitions so you can extract related data. See Allocate Relationship File.

L- Batch RI Load

Displays the Batch RI Load screen where you can submit batch jobs to update a relationship file with the current RI information for one or more Db2 subsystems.

P - Print

Print Relationships. Displays the Formatted Relationship Report where you can submit a batch job to print a formatted report that contains information from the File-AID/RDX relationship file that you specify. You can also save this report to an existing or new file. For more information, see Print Relationship File.

Specify a Table Name or Pattern Area

Use the fields in this area to specify the Db2 object for which you want to retrieve relationship information. When specifying patterns in the fields, File-AID/RDX presents selection lists. These fields don’t apply for the P, Print Relationship file, menu option.

SSID

Specify the Db2 subsystem ID of the Db2 subsystem on which the table resides for which you want to view relationship information.

Location

Specify the Db2 remote location ID of the Db2 subsystem on which the table resides for which you want to view relationship information. Leave blank if your site does not use DDF.

Important

Special Notes for SSID and Location fields

When you enter a pattern and select option 1, 2, or 4 at the same time File-AID/RDX will search the relationship file for matching entries.
For option 3, 5, or 6 you must select the one subsystem ID in the SSID field that is valid for the remote location ID you specify/select in the Location field.

Creator

Specify the authorization ID of the owner of the table for which you want to view relationship information. To view a list of tables, specify a pattern. Valid pattern characters are %, _, and * (see Pattern Characters).

Table Name

Specify the name of the Db2 object (table or view) for which you want to see relationship information. To view a list of tables, specify a pattern. Valid pattern characters are %, _, and * (see Pattern Characters).

Important

Notes for Creator and Table fields

Which list File-AID/RDX will display depends on the option you select:

1 Table List in Relationship File

2 Table List in Relationship File

3 Table List - SYSIBM.SYSTABLES

4 DB2 Object List

5 Table List - SYSIBM.SYSTABLES

6 Db2 Object List

If you specify a pattern and press the Enter key without selecting an option, the DB2 Object List screen shown in Db2 Object List is displayed. In the other table lists, select the desired Creator. Table combination with the S line command.

Specify Relationship File Area

File Name

Specify the name of the File-AID/RDX relationship file that contains the relationship information you want to display or maintain. For more information about the relationship file, see Relationship File.

Primary Commands

The following File-AID/RDX-specific primary commands are valid on this screen:

MVS

Switch to the MVS Relationship Facilitator panel to specify an MVS driving object for your Relationship task.