Connecting to DB2

From PresenceWiki
Revision as of 10:57, 4 May 2011 by Mattpryor (Talk | contribs)

(diff) ←Older revision | view current revision (diff) | Newer revision→ (diff)
Jump to: navigation, search
Database Connectivity > Connecting to DB2

These instructions are for connecting to IBM DB2 server.

Prerequisites

You must have access to the DB2 JDBC driver, which is bundled in a file called db2jcc.jar. You can locate this under your DB2 installation, typically located at:

[INSTALL_ROOT]\IBM\SQLLIB\java

This file must be imported into the Presence Jar Manager.

Connection Parameters

The Driver class should be as follows: 

com.ibm.db2.jcc.DB2Driver

And the following connection URL should be used: 

jdbc:db2://<hostname>[<:port>]/[DATABASE_NAME]

Typically the port will be 50000 on Windows systems.

Username and Password

DB2 uses system accounts, so the username may need to be fully qualified with the domain, e.g mydomain\user.

http://www.international-presence.com/wikidocs/images/db2_connection.png

Database Connectivity > Connecting to DB2
Retrieved from "https://www.international-presence.com/wikidocs/index.php?title=Connecting_to_DB2&oldid=5130"