Using IBM DB2 Driver

Create a server using the IBM DB2 driver.

1. Start the Create Server wizard. Enter:

   DCWizard.sh

2. On the Welcome Create Server Wizard window, click Next.
3. Select ECDA Option for ODBC and click Next.
4. In the Server Name and Port Information window, enter:

   Field	Description
   Server name	Name of new DirectConnect server
   Port number	Listener port number of the server

   Click Next.

5. Select unixODBC Driver Manager without a Driver Manager and click Next.
6. Specify the path to:
   • The Solaris IBM ODBC driver file, for example:

     /software/IBM/db2_08_01/lib/libdb2o.so

     Note: Version 9.1 of the IBM ODBC 64-bit driver is named 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.

7. Enter the ECDA access service name to use for this server and click Next.
8. The ECDA Server Summary and Build window displays the selections you have made. Review the information and click Create Server.
9. (Optional) Start the DirectConnect server that you created to validate the server configuration.
   If you exit from this wizard, the DirectConnect server you have started continues to execute. To skip this step, click Finish.
   Note: The service requires additional configuration to connect to the target database. To add this configuration, use DirectConnect Manager. For basic connectivity to the DB2, start DirectConnect Manager and set ConnectionSpec1 to a DB2 alias by executing “list database directory” in the db2 command shell.