Wiki Admin

Db2 for i Requirements - DSS 6 | Data Source Solutions Documentation

Export as HTML Export as PDF Export as DOCX
Edit

Documentation: Db2 for i Requirements - DSS 6 | Data Source Solutions Documentation

Db2 for i Requirements

This section describes the requirements, access privileges, and other features of Data Source Solutions DSS when using Db2 for i for replication.

Supported Platforms

  • Learn about the Db2 for i versions compatible with DSS on our Platform Support Matrix page (6.1.0, 6.1.5, 6.2.0, and 6.2.5).

Supported Capabilities

  • Discover what DSS offers for Db2 for i on our Capabilities for Db2 for i page (6.1.0, 6.1.5, 6.2.0, and 6.2.5).

Data Management

Data Source Solutions provides additional solutions for replicating data from Db2 for i. For more information, see section Db2 for i in Databases.

ODBC Connection

DSS is not installed on the Db2 for i system itself but is instead installed on a Linux or Windows machine, from which it uses ODBC to connect to the Db2 for i system. DSS uses ODBC connection to read and write data to Db2 for i location.

The following are required for DSS to establish an ODBC connection to the Db2 for i system:

  • On Linux:

    • IBM i Access Client Solutions ODBC Driver 64-bit
    • ODBC driver manager UnixODBC

  • On Windows:

    • IBM i Access Client Solutions ODBC Driver

The IBM i Access Client Solutions ODBC Driver is available for download from IBM ESS Website (requires user authentication). Choose product-number '5770-SS1', and then choose package 'IBM i Access - Client Solutions' for your platform. For information about the supported ODBC driver version, refer to the DSS release notes (dss.rel) available in the DSS_HOME directory or the download page.

SSL Connection

<b>Since</b> v6.1.5/9 <b>Since</b> v6.2.0/0

DSS supports SSL connection for Db2 for i on both Linux and Windows.

To enable SSL authentication for a Db2 for i location, select the Use SSL option while creating a location or by editing the existing location's source and target properties (or define the equivalent location property Db2_Use_SSL).

Configuration for Linux

To use SSL with DSS installed on Linux, configure the OpenSSL libraries by creating a symbolic link to the system trust store.

  1. Run the following command to locate your system's trust store: 

    openssl version -d

    This command returns a path, typically /usr/lib/ssl or /etc/ssl.

  2. Append /certs to the path returned by the previous command to locate your system's certificate store.

  3. Create a symbolic link from this directory to /usr/local/ssl/certs by executing the following command:

    sudo ln -s /usr/lib/ssl/certs /usr/local/ssl/certs

For information about the ODBC driver version that supports SSL connection on Linux, refer to the DSS release notes (dss.rel) available in the DSS_HOME directory or the download page.

Firewall

If a Firewall is configured between the DSS capture machine and the IBM i-series, the following default ports need to be opened in order to be able to connect via ODBC from the capture to the IBM i-series:

PC Function Service name i-series Port non-SSL SSL Port
Server mapper as-svrmap 449 449
License Management as-central 8470 9470
RPC/DPC (Remote command) as-rmtcmd 8475 9475
Sign-On Verification as-signon 8476 9476
Database Access as-database 8471 9471

The port numbers mentioned here are the default port numbers. To verify the default port numbers for the services names, use the command wrksrvtble on AS/400 console.

Related Articles