Question & Answer
Question
How to query PostgreSQL using Db2 Federation 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/odbc/lib/FOpsql*.so
2. Make sure the PostgreSQL server is accessible to Federation server.
$ telnet cistern1.fyre.ibm.com 5432
Trying 9.30.231.167...
Connected to cistern1.fyre.ibm.com.
Escape character is '^]'.
3. Create server, user mapping, nickname and query the nickname.
$ create server SERVER1 type postgresql version 11 OPTIONS(host 'cistern1.fyre.ibm.com', port '5432', dbname 'test_db')
$ create user mapping for user server SERVER1 options (REMOTE_AUTHID 'test_user', REMOTE_PASSWORD 'password1')
$ create nickname test1_nk1 for SERVER1."test1"
$ select count(*) from test1_nk1;
[{"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)"}]
Was this topic helpful?
Document Information
Modified date:
26 April 2021
UID
ibm16431127