The following screen illustrates a typical DB2 JDBC connection:
REPLACE WITH THIS IMAGE: Images/connections/db2jdbcconnection.png
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. |