The following screen illustrates a typical DB2 JDBC connection:
Fields | Description |
|---|---|
Connection name | Enter a name for the connection. |
Connection type | Select JDBC from the drop-down list. |
Database type | Select DB2 from the drop-down list. |
Host | Enter the host name or IP address. |
Port | The default port for DB2 is 50000, however this can be changed by the Database Administrator. To determine the port, check the DB2 CLI catalog. Note The DB2 port can be discovered by running LIST NODE DIRECTORY in the DB2 command prompt on the database server. The port number is displayed as the "Service name" value. |
Database | Type the Teradata Aster database name. |
Max simultaneous | Set the maximum number of simultaneous connections 3D will open to the system. |
Manual tree expand | Select the checkbox to manually expand and load the database and host connections tree, instead of automatically drilling down the tree. |
JAR libraries | Select the DB2 jar file from the JDBC-DRIVERS directory. |
User | Enter the username for connecting to the specific database. |
Password | Enter the password for connecting to the specific database. |
Store password in | Select one of the following options if you choose to save or not to save your password:
|
Test connection | Click the button to ensure the entered parameters are correct. |