-
Title
Config file limitiations -
Description
What are the config file limitations in terms length of each entry and total number of tables?
-
Cause
Activation may fail if the config file has too many tables, too many routes, too many columns, or each entry is too long.
-
Resolution
Shareplex 7.5 and higher:
====================
Maximum number of tables per config file: unlimited
Maximum number of unique replication routes: unlimited
Maximum characters per single config entry: 140,000 bytes
Maximum columns per single entry (the key! list or vertical partitioning): unlimited as long as total number of bytes per line is fewer than 140,000Prior to Shareplex 7.5
=================
Maximum number of tables per config file: 65,535
Maximum number of unique replication routes: 65,536
Maximum characters per single config entry: 140,000 bytes
Maximum columns per single entry (the key! list or vertical partitioning): unlimited as long as total number of bytes per line is fewer than 140,000NOTE: Maximum characters per single config entry is in keeping with what Oracle supports. An object name can be 30 bytes in length. If an object name is defined with a multi-byte character set, the maximum number of characters may be less than 30.The following applies to the routing section of the config file:A. If not using named queues:
==========================
Source host name must be 25 characterless or fewer
B. If using named queues:
===================
the part after the : must be 25 characters or fewer as in below
user.table1 user.table1 targethost:this_part_must_be_25_or_fewer@ o.SOURCE_SID-o.TARGET_SIDAND+ length of hostname
+ maximum length of Shareplex process name (sp_opst_mt is the longest)
+ length of source datasource
+ length of target datasource
+ 6 overhead characters.
------------------------
= must add up to fewer than 63 charactersC. Target hostname limitations:
===============================
The target hostname must consist of 25 or fewer alphanumeric characters. (- and _ are not supported and can cause activation problem or an extra import process on the target without a PID).If the target hostname is greater than 25 character or contains non alphanumeric characters, create an alias in /etc/hosts, DNS or NIS that adheres to the above requrements. -
Defect ID
ST50678 -
Additional Information
The routing number is defined as a 16-bit quantity, which restricts the number of unique replication routes to 65536.
Multiple sp_copsmay be used as a workaround for the maximum number of tables/routes limitation.