Question & Answer
Question
How to query Microsoft SQL Server 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/FOsqls*.so
2. Make sure the data source is accessible to Federation server.
$ telnet punks1.fyre.ibm.com 2433
Trying 9.30.244.223...
Connected to punks1.fyre.ibm.com.
Escape character is '^]'.
3. Create server, user mapping, nickname, and query the nickname.
$ CREATE SERVER "SERVER1" TYPE MSSQL_ODBC OPTIONS(DBNAME 'mssql2017db',HOST 'test1.ibm.com',PORT '2433')
$ create user mapping for user server server1 options ( REMOTE_AUTHID 'USER2', REMOTE_PASSWORD 'password1')
$ create nickname n1 for "SERVER1"."USER2"."alltype_test"
$ select * from n1
[{"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)"}]
Was this topic helpful?
Document Information
Modified date:
08 March 2022
UID
ibm16450733