How to enable connection pooling for Netezza ODBC on Linux?

Education

Abstract

Parameters needs to be set.

Content

Since UnixODBC 2.0 you can use connection pooling - that feature allows you to reuse a single ODBC connection per Unix process.

You will need to add 'Pooling = Yes' to .odbcinst.ini config file to global ODBC
section to enable pooling on driver manager level and additionaly
specify CPTimeout as non zero value per ODBC driver setting:

[ODBC Drivers]
NetezzaSQL = Installed

Pooling = Yes

[NetezzaSQL]
Driver = /usr/local/nz/lib/libnzodbc.so
Setup = /usr/local/nz/lib/libnzodbc.so
APILevel = 1
ConnectFunctions = YYN
Description = Netezza ODBC driver
DriverODBCVer = 03.51
DebugLogging = false
LogPath = /tmp
UnicodeTranslationOption = utf8
CharacterTranslationOption = all
PreFetch = 256
Socket = 819

CPTimeout = 1000

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSUSQ8","label":"IBM Netezza Analytics"},"Component":"ODBC","Platform":[{"code":"PF004","label":"Appliance"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Was this topic helpful?

Document Information

More support for:
IBM Netezza Analytics

Software version:
All Versions

Operating system(s):
Appliance

Document number:
734807

Modified date:
03 June 2022

UID

ibm10734807

IBM Support

Tips