DB2 connection information

The following table provides an example of a DB2® connection created in version 2003.06.00. In this example, the DB2 Alias JANE is same as the name of the database.

The following table provides a view of the same information in versions all versions, after the administrator has added the name of the server in the Server field and the port number in the Connect Options field.

Table 1. DB2 Connection information for HCL Compass
Connection parameter Sample Value
Vendor DB2
Server JACK
Database JANE
User Name cqdb2user
Password ******** (encrypted)
Connect Options PORT=60010

This connection works in all versions because the names in the Database Alias field and Database field are the same for both versions of HCL Compass (JANE). The nondefault port is also specified in the Connect Options field.