OBIEE Can Not Connect To DB/2 (Doc ID 2421247.1)

Last updated on MARCH 18, 2021

Applies to:

Symptoms

Environment
===========
11.1.1.9.0
OS: IBM AIX 7.1
DB2: IBM DB2 UDB 10.5.5
DB2 Installed OS: IBM AIX 7.1

Getting error messages and can not access DB/2 database in OBIEE.

Connection open failed:
[DataDirect][ODBC lib] The driver is incapable of supporting the current environment attributes.
Give data source name:

logs:
[<TIMESTAMP>] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: <ECID>] [tid: <TID>] [nQSError: 16017] Memory allocation error occurred while allocating ODBC environment. [[

[DataDirect][ODBC lib] You are not licensed to use this ODBC driver with the DataDirect ODBC Driver Manager under the license you have purchased. You can order a license by calling DataDirect Technologies at xxx-xxx-xxxx in North America and +xx (0) xxxx-xxx xxx elsewhere. Thank you for your cooperation.
Statement execute failed


NQServer logs
 [nQSError: 43119] Query Failed: Could not load module . System error: No such file or directory (HY000)

nqserver logs after correcting path of DB2 lib
[ERROR:1] [] [] [ecid:
<ECID>] [tid: <TID>] [nQSError: 16017] Memory
allocation error occurred while allocating ODBC environment. [[
file:
server/Query/Execution/DbGateway/Db2Cli35/../Odbc/Src/SQXDGOdbcConnection.cpp;
 line: 246

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.