Connection Parameters page

You specify required JDBC connection parameters on the Connection parameters page. This page is embedded into multiple wizards in the workbench.
Connection identification
Specify preferences for naming the new connection.
Use default naming convention
Select to specify that the default naming convention is used. If you specify this option, a connection name will be generated based on the name of the database that you are connecting to.
Connection name
Type a name for the connection. Available only if Use default naming convention is not checked.
Select a database manager
Select a database manager and version. Other fields on the page will change based on what you select from this list.
Specify user information
User ID
Type a valid user ID for the database that you specified.
Password
Type the password for the user ID that you specified.
JDBC driver
Specify a JDBC driver to use to connect to the database. If a driver that you want to use is not listed but it is supported by the database manager, select Other and provide the details. JDBC driver limitation: Some drivers require a pass code or license file. Although license information can be set or available in the current environment, it might not be available in other environments, such as on a Web server. The driver will not work if the pass code or license is not available.
Connection URL details
SID
For Oracle connections only: Specify the Oracle database system identifier.
Database location
For Derby connections only: Type the absolute directory path to where Derby data is stored on your file system.
To create a new Derby database, use one of the following options:
  • If you are connecting using the Database Connection page, append ;create=true to the path you specified.
  • If you are using the New Database Connection wizard, select the Create the database if required check box.
Create the database if required
For Derby connections only: Select to create the database in the directory that you specified if it does not exist.
Host
Specify the TCP/IP host name of the database server. This field is not required for some database managers.
Port number
Specify the TCP/IP connection port for the selected database at the host. This field is not required for some database managers.
Use client authentication
For DB2 for Linux, UNIX, and Windows connections only: Select to specify that authentication should occur on the database partition where the application is invoked using operating system security. This option will only work if the DB2 instance that you are connecting to has been configured to support client authentication. With client authentication, the user ID and password specified during a connection or attachment attempt are compared with the valid user ID and password combinations on the client node to determine if the user ID is permitted access to the instance. No further authentication will take place on the database server. This is sometimes called single signon.
JDBC driver class
Specify the name of the main Java™ class that implements the driver that you selected. If you do not select Other in the JDBC driver field, then this field is filled in and is not available for editing. If you select Other in the JDBC driver field, then you must provide the Java package and class name of the JDBC driver that you want to use. Some JDBC drivers are shipped with this product, some are shipped with your database, and some might be provided by a third-party software company. Refer to the documentation for a particular driver to determine which JAR files implement the driver.
Class location
Specify the name of the JAR file containing the JDBC driver class. You can type the fully qualified path or click Browse to find the file. If a driver requires more than one JAR, (including, for example, a license JAR), then you can specify additional JAR files separated with semicolons. The first JAR in the list must include the JDBC driver class. For example:
C:\SQLLIB\java\db2jcc.jar;C:\SQLLIB\java\db2jcc_license_cisuz.jar
Connection URL
Shows the JDBC URL that is supported by the Java driver that you are using. The URL identifies the database so that the driver can establish a connection. The URL format depends on the driver.
Catalog
For Oracle connections only: Select which database catalog you want to load. You can select User, DBA, or All.
Retrieve objects created by this user only
Select to load objects that were created by the user that is specified in the User ID field. Available only when you are creating a connection to a DB2 UDB for z/OS database.
Related tasks
Troubleshooting database connection problems
Related reference
DB2 for iSeries database connections
DB2 for Linux, UNIX, and Windows database connections
DB2 for z/OS and OS/390 database connections
Derby database connections
Informix database connections
Oracle database connections
Microsoft SQL Server database connections
Sybase Adaptive Server Enterprise database connections

Feedback