Difference between revisions of "Connecting to DB2"
From PresenceWiki
(No difference)
|
Revision as of 10:57, 4 May 2011
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 |