Relationship facilitator
This section describes Option 1, Relationship Facilitator. The Relationship Facilitator enables you to view and manipulate the relationship file to:
- View all relationships defined to File-AID/RDX.
- Load Db2-defined referential integrity (RI) relationships, including non-enforced RI, from the Db2 catalog table, SYSIBM.SYSRELS, into the relationship file.
- Refresh the relationship file when its RI information does not match the Db2 catalog.
- Delete RI and user-defined application relationship information from the relationship file.
- Add application relationship information to the relationship file.
- Define data driven (“conditional”) application relationships.
- Modify existing application relationship information.
- Allocate a new relationship file.
- Refresh RI information using batch
- Print formatted contents of a relationship file.
Relationship file compatibility notes
- Relationship files can be shared between BMC AMI DevX File-AID for Db2 and File-AID/RDX.
- Db2 long name support requires File-AID/RDX Release 4.3, or higher, or BMC AMI DevX File-AID for Db2 Release 4.8.1, or higher. Once a Db2 long name has been added to a Version 2 relationship file, File-AID/RDX updates it to a Version 3 relationship file. Version 3 relationship files are not downward compatible with earlier product releases.
This section provides information about the following topics:
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*