Problem Note 45700: "Could not load sasnza" error messages might occur when version 6.0.x of the Netezza ODBC is used with SAS/ACCESS® Interface to Netezza
If you use version 6.0.x of the Netezza ODBC driver with SAS/ACCESS Interface to Netezza, you might receive error messages similar to the following:
Could not load /usr/SAS/SAS_9.1/sasexe/sasnza (61 images loaded)
Error: 0509-022 Cannot load module /usr/SAS/SAS_9.1/sasexe/sasnza.
0509-150 Dependent module libnzsqlodbc3_64bit.so could not be loaded.
0509-022 Cannot load module libnzsqlodbc3_64bit.so.
0509-026 System error: A file or directory in the path name does not exist.
0509-022 Cannot load module /usr/SAS/SAS_9.1/sasexe/sasnza.
0509-150 Dependent module /usr/SAS/SAS_9.1/sasexe/sasnza could not be loaded.
ERROR: The SAS/ACCESS Interface to Netezza cannot be loaded. The SASNZA code appendage
could not be loaded.
Errors such as the following are returned when connecting to the Netezza database:
libname NZ netezza server=netezza_server user=netezza_user password=netezza_password
database=netezza_database;
These errors occur when the symbolic link for the ODBC driver is in the /lib directory. To avoid the error messages, set the LIBPATH environment variable as follows:
export LIBPATH=$ODBCHOME/lib64:$ODBCHOME/lib:$LIBPATH
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to Netezza | 64-bit Enabled AIX | 9.1 TS1M3 SP4 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2012-06-29 15:26:03 |
| Date Created: | 2012-02-16 15:22:52 |
