Connecting to Database

Enter the DB2 Connect connection information in the Connection Information frame.

To Connect to a Database

1. Select the Connection type using the drop-down list (see the following figure). The resulting Connection Information fields displayed will depend on your selection (i.e. selecting a Type 2 or Type 4 connector).

2. Specify the applicable connection information (depending on the Connection type) for your database including:

   

   For the Type 2 Connection (shown above):

   • Database - The name of the database instance.

   • User Name - The user name that the Adapter uses to connect to the database.

   • Password - The password used to access the database.

     

   For the Type 4 Connection(shown above):

   • Host Name - The server where DB2 Connect resides.

   • Port - The port number of DB2 Connect.

   • Database - The name of the database instance that the DB2 is running on Windows/Unix. The name of the locator for the DB2 running in z/OS or AS/400.

   • User Name - The user name that the adapter uses to connect to the database.

   • Password - The password used to access the database.

3. Click Next. The Select Database Objects window appears.