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

Last updated on SEPTEMBER 20, 2018

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:
[2018-06-01T12:18:36.676-04:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 000003jdNpUDsX2pJo1Fif00sW0800008y,0:1] [tid: 2223] [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 800-876-3101 in North America and +44 (0) 1753-218 930 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:
000003jdNpUDsX2pJo1Fif00sW0800008y,0:1] [tid: 2223] [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.