DB2 Client Configuration on Windows

To configure a DB2^® client on Windows™ platforms, use the Client Configuration Assistant. This tool is available only under Microsoft™ Windows. Under UNIX™, you have to use the command line as described in the previous chapter.

1. Source:
   • Select “Manually configure a connection to a database”.
2. Protocol:
   • Select “TCP/IP”.
   • Check “The database physically resides on a host or AS/400^® System”.
3. TCP/IP:
   • Host Name: AS/400 system name.
   • Port Number: Port where DDM/DRDA server is listening (default: 446).
4. Database:
   • Database name: name defined in the relational database directory entries (with WRKRDBDIRE).
5. ODBC:
   • You can register the database as an ODBC data source. Not needed for DRDA^® connection used by ODI.
6. Node Options:
   • Optional, but needed to access the database via the control center.
   • System name: AS/400 system name.
   • Instance name: not used for a connection to AS400 (because only one instance is running on an AS/400).
   • Operating System: OS/400^®.
7. Security Options:
   • Optional.
8. Host or AS400 Options:
   • Optional.