Db2 for Linux, Unix and Windows Requirements - DSS 6 | Data Source Solutions Documentation
Documentation: Db2 for Linux, Unix and Windows Requirements - DSS 6 | Data Source Solutions Documentation
Db2 for Linux, Unix and Windows Requirements
This section describes the requirements, access privileges, and other features of Data Source Solutions DSS when using Db2 for Linux, Unix and Windows (LUW) for replication.
Supported Platforms
- Learn about the Db2 for LUW 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 LUW on our Capabilities for Db2 for LUW page (6.1.0, 6.1.5, 6.2.0, and 6.2.5).
Data Management
-
Learn how DSS maps data types between source and target DBMSes or file systems on the Data Type Mapping page. For the list of the supported Db2 for LUW data types and their mapping, see Data Type Mapping for Db2 for LUW.
-
Understand the character encodings DSS supports for Db2 for LUW on the Supported Character Encodings page.
Supported Editions
DSS supports the following editions of Db2 for LUW:
- Server Edition
- Advanced Enterprise Server Edition
- Express-C Edition
For information about compatibility and supported versions of Db2 for LUW with DSS platforms, see Supported Platforms.
Prerequisites
DSS requires Db2 client to be installed on the machine from which DSS connects to Db2. The Db2 client should have an instance to store the data required for the remote connection.
The Db2 client must be installed on a machine with the same "endianness" as the machine running the Db2 server. For instance, AIX and Solaris SPARC are big-endian operating systems, while Linux and Windows are little-endian. Therefore, if the Db2 server is running on AIX, the Db2 client should be installed on either AIX or Solaris SPARC.
-
To set up the Db2 client, use the following commands to catalog the TCP/IP node and the remote database:
db2 CATALOG TCPIP NODE <em>nodename</em> REMOTE <em>remotehost</em> SERVER <em>portnumber</em> db2 CATALOG DATABASE <em>databasename</em> AT NODE <em>nodename</em> -
To test the connection with Db2 server, use the following command:
db2 CONNECT TO <em>databasename</em> USER <em>username</em>
For more information about configuring Db2 client, refer to Db2 documentation.