I could not retrieve a data from a DB2 database.

Stanisa

I am using OBIEE 11.1.1.1.9 on Oracle Linux. I have to connect in connection pool to DB2 database.

How can I do it?

[Deleted User]

Physical Layer. Right-click. "New database" -> Database type -> Choose your DB2.

Stanisa

Tried. No result. Have to setup odbc.ini file on OS.

[Deleted User]

Of course, otherwise OBI can't use the connectivity But that's outside OBI and a DB2 problem: https://www.ibm.com/docs/en/db2/11.1?topic=environment-setting-up-odbc-linux-unix

Stanisa

I succesfuly set up IBM DB2 connection on Linux and I can connect to DB2 from command line interface on Linux.

But still can't connect through OBIEE Admin tool. I have not set up ibm db2 odbc in Windows.

Gianni Ceresa

What kind of connection isn't working in the Admin tool?

You mean your RPD, once deployed on the OBIEE server, doesn't return data when you run analysis?

Or you can't view data via the Admin tool when you click on a physical table?

I don't remember much about 11.1.1.9 (time for an upgrade maybe?), but the Admin tool for many type of sources doesn't go via the OBIEE server but tries to connect directly instead. If this is the case (again, I don't remember how it was 7 years ago), you will need the same ODBC connection (name of it) locally where you are running the Admin tool.

Stanisa

Yes, it is the case. I need db2 odbc driver on windows workstation from which I using Admin Tool. Also I need ibm odbc driver on obiee linux server side.

Stanisa

Very interesting. I set up odbc ibm driver in Windows machine. After setting up db2 connection in the admin tool I get error:

nQSError: 36001 Unable to load the dll db2cli.dll

I checked the connection from cmd:

db2cli validate -dsn TRIGLAV -connect -user proba -passwd adminxp

C:\WINDOWS\system32>db2cli validate -dsn TRIGLAV-connect -user proba -passwd adminxp

===============================================================================

Client information for the current copy (copy name: C_clidriver):

===============================================================================

Client Package Type    : IBM Data Server Driver For ODBC and CLI

Client Version (level/bit): DB2 v11.5.6000.1809 (s2106111000/64-bit)

Client Platform      : NT 64BIT

Install/Instance Path   : C:\clidriver

Common App Data Path   : C:\ProgramData\IBM\DB2\C_clidriver

DB2DSDRIVER_CFG_PATH value: <not-set>

db2dsdriver.cfg Path *  : C:\clidriver\cfg\db2dsdriver.cfg

User db2dsdriver.cfg Path : C:\Users\savdalovic\db2dsdriver.cfg

DB2CLIINIPATH value    : <not-set>

db2cli.ini Path      : <Common App Data Path>\cfg\db2cli.ini

db2diag.log Path     : <Common App Data Path>\db2diag.log

* - Warning: db2dsdriver.cfg configuration file is found at the location which

will be deprecated soon. It is recommended to move this file to the location:

"C:\ProgramData\IBM\DB2\C_clidriver\cfg\".

===============================================================================

List of all IBM Data Server client packages on the current workstation:

===============================================================================

Copyname    Version Package Language Installed-Location

-------------------------------------------------------------------------------

C_clidriver[C] 11.5.0600 CLI   EN    C:\clidriver

-------------------------------------------------------------------------------

 CLI: IBM Data Server Driver for ODBC and CLI

-------------------------------------------------------------------------------

===============================================================================

db2dsdriver.cfg schema validation for the entire file:

===============================================================================

Success: The system db2dsdriver.cfg schema validation completed successfully without any errors.

Success: The User db2dsdriver.cfg schema validation completed successfully without any errors.

===============================================================================

db2cli.ini validation for data source name "TRIGLAV":

===============================================================================

[ Keywords used for the connection ]

Keyword          Value

---------------------------------------------------------------------------

PWD            ********

UID            proba

===============================================================================

db2dsdriver.cfg validation for data source name "TRIGLAV":

===============================================================================

[WARNING] Database entry for dsn is missing in IBM Data Server Configuration

file.

===============================================================================

[ Parameters used for the connection ]

Keywords         Valid For   Value

---------------------------------------------------------------------------

DATABASE         CLI,.NET,ESQL triglav

HOSTNAME         CLI,.NET,ESQL 192.168.205.176

PORT           CLI,.NET,ESQL 50000

===============================================================================

Connection attempt for data source name "TRIGLAV":

===============================================================================

[SUCCESS]

===============================================================================

The validation is completed.

===============================================================================

C:\WINDOWS\system32>

[Deleted User]

https://support.oracle.com/knowledge/Enterprise%20Performance%20Management%20and%20Business%20Intelligence/2104125_1.html

Stanisa

I have seen the document. I will try it. Thanks.