Creating a DB2 Connection Profile

A connection profile contains the connection property information needed to connect to a DB2 database in your enterprise.

Prerequisites
Before creating the connection profile, copy your DB2 JAR files (for example, db2jcc.jar and db2jcc_license_cu.jar) to:

<SUP-Install-Path>\Unwired_Work-Space\Eclipse\sybase_workspace\mobile\eclipse\plugins\com.sybase.uep.com.db2_1.5.2.<plugin version number>\lib

  1. In Enterprise Explorer, right-click Database connections and select New.
  2. Select the DB2 database type for which you are creating the connection profile. For example, DB2 for Linux, UNIX, and Windows. Enter a name and optional description and click Next.
  3. Select the New driver definition icon adjacent to the Drivers field.
  4. From the driver templates choose IBM Data Server Driver for JDBC and SQLJ.
  5. From the Jar list tab click Edit Jar/zip and verify that db2jcc.jar and db2jcc_license_cu.jar files point to <SUP-Install-Path>\Unwired_Work-Space\Eclipse\sybase_workspace\mobile\eclipse\plugins\com.sybase.uep.com.db2_1.5.2.<plugin version number>\lib.
  6. Click Yes (from the Update all Jars to use same path prompt), then OK on the previous screen (Edit driver definition).
  7. Complete the following information.
    Specify DB2 database connection details page
    Field Description
    Database The name of the DB2 database
    Host The host name on which the database resides.
    Port number The port to which you are connecting. For example, 50000.
    Use client authentication Select this option and enter the user name and password in the corresponding fields to provide basic authentication to the database.
    User Name Enter the name for the database login.
    Password Enter the password for the database login, if required.
    Save Password Select the checkbox to save the password.
    Connection URL Read-only details specifying the connection URL.
    Connect when the wizard completes Select this option to connect to the database upon exiting the wizard.
    Connect every time the workbench is started Select this option if you want Unwired WorkSpace to connect automatically to the database (when it is started) and display its contents in Enterprise Explorer.
    Test connection Click Test connection to ping the database and to verify that the connection profile is working.
  8. Click Next to see the summary page, or Finish to create the connection profile.

    The connection profile displays under Database connections in Enterprise Explorer.