Before you can define an ODBC Datasource, you must first configure the database connections to the DB2 Client.
This can be done with:
The Configuration Assistant gives you the ability to Export and Import database connection definitions.
If you do not have the Configuration Assistant, you can do this with commands db2cfexp and db2cfimp.
To run these commands you need to start the DB2 Command-Line Processor (CLP).
You do this by running the following command in Windows
db2cmd
The first step is to define a Node (which is a DB2 server). This is done with a command such as the following:
db2 catalog tcpip node DB2SERV1 remote SERVER1 server 50000
where:
You may need to contact your Database Administrators to find out the values for Hostname and TCP/IP Port.
You will get the following response:
DB20000I The CATALOG TCPIP NODE command completed successfully.
DB21056W Directory changes may not be effective until the directory cache is refreshed.
The above response is normal.
You can check that the Node has been defined with:
db2 list node directory
This won't tell you whether it is correct or not! A better way is to "attach" to the node. This is done with:
db2 attach to DB2SERV1
If this succeeds, or you get an authentication failure, then your definition is correct.
If, instead, you get an error such as:
SQL1336N The remote host "SERVER1" was not found. SQLSTATE=08001
then this means that either:
Once you have defined a Node, you can define the database. The most basic form of this command is:
db2 catalog database CUSTDB at node DB2SERV1
where:
Another example:
db2 catalog database CUSTDB as CUSTDEV at node DB2SERV1 authentication client
In this:
You can check that the database has been defined successfully with:
db2 list database directory
Alternatively you can see whether you can connect to the database with either:
db2 connect to CUSTDEV
or
db2 connect to CUSTDEV using userid
(you will be prompted for the password)
The DB2 CLP allows you to create an ODBC Datasource. This saves the need for having to do this using AQT or the Datasource Administrator.
The command for this is:
db2 catalog odbc datasource CUSTDEV
where CUSTDEV is the name of yor database alias.