4-2 20751-12 Rev.5
Netezza ODBC, JDBC and OLE DB Installation and Configuration Guide
ODBC Driver Properties
This section describes the meaning and purpose of each ODBC driver property. Parameters
define the properties of Netezza ODBC drivers, configured either through Windows or a
UNIX/Linux configuration file. Use this information to select appropriate values for each
driver property during the driver configuration process.
ODBC Driver Managers
The ODBC driver manager serves as an intermediary between an application and an ODBC
driver. It provides a single place for an application to invoke most ODBC API functions. In
most DBMS application environments, including the Netezza appliance environment, the
application is linked to the driver manager and is not linked directly to a specific ODBC
driver.
The driver manager is the ODBC component that manages communication between appli-
cations and ODBC drivers. In most cases, ODBC applications issue ODBC API calls to the
driver manager, and the driver manager, in turn, passes those ODBC API function calls to
the appropriate ODBC driver. The ODBC driver then accesses the underlying database man-
agement system software.
Table 4-1: ODBC Driver Properties
Property Setting
DebugLogging This boolean property activates debug logs. By default, logging is dis-
abled. To enable logging, select the property on the Windows dialog,
or for UNIX, specify a boolean such as 1 or true. For more informa-
tion, see Appendix B, “Troubleshooting.”
Log File Path The location of the debug log files. The default is /tmp on UNIX/Linux
systems or c:\ on Windows systems.
Prefetch Count A numeric value that sets the number of rows the driver will fetch at a
time from a Netezza database. The default is 256 rows. To tune your
application, set a value that optimizes network use versus memory
use. Realize that the higher this value, the more memory will be
required to hold these rows.
Socket Buffer Size A numeric value that specifies the size of the communications buffer
in bytes. The range is 1K to 32K. The default is 8192.
Character Transla-
tion Option
The Netezza appliance uses the Latin9 character encoding for char
and varchar types. The character encoding for many Windows systems
is similar, but not identical. If your database includes characters that
use only the basic subset of letters (a-z or A-Z), numbers (0-9), or
punctuation characters, select the Optimize for ASCII character set
option for the driver on Windows, which improves query performance.
If your data includes special characters such as the Euro symbol or
others, de-select the option so that the characters convert correctly.
Unicode Transla-
tion Option
For UNIX/Linux drivers, specifies the unicode encoding value. Valid
values are utf8, utf16, and utf32. The default is utf8.
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comentários a estes Manuais