Advanced Source Properties Tab

Property

Description

Maximum Connection Pool Size

Specifies how many unused connections to leave open between the current Replicator Service and the selected source. A value of 0 closes all unused connections. Depending on your network traffic conditions and replication needs, you may be able to improve performance by increasing the number of connections, since the overhead of allocating and deallocating a connection is eliminated each time a pooled connection is used.

You can specify a timeout period after which the Replicator Service automatically closes a pooled connection. See the Service Properties Connection Pools tab for more information.

Maximum Number of Connections

Specifies the maximum number of connections that can be made between the Replicator Service and the selected source. The limit applies to the combination of DSN and database user ID designated by the selected source name. It does not affect other sources, although they may be served by the same Db2, Oracle, or SQL Server.

AS/400 Multi Member File Access

This checkbox appears only if the Data Replicator communicates with the selected Db2 for i (AS/400) source using a StarSQL data source. If you enable this option, any subscription that uses this source can be set to replicate to a regular SQL table or to a specific member of a multi-member physical file. If this option is disabled and you use this source to replicate from a multi-member file, only the data from the default member of the file will be replicated.

To perform incremental replication from a multi-member file, you must use SQDR Plus v4 or later and enable the multiMember property in the SQDR Plus configuration (default is enabled).

You must perform a one-time registration procedure on the IBM i Server before attempting to replicate to or from an individual member of a file.

Defaults:

 Database

 Object Schema

These values are used as defaults for source database and object schema when creating a new subscription. Modifying these values do not affect existing subscriptions.

 Allow Incremental Replication

If the source is enabled with SQDR Plus, the Allow Incremental Replication from this Source option is available. If you enable the Allow Incremental Replication option, also specify the name of the Capture Agent schema to use.

 Capture Agent Schema

The Capture Agent Schema names the control tables that are used by a particular instance of the SQDR Plus Capture Agent. If the source has more than one Capture Agent schema defined, select which one you want to use for this instance of the source.

Changing the Capture Agent schema after you save the source properties resets all the groups and subscriptions that use the source for incremental replication operations; a new baseline will be required.

Agent

This is the ODBC connection string that SQDR (tier 3) uses to retrieve changes from the SQDR Plus (tier 2) staging database. This information is obtained from the source (tier 1) system. This is an informational field useful for troubleshooting; in the case of configuration changes, use the Refresh button to obtain the current connection string.  If the source has more than one Capture Agent schema defined, the Refresh button will also refresh the dropdown list of available Capture Agent Schemas.

Notification Address

The drop-down list for Notification Address shows the IP address of all active network connections. Select the IP address, or enter the address or hostname, of the computer that you want to receive a UDP notification when changes are committed to this source. This should be a static IP address. Select Disable if you want to receive changes only with the normal polling cycle. If you disable notifications for a source that is defined in a group that is set to receive notifications, the group property will be toggled to disable receipt of change data notifications.