IBM Support

How to use Db2 Federation query Netezza through ODBC driver?

Question & Answer


Question

How to use Db2 Federation query Netezza through ODBC driver?

Answer

Before You Begin
 
Enable Federation feature and restart Db2 to make it effective. 
$ db2 update dbm cfg using federated YES
Pre-Configuration on Linux, Unix
 
1. Make sure the required ODBC drivers are installed correctly.
$ ls ~/sqllib/federation/netezza/lib64/libnzodbc.so
 
2. Make sure the data source is accessible to Federation server. 
$ telnet test1.fyre.ibm.com 5480
Trying 9.30.1.11...
Connected to test1.fyre.ibm.com.
Escape character is '^]'.
 
3. Create server, user mapping, nickname, and query the nickname.
$ create server SERVER1 type netezza version '7.1' OPTIONS(host 'test1.fyre.ibm.com', port '5480',dbname 'mtest2',CODEPAGE '1208')

$ create user mapping for user server SERVER1 options(REMOTE_AUTHID 'ADMIN',REMOTE_PASSWORD 'pwd1234')

$ CREATE OR REPLACE NICKNAME nk_netezza FOR server1."ADMIN".alltype_test

$ select count(*) from nk_netezza

1
-----------
          4

  1 record(s) selected.

[{"Type":"SW","Line of Business":{"code":"","label":""},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCAVPX","label":"Federated Server"},"ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)"}]

Document Information

Modified date:
06 May 2022

UID

ibm16442827

Page Feedback