JDBC Connection Details

Use the following JDBC connection information to connect to a relational database.

When you define a JDBC connection profile, the URL is populated automatically with sample syntax that is appropriate for your database. You must edit the syntax to provide connection information for the database.

DB2 for Linux, UNIX, and Windows

For DB2® for Linux, UNIX, and Windows, you must provide the database host name, port, and database name using the following format:

jdbc:db2://host:port/database

For example:

jdbc:db2://PRODZ:50000/PRODDB

DB2 for i

For DB2 for i, you must provide the database host name and port using the following format:

jdbc:as400:host;prompt=false

For example:

jdbc:as400:ihost;prompt=false

DB2 for z/OS

For DB2 for z/OS®, you must provide the database host name, port, and location (database) name using the following format:

jdbc:db2://host:port/location:
retrieveMessagesFromServerOnGetMessage=true;

For example:

jdbc:db2://PRODZ:1523/PRODDB:
retrieveMessagesFromServerOnGetMessage=true;

Derby (sample database)

For the sample database, you must provide the host name, port, and database directory on the host (management server). The directory is located in the Optim™ installation directory, optim\databases\optim. Use the following format:

jdbc:derby:net://host:port/directory

For example:

jdbc:derby:net://localhost:1527/C:\Program Files\IBM\optim\databases\opt

Informix

For Informix®, you must provide the host name, port, and database name using the following format:

jdbc:informix-sqli://host:port/database:INFORMIXSERVER=server

For example:

jdbc:informix-sqli://PRODIFX:1523/IFX94:INFORMIXSERVER=server

Microsoft SQL Server

For Microsoft SQL Server, you must provide the host name, port, and database name using the following format:

jdbc:microsoft:sqlserver://host:port;databaseName=dbname

For example:

jdbc:microsoft:sqlserver://SQLSRV1:1433/databaseName=SQL2005

Optim Database Relationship Analyzer (Derby)

For the Optim Database Relationship Analyzer database (hosted on a Derby server), you must provide the host name, port, and database directory on the host (Optim Database Relationship Analyzer server). The directory is located in the Optim Database Relationship Analyzer installation directory, optim\databases\optim. Use the following format:

jdbc:derby:net://host:port/directory

For example:

jdbc:derby:net://DRASRV1:49952/C:\Program Files\IBM\DatabaseRelationshipAnalyzer1.1\server\GRDDBV1

Oracle

For Oracle, you must provide the server name, port, and database name using the following format:

jdbc:oracle:thin:@server:port:database

For example:

jdbc:oracle:thin:@PRODORA:1523:ORA101

Sybase

For Sybase, you must provide the server name, port, and database name using the following format:

jdbc:sybase:Tds:server:port:database

For example:

jdbc:sybase:Tds:PRODSYB:5000:syb15

Teradata

For Teradata, you must provide the server name, port, and database name using the following format:

jdbc:sybase:Tds:server:port:database

For example:

jdbc:sybase:Tds:PRODSYB:5000:syb15