Database Relationships

If an environment will be accessed by the ConfigLab tools (either as a source or a target), you must define database relationships between the two environments.

• In Oracle, a database link defines a database relationship. A database administrator must add database links in the "target" and "source" databases as described in the sections below. These database links must be added prior to executing the environment registration utility.
• In DB2, a database relationship is not a database object like it is in Oracle, however the same principles apply. A database administrator must ensure that security is configured to allow the database users in both environments to access remote host schemas as described in the sections below.
• In MS SQL Server, a database relationship is defined with the linked servers. A database administrator must add linked server and SQL Server data source (ODBC) for target and source database server prior to executing registration utility.

The DB2 version of the registration utility grants the privileges to individual remote host schema objects, the Oracle registration utility relies on the privileges associated with database links, whereas the MS SQL Server registration utility doesn't grant any privileges, rather uses fully qualified object name.

The topics in this section describe these database relationships.