Skip to Content
Information
Space announcement: BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.

DB2 Relationship Facilitator

The following figure is displayed when you select Option 6, Relationships - Relationship Facilitator, from the File-AID for Db2 Primary Option Menu. The DB2 Relationship Facilitator screen also appears when you enter the DB2 command in the MVS Relationship Facilitator screen.

DB2 Relationship Facilitator

image2021-3-12_10-48-13.png

Use this screen to specify the name of the table or view for which you want to maintain relationships and the File-AID for Db2 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 for Db2 selects option 4, List RDX, and lists all matching entries found in the relationship file. File-AID for Db2 issues a message when the relationship file does not contain any entries for the specified Db2 object.

Menu Options

The following File-AID for Db2-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. See Relationship Detail for more 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. See Application-Relationship-Detail for more 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 (see Allocate-Relationship-File) where you can allocate a new relationship file. The File-AID for Db2 relationship file is the repository that stores the RI and AR relationship definitions so you can use the Related Table Browse and Edit function.

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. See Batch-RI-Load.

P - Print

Print Relationships. Enables you to print a formatted report that contains information from the File-AID for Db2 relationship file that you specify. You can also save this report to an existing or new file. 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 for Db2 presents selection lists. These fields don’t apply for the A, Allocate Relationship file, and P, Print Relationship file, menu options.

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.

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 for Db2 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 Wildcard Characters for Relationship Option).

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 Wildcard Characters for Relationship Option).

Notes for Creator and Table fields

Which list File-AID for Db2 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. See DB2 Object List for more information. 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 for Db2 relationship file that contains the relationship information you want to display or maintain. Refer to Relationship-File-Contents for more information.

Primary Commands

The following File-AID for Db2-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.

Related topics

Accessing-and-Exiting-File-AID-for-Db2

Description-of-Primary-Commands


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC Compuware File-AID for Db2 21.01