IBM Support

Configuring the dsenv file for ODBC connections to IBM InfoSphere Classic Federation Server for z/OS for InfoSphere Information Analyzer

Product Documentation


Abstract

If your data sources reside on IBM InfoSphere Classic Federation Server for z/OS, you must enter the information described in this document into the dsenv (environment variables) file to correctly configure the ODBC connection to the data sources.

Content

You must make the following modifications:

  1. Set the library path for the driver. See Configuring the dsenv file for a list of correct names of the environment variable, depending on operating system. For example, for Linux, Solaris, or HP-UX, use the following:

    LD_LIBRARY_PATH

    The path for IBM InfoSphere Classic Federation Server for z/OS Client is /opt/ibm/wsclassic91/cli/lib, so the full statement to use is:

    LD_LIBRARY_PATH=/opt/ibm/wsclassic91/cli/lib

    Note: The library path statement must always be the first entry in the dsenv file.
  2. Add the CAC_CONFIG parameter that includes the path (/opt/ibm/wsclassic91/cli/lib/cac.ini) of the cac.ini file. For example:

    CAC_CONFIG=/opt/ibm/wsclassic91/cli/lib/cac.ini
    export CAC_CONFIG

    Note: The cac.ini file must also be edited for your specific z/OS configuration. For more information see Configuring the ODBC driver in Related Information.

The following figure shows an example of the partial contents of a modified dsenv file. The changed parameters are indicated in bold.

[{"Product":{"code":"SSZJLG","label":"InfoSphere Information Analyzer"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Not Applicable","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.1.2.0;9.1.0.1;9.1;8.7.0.2;8.7.0.1;8.7;8.5.0.3;8.5.0.2;8.5.0.1;8.5;8.1.2.5;8.1.2.4;8.1.2.3;8.1.2.2;8.1.2.1;8.1.2;8.1.1.3;8.1.1.2;8.1.1.1;8.1.1;8.1.0.2;8.1.0.1;8.1;11.3","Edition":"All Editions","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
17 June 2018

UID

swg27038780