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.
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
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
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;
jdbc:db2://PRODZ:1523/PRODDB: retrieveMessagesFromServerOnGetMessage=true;
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
jdbc:derby:net://localhost:1527/C:\Program Files\IBM\optim\databases\opt
For Informix®, you must provide the host name, port, and database name using the following format:
jdbc:informix-sqli://host:port/database:INFORMIXSERVER=server
jdbc:informix-sqli://PRODIFX:1523/IFX94:INFORMIXSERVER=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
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
For Oracle, you must provide the server name, port, and database name using the following format:
jdbc:oracle:thin:@server:port:database
jdbc:oracle:thin:@PRODORA:1523:ORA101
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
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