DB2 RI update online options - Documentation for BMC AMI DevX File-AID/RDX 23.01

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

 File-AID/RDX ------- DB2 RI Update Online Options ----------------------- 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.

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.