Configuring the Streams database adapter for DB2
This procedure is necessary only if you plan to use a DB2 database.
Procedure
-
On the machine where the Streams server is installed, edit the Streamsadmin user's
/home/streamsadmin/.bashrc
file to add the following environment variable commands.Table 1. Environment variables for DB2 on Streams Environment variable Example value Variables for compiling Streams adapters with DB2 STREAMS_ADAPTERS_ODBC_DB2 True STREAMS_ADAPTERS_ODBC_INCPATH /opt/ibm/db2/V9.7/include STREAMS_ADAPTERS_ODBC_LIBPATH /opt/ibm/db2/V9.7/lib64 Variable for running Streams adapters with DB2 DB2INSTANCE myDB2InstanceName -
To test your configuration, run the following command as the streamsadmin user.
Use the DB2 instance name, user name, and password appropriate for your environment.
isql DB2_instance_name user_name password
If the test fails, check your execution of the preceding steps. Remember that names are case-sensitive.