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.
- 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.
- Click the “Manually configure a connection to a database”
radio button. Click Next.
- 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.
- Click Next.
- Type the host name, service name, and port number for the OS/390 or z/OS system. Click Next.
- Type the location name and alias of the database. Click Next.
- Select the "Register this database for ODBC" check box.
Click Next.
- 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.
- The system name should automatically appear on the "Specify
the system options" page. Click Next.
- Select the "Server authentication" radio button. Click Finish. A window opens providing you the option to test your database
connection.
- 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.