Specifying advanced relationship settings

For each relationship definition you create, Relationship Designer Express maintains advanced settings that affect the storage and processing of the relationship instance data.

Note:
If you change any database-related setting, such as a login account name, password, or a table name after creating the relationship table schemas, you must re-create the relationship table schemas using System Manager for your changes to take effect.

To view or change the settings, select Advanced Settings from the Edit menu. In the Advanced Settings dialog, the settings that appear on the right side differ depending on which of the following items you have selected on the left:

Advanced settings for relationship definitions

To view or change the settings for a relationship definition, select the relationship name. The following illustration shows an example of the advanced settings at this level:

Figure 96. Advanced settings for a relationship definition

Table 67 summarizes the settings available for relationship definitions. Default values for the DBMS settings come from the Global Default Settings dialog box described in "Global default settings".

Table 67. Summary of advanced settings for relationship definitions

Setting Description
Relationship type

Identity When this option is enabled, the relationship is an identity relationship. For more information, see "Defining identity relationships".

Static When this option is enabled, the relationship is a static relationship. For more information, see "Defining lookup relationships".

Cached When the Static field is enabled, this field is enabled. Check this field to have the relationship tables cached in memory. For more information, see "Optimizing a relationship".
Version This field is read-only. Versions for relationship definitions are not supported in this release.
DBMS Settings

URL The JDBC path where the relationship tables for this relationship definition are located. The default location for all relationship tables is specified in Global Default Settings (see "Global default settings").

Login The user name for logging in to the relationship database.

Password The password for logging in to the relationship database.

Type The relationship database type, such as SQL Server or DB2.
Note:
If you specify a database for the relationship tables that is different from the InterChange Server Express's repository database, you might need to increase the setting for the maximum number of connection pools that the server can create. The server configuration parameter that specifies the number of connection pools is MAX_CONNECTION_POOLS. The default value is 10.

Advanced settings for participant definitions

To view or change the settings for participant definitions, select the participant definition name. The following illustration shows an example of the advanced settings at this level:

Figure 97. Advanced settings for a participant definition

Table 68 summarizes the settings available for participant definitions.

Table 68. Summary of advanced settings for participant definitions

Setting Description
Table name Name of the relationship table in the relationship database containing the relationship data for this participant instance.

Rule: If your relationship database is a DB2 database, you must use up to a maximum of 18 characters in the relationship table names. Although table names do not have a limit in DB2, index names do. Because Relationship Designer Express generates index names for the relationship tables based on their table names, relationship table names for a DB2 database must be 18 characters or less.

Stored procedure name Name of the stored procedure that maintains the relationship table.
IBM WBI managed

If checked, prevents relationship tables from being created for this participant. Check this setting only when:

  • The business object associated with this participant definition is a generic business object.
  • There is only one attribute associated with the participant and it is a key attribute.

Advanced settings for attributes

To view or change the advanced settings for an attribute, select the attribute. The following illustration shows an example of the advanced settings:

Figure 98. Advanced settings for attributes

For attributes, the only setting available is the attribute column name. The column name is the name of the column in the relationship table that contains the values for the selected attribute. It is typically the same as the attribute name. You might want to change the column name if you are using tables you created instead of the default tables that the Relationship Designer Express creates.

Global default settings

When you save a new relationship definition and create the relationship table schemas, Relationship Designer Express must know the location of the database for the relationship tables, the type of database, and how to access the database with a valid user name and password. Relationship Designer Express maintains default values for these settings, which it uses for all new relationship definitions you create. Once a relationship definition is created, these settings are stored with the relationship definition, and you can change the settings for each relationship definition individually.

By default, the database name and access information is the same one used by the InterChange Server Express repository. If you want to store your relationship tables in another location, you can modify the global settings.

To view or change the global default settings, perform the following steps:

  1. In Relationship Designer Express, select Advanced Settings from the Edit menu.

    Result: The Advanced Settings dialog box appears.

  2. Click the Global defaults button.

    Result: The Global Default Settings dialog box appears.

    Figure 99. Global Default Settings dialog

    Table 69 describes the global default settings for relationships.

    Table 69. Relationship global default settings

    Setting Description
    URL The JDBC path where the relationship database is located. The default is the InterChange Server Express's repository database.
    Login The user name for logging in to the relationship database.
    Password The password for logging in to the relationship database.
    Type The relationship database type, such as SQL Server or DB2.
    Note:
    If you specify a database for the relationship tables that is different from the InterChange Server Express's repository database, you might need to increase the setting for the maximum number of connection pools that the server can create. The server configuration parameter that specifies the number of connection pools is MAX_CONNECTION_POOLS. The default value is 10.
  3. When you are finished viewing or making changes, click OK to save or Cancel to exit without saving.
Note:
Changes that you make to the global default settings apply only to new relationship definitions. They do not affect existing relationships. If you want to change the settings for an existing relationship, see "Specifying advanced relationship settings".

Copyright IBM Corp. 2003