IBM DB2 driver

Before you create a DirectConnect server:

Install the IBM DB2 client software on the same machine that you are installing the ODBC option.
Configure your IBM DB2 client software with a defined database alias. Verify connectivity using IBM tools.

To create a server using an IBM driver

Start the Create Server wizard by entering:
```
DCWizard.sh
```
When the Welcome Create Server Wizard window appears, click Next. The Create DirectConnect Server Options window appears.
Select the ECDA Option for ODBC option and click Next.

The Server Name and Port Information window appears.
Enter the Server Name for the new DirectConnect server and the Port Number that you want the server to “listen” on. Click Next.

The ECDA - ODBC Driver Manager Options window appears.
Select the unixODBC Driver Manager without a Driver Manager Option and click Next. The Driver Manager Information window appears.
Select the following from the browse files:
- The path to the Sun Solaris IBM ODBC Driver file, for example:
```
/software/IBM/db2_08_01/lib/libdb2o.so
```
  Version 9.1 of the IBM ODBC 64-bit driver has a new name (“libdb2o.so”), as shown in the directory path.
- The DB2 script file that is sourced before DirectConnect is started, for example:
```
/export/home/nedb2i7/sqllib/db2cshrc
```
Click Next. The DirectConnect Service Name window appears.
Enter the ECDA access service name that you want to use for this server and click Next. The ECDA Server Summary and Build window appears.
Verify the ECDA Server information that appears:
- If correct, select Create Server. The Start DirectConnect Server (Optional) window appears.
- If incorrect, click Back to change the information.
Optionally, you can start the DirectConnect server that you created to validate the server configuration. If you exit from this wizard, the DirectConnect server you have started will continue to execute. If you want to skip this step, click Finish.

The service requires additional configuration to connect to the target database. This additional configuration can be added using DirectConnect Manager. For basic connectivity to DB2, start DirectConnect Manager and set ConnectionSpec1 to a DB2 alias. The DB2 aliases can be found by executing “list database directory” in the db2 command shell.