Sybase - connect_cdc_mimix_share

The maximum number of unique tables that may be replicated in a single transaction is 51.
The maximum number of unique requests that may participate in a single transaction is 51.

The default character set for a Sybase installation on the HP11 OS platform is set to hp-roman8. Please refer to the jConnect for JDBC programmer's Reference Manual for more information on unsupported character sets.

To work around this problem, do one of the following:

Change the character set to a jConnect supported character set
Modify the Sybase.properties file:
1. Extract the .properties file from the omni.jar file. From a UNIX command prompt use the following command: jar xvf omni.jar omnienterprise/gdbc/Sybase.properties
  This extracts the sybase.properties file and places it in the omnienterprise/gdbc directory.
2. Locate the following line in the file (this is documented in the file’s comments):
```
url=jdbc:sybase:Tds:%HOST:%PORT/%SERVER?JCONNECT_VERSION=6& FAKE_METADATA=true
```
3. Add the following to the line:
```
 &CHARSET_CONVERTER_CLASS=com.sybase.jdbc2.utils.TruncationConverter
```
4. Save and exit.
  Once the Sybase.properties file is extracted and modified, copy it to each kernel directory.
After you remove the metabase from Sybase, you must manually:
1. Specify sp_dropdevice <data device name: specified during metabase installation, by default it is omnirep_data>
2. Specify sp_dropdevice <log device name: specified during metabase installation, by default it is omnirep_log>
3. Remove the specified files again, during the metabase installation. By default they are
  - /data/omnirep_data.dat
  - /data/omnirep_log.dat

Note: These files are located in the Sybase installation directory.

Sybase - connect_cdc_mimix_share - Latest

Connect CDC Release Notes