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.