Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Connection to DB2 through OBIEE Admin Tool

Received Response
111
Views
11
Comments
user12058206
user12058206 Rank 4 - Community Specialist
edited Aug 13, 2024 5:51PM in Oracle Analytics Cloud and Server

We are trying to Import tables from Db2. When we try to import we see the below error. Oracle asked us to install Db2 Client and import tables through DB2 CLI (Unicode). But still we see this error. Please guide if anyone came across this issue.

pastedImage_5.png

«1

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Did you set the required DB2 environment variables?

    Like LD_LIBRARY_PATH

  • user12058206
    user12058206 Rank 4 - Community Specialist

    Yes We did.

    pastedImage_0.png

  • user12058206
    user12058206 Rank 4 - Community Specialist

    Did someone come across this issue. Even Oracle not providing any solution on this issue.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Every time I had this issues itwas because of missing env variables. Check MOS Doc ID 2104125.1

  • user12058206
    user12058206 Rank 4 - Community Specialist

    Christian,

    We already followed this document and tried. But still no use.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Ok that's just weird. Have you tried installing the Admin Tool and libraries on another PC?

  • user12058206
    user12058206 Rank 4 - Community Specialist

    Yes we did. Even on Server it's same. We are not able to make Connection to DB2. On server also Db2 admin installed Db2 client and environment variables are created.

    We can Import tables if we use ODBC 3.5 but again Oracle says that is not recommended. We deployed RPD with ODBC connection and on analytics we see communication error  connecting to remote address error.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Then use ODBC. Telling you to use something which does not work is supremely useless on their part.

  • user12058206
    user12058206 Rank 4 - Community Specialist

    Using ODBC we are able to import the tables into RPD. but when we check on the Analytics it gives us communication error or ODBC memory allocation is full. We already updated the odbc.ini file on the server with DB2 connection information.

  • Joel
    Joel Rank 8 - Analytics Strategist

    What version of DB2 and OBIEe are you using? Also, what OS are you using?