Hi, I'm Ask INFA!
What would you like to know?
ASK INFAPreview
Please to access Ask INFA.

Table of Contents

Search

  1. Introduction to ODBC Connector
  2. ODBC connections
  3. Synchronization tasks with ODBC Connector
  4. Mappings and mapping tasks with ODBC Connector
  5. Pushdown optimization (SQL ELT)
  6. Data type reference

ODBC Connector

ODBC Connector

Setting environment variables

Setting environment variables

To use Kerberos authentication to connect to DB2, you need to set the required environment variables on the Secure Agent machine.
Set the following environment variables:
  • setenv KRB5CCNAME <Absolute path and file name of the credentials cache file>
  • setenv KRB5_CONFIG <Absolute path of the Kerberos configuration file>\krb5.conf
  • setenv KRB5CONFIG <Absolute path of the Kerberos configuration file>\krb5.conf
After you set the environmental variables, you need to restart the Secure Agent.
Alternatively, you can add the environment variables when you create an ODBC connection with the subtype as
DB2
.
To add the environment variables when you configure a connection and use Kerberos authentication, you need to add the
KRB5CONFIG
and
KRB5CCNAME
properties in the
Kerberos Connection Properties
field in an ODBC connection.
For example, add the properties in the following format:
KRB5CONFIG=<Absolute path of the Kerberos configuration file>\krb5.conf;KRB5CCNAME=<Absolute path of the credential cache file>/<File name>
Ensure that you separate each key-value pair with a semicolon.

0 COMMENTS

We’d like to hear from you!