Rational Developer for System z

Configuring a database connection

After installing IBM® DB2 Universal Database™ on your workstation, use the Configuration Assistant to configure connections to DB2® databases.

Open the Configuration Assistant from the start menu by choosing Programs -> IBM DB2 -> Setup Tools -> Configuration Assistant.
  1. Open the Selected menu on the menu bar and select “Add Database Using Wizard.” You will need the following information:
    • TCP/IP host name of the OS/390® or z/OS® system
    • DB2 port number
    • Location name and alias name of the database
    • Remote instance name (DB2 subsystem name)
    Contact your DB2 System administrator if you do not have this information.
  2. Click the “Manually configure a connection to a database” radio button. Click Next.
  3. Click the TCP/IP radio button. Select “Database physically resides on a host or OS/400® system” check box and click the “Connect directly to the server” radio button.
  4. Click Next.
  5. Type the host name, service name, and port number for the OS/390 or z/OS system. Click Next.
  6. Type the location name and alias of the database. Click Next.
  7. Select the "Register this database for ODBC" check box. Click Next.
  8. Select “OS/390 or z/OS” from the drop-down list for the operating system and type the database instance name in the “Remote instance name” field. Click Next.
  9. The system name should automatically appear on the "Specify the system options" page. Click Next.
  10. Select the "Server authentication" radio button. Click Finish. A window opens providing you the option to test your database connection.
  11. To test your connection to the database, select the CLI check box and enter your user ID and password. Click Test Connection. If the connection is successful, “CLI connection tested successfully” will appear in the field under the Results tab. Contact your database system administrator if the connection is unsuccessful.

Terms of use | Feedback

This information center is powered by Eclipse technology. (http://www.eclipse.org)