English
  • PowerCenter 10.5
  • All Products

Table of Contents

Search

  1. Preface
  2. Part 1: Installation Getting Started
  3. Part 2: Before You Install the Services
  4. Part 3: Run the Services Installer
  5. Part 4: After You Install the Services
  6. Part 5: Informatica Client Installation
  7. Part 6: Uninstallation
  8. Appendix A: Starting and Stopping Informatica Services
  9. Appendix B: Connecting to Databases from UNIX or Linux
  10. Appendix C: Connecting to Databases from Windows
  11. Appendix D: Updating the DynamicSections Parameter of a DB2 Database

Installation for PowerCenter and Data Quality

Installation for PowerCenter and Data Quality

Back Next

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 (testforjdbc).
  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.