Configuring DSN using IBM® Db2 Client in IBM SPSS Modeler

If required, to configure a data source name (DSN) using Db2® Client for Db2 in SPSS® Modeler, complete the following steps:

1. If not already installed, install Db2 Client on the operating system where Modeler Server is installed.
2. Using the db2 catalog command, catalog the database and add a new data source to the db2cli.ini file in Db2 Client. Be sure to point to the defined database alias.
3. Configure data access; detailed steps are available in the Modeler documentation.

   For more information, see Data Access.

4. Create a new ODBC data source in odbc.ini by referencing the database alias defined in step 2.
5. For Linux or UNIX users:
   1. Ensure that the driver library libdb2o.so is used (instead of libdb2.so), and make sure 'DriverUnicodeType=1' is defined for the new data source.
   2. In the IBM SPSS Data Access Pack installation, ensure that the library path of Db2 Client is added to odbc.sh.
   3. Ensure that Modeler Server uses an ODBC Driver wrapper library with UTF-16 encoding (this is called 'libspssodbc_datadirect_utf16.so').
6. Make sure that the user who connects to Db2 has the necessary privileges to run the following query:

   SELECT ACCELERATORNAME FROM SYSACCEL.SYSACCELERATORS