Prepare Database Connection, System, and Parameter Settings

Learn about configuring database connection, system and parameters settings for Oracle GoldenGate for Db2 for i.

Enabling SSL

SSL connections can be enabled by setting SSL=1 in the DSN configuration file. To know about how to set up an SSL connection with IBM i Access ODBC Driver, see Make SSL ODBC connections from Linux to Db2 for i and ACS ODBC driver for Linux now supports OpenSSL.

It is recommended to use OpenSSL to setup SSL. After SSL is enabled in the DSN configuration file, JAVA connections that have been established using jt400 libraries will also be using SecureAS400 connections as well.

Port Requirements for Db2 for i

Oracle GoldenGate for Db2 for i requires the following ports in normal and SSL modes:

  • Normal Mode: 446, 449, 8470-8476

  • SSL Mode: 448, 449, 9470-9476