Table of Contents

Search

  1. Installation Overview
  2. Before You Install the Services
  3. Service Installation
  4. After You Install the Services
  5. Client Installation
  6. Uninstallation
  7. Starting and Stopping Informatica Services
  8. Connecting to Databases from Windows
  9. Connecting to Databases from UNIX
  10. Updating the DynamicSections Parameter of a DB2 Database
  11. Installation and Configuration Checklist
  12. Split Domain Configuration for Metadata Manager

Installation and Configuration Guide

Installation and Configuration Guide

Running the Test for JDBC Tool

Running the Test for JDBC Tool

After you install the DataDirect Connect for JDBC Utility, run the Test for JDBC tool to connect to the DB2 database. You must use a system administrator user account with the BINDADD authority to connect to the database.
  1. In the DB2 database, set up a system adminstrator user account with the BINDADD authority.
  2. In the directory where you installed the DataDirect Connect for JDBC Utility, run the Test for JDBC tool.
    On Windows, run testforjdbc.bat. On UNIX, run testforjdbc.sh.
  3. On the Test for JDBC Tool window, click Press Here to Continue.
  4. Click Connection > Connect to DB.
  5. In the Database field, enter the following text:
    jdbc:datadirect:db2://
    HostName
    :
    PortNumber
    ;databaseName=
    DatabaseName
    ;CreateDefaultPackage=TRUE;ReplacePackage=TRUE;DynamicSections=3000
    HostName
    is the name of the machine hosting the DB2 database server.
    PortNumber
    is the port number of the database.
    DatabaseName
    is the name of the DB2 database.
  6. In the User Name and Password fields, enter the system administrator user name and password you use to connect to the DB2 database.
  7. Click Connect, and then close the window.