When you have finished configuring the DB2 Connect
workstation for communications, perform the following steps to test the
connection:
|
| You will need to connect to a remote database to test the connection. |
step 1. | Start the database manager by entering the db2start command on the host database server (if it was not already started). |
step 2. | Enter the following command in the DB2 Connect workstation's Command Center or command line processor to connect to the remote database: connect to database_alias user userid using password
|
The values for userid and password must be valid for the system on which they are authenticated. By default, authentication takes place on the host or AS/400 database server.
If the connection is successful, you will get a message showing the name of the database to which you have connected. You are now able to retrieve data from that database. For example, to retrieve a list of all the table names listed in the system catalog table, enter the following SQL command in the Command Center or command line processor:
"select tabname from syscat.tables"
When you are finished using the database connection, enter the connect
reset command to end the database connection.
 | You are now ready to start using DB2. For more advanced topics, refer to the Administration Guide and the Installation and Configuration Supplement. |
If the connection fails, check the following items:
At the host:
__ 1. | The db2comm registry value includes the value tcpip. |
__ 2. | The services file was updated correctly. |
__ 3. | The service name (svcename) parameter was updated correctly in the database manager configuration file. |
__ 4. | The database was created and cataloged properly. |
__ 5. | The database manager was stopped and started again (enter the db2stop and db2start commands on the server). |
__ 6. | The port number specified is not being used by any other process.
|
|
|
If there are problems starting a protocol's connection managers, a warning message appears and the error messages are logged in the db2diag.log file. For more information on the db2diag.log file, refer to
the Troubleshooting Guide.
|
At the DB2 Connect workstation:
__ 1. | If used, the services and hosts files were updated correctly. |
__ 2. | The node was cataloged with the correct hostname (hostname) or IP address (ip_address). |
__ 3. | The port number must match, or the service name must map to, the port number used on the host. |
__ 4. | The node name (node_name) that was specified in the database directory points to the correct entry in the node directory. |
__ 5. | The database was cataloged properly, using the hosts's database alias (database_alias) that was cataloged when the database was created on the host, as the database name (database_name) on the DB2 Connect workstation.
|
If the connection still fails after you verify these items, refer to the Troubleshooting Guide.