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
Option ===> Scroll ===> CSR
RI Load Filter:
SSID ===> DSN
Location ===> LOCATION
Creator ===> FRSAMP
Table Name ===> ORDER_TABLE
RI Load Scope ===> _ (Enter load option)
1 = Load entire related thread for the creator and table
2 = Load only relationship to or from this creator and table
3 = Load all relationships for this creator
4 = Load all relationships for this subsystem
Note: Option 1 will display the entire related thread.
Options 2-4 will only display relationship changes.
Specify Relationship Information:
File name ===> FRSAMP.RELATION
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.
Option | Description |
|---|---|
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/RDX relationship file that contains the relationship information you want to display or maintain. For more information, see Relationship File.
Related topics