Verify connectivity to the Database Server:
- Microsoft SQL Server. Use the Windows Programs > Administrative Tools > Data Sources (ODBC) to verify that the proper ODBC driver has been installed and to create and test a data source to your database server.
- Oracle. Use the
tnsping
utility and Net8 or Net9 database alias from a Command Prompt window to make sure that you can connect to the database, using the network connect string that you defined in the previous step.
- DB2 UDB. Use a DB2 Command Window and make sure that you can connect to your database.
- Choose Start > Programs > IBM DB2 > Command Window, and type:
DB2 connect to
database_alias
user
user_ID
using
password
where:
database_alias = A valid database alias on DB2
user_ID = A valid user name on DB2
password = The appropriate password for that user name
If your connection is valid, you should see a message that looks like the following:
Database Connection Information
Database Server = DB2/NT x.x.x
SQL authorization ID = SADMIN
Database alias = DB Alias
If your connection is not valid, verify your configuration.
CAUTION: Be sure to use the Command Window for this procedure and not the Command Line Processor window that appears directly preceding it. The Command Line Processor window looks similar to a Command Window, but it uses slightly different syntax. For this procedure, the commands do not work in a Command Line Processor window; they must be issued in a Command Window.
- To close the connection, type
db2 terminate
.
You can also use the DB2 Command Center GUI tool to do this.