DB2 RI Update Online Options
The following figure is displayed when you select Load RI (option 5 on the DB2 Relationship Facilitator menu) or enter the L line command for a specified Db2 object in the DB2 Object List.
DB2 RI Update Online Options Screen
This screen provides different options, or filters, on how you want to select RI relationships to be loaded into the relationship file. The RI Load Filter and Relationship file information is prefilled with your selections of the previous screen.
RI Load Filter
The RI Load Filter information is prefilled with your selections on the previous screen and cannot be changed on this screen.
SSID
Specifies the Db2 subsystem ID of the Db2 subsystem on which the table resides for which you want to view relationship information.
Location
Specifies the Db2 remote location ID of the Db2 subsystem on which the table resides for which you want to view relationship information.
Creator
Specifies the authorization ID of the owner of the table for which you want to view relationship information.
Table Name
Specifies the name of the Db2 object (table or view) for which you want to see relationship information.
RI Load Scope
The RI Load Scope allows you to enter one of the RI Load Scope options:
1 | Load the entire related thread for the above specified creator and table, including associated relationships. The RI Relationship Detail Screen (RI Relationship Detail Screen RI Load Option 1) will then list the qualifying RI relationships, including those already loaded into the relationship file. |
2 | Load only relationship to or from this creator and table. This option represents the narrowest filter. The RI Relationship Detail Screen (RI Relationship Detail Screen RI Load Option 2) will then list the qualifying RI relationships that need to be added to or updated in the relationship file. See also No Updates to Process. |
3 | Load all relationships for this creator. The RI-Relationship-Detail-Screen (RI Relationship Detail Screen RI Load Option 3) will then list all qualifying RI relationships for the specified creator ID that need to be added to or updated in the relationship file. See also No Updates to Process. |
4 | Load all relationships for this subsystem. The RI-Relationship-Detail-Screen (RI Relationship Detail Screen RI Load Option 4) will then list all qualifying RI relationships for the specified Db2 subsystem that need to be added to or updated in the relationship file. See also No Updates to Process. |
No Updates to Process
The message ‘No Updates to Process’ indicates that for the selected RI load option the relationship file already contains the up-to-date relationships based on the timestamps in the Relationship file matching to the Db2 catalog.
Specify Relationship File Area
File Name
Specify the name of the File-AID relationship file that contains the relationship information you want to display or maintain.
Related topics