Investigation of the client system configuration
You might need to change the configuration of a UNIX or Linux® client system to access new
data sources after you configure the system to access other types of ODBC data sources.
Such a system might already have a driver manager installed and ODBC configuration files
in some directory in the file system. In such a situation, it is helpful to discover as much about
the present configuration as you can before deciding how to configure the Netezza Performance Server ODBC drivers and Netezza Performance Server system data sources.
One technique is to use the env and grep commands to
determine whether one or more environment variables point to ODBC
configuration directories. You
might find the following command useful:
env | grep -i ODBC
The command shows whether any entries in the environment contain
the characters ODBC, such as the
following ones:
ODBC_HOME=/opt/odbc
ODBCINI=/opt/odbc/odbc.ini
These results can help you to determine how the client system is configured. You can then look in the referenced directories for ODBC configuration files and then configure the Netezza Performance Server ODBC driver to search those same directories for the ODBC configuration files.