IBM Db2 Connection Requirements

When using Syniti Replicate with IBM Db2, you need the following information to set up a connection.

General Requirements

• User and password for the Db2 with appropriate privileges (see below)

• Security Mechanism used on the Db2 server. The value specified in Syniti Replicate must match whatever setting is specified on the Db2 server. The options available are User Only, User and Password, Encrypted Password and Encrypted User and Password. Select the value from the drop-down list in the Security Mechanism field. If the value you choose does not match the value on the Db2 server, you will see the following error when attempting to connect.
  
  
  Note: If you need to change this setting at any time, you may need to delete the connection and recreate it for the changed setting to take effect.

• IP address and port to reach Db2  

• Name of Db2 catalog (Database Server Name)

• Package collection
  The account used to make a connection the first time requires permissions to create a package where some prepared SQL statements (DECLARE CURSOR) will be stored. The package can be created in a collection specified in the configuration parameter ”r;Package Collection.”  The account must have CREATE, BIND and GRANT privileges for objects in the collection. These privileges are needed only for the first connection.  Once the package has been created, for all users of that package the privileges are no longer required. (A package can later be dropped using the DROP PACKAGE SQL statement if needed.)

• Host Code Page (CCSID) for the Db2 catalog: the code of the language used in Db2 (ex. 280 Italian, 037 US English, 1252 ANSI etc.) In most cases, the appropriate choice is 1208 - Unicode UTF-8. However, you should check with your Db2 administrator.