Planning Analytics

 View Only

  • 1.  Tm1 to zos db2

    Posted Mon November 11, 2019 04:17 PM
    We are having an issue connecting to zOS db2 from TM1 server (linux)

    We have installed local db2, odbc drivers and cataloged 2 db(1 local linux db and 1 cataloged to zos db)
    We can connect to box to each db using db2 connect and run queries
    We can run isql (odbc tool) to both local and remote db
    We can run Tm1 process that just runs a simple queries on the local odbc db but can not on the zos db

    The sql trace shows this error when running against zos

    Statement = 0x7fa98028ddb0Statement = 0x7fa98028ddb0 SQL = [ SELECT * FROM SYSIBM.SYSTABLES FETCH FIRST 10 ROWS ONLY; ][length = 58 (SQL_NTS)
    ][ODBC][63194][1573150593.310787][SQLExecDirectW.c][299]Error: IM001
    [ODBC][63194][1573150593.310820][SQLErrorW.c][276] Entry: Statement = 0x7fa98028ddb0 SQLState = 0x7fa9937fbf90 Native = 0x7fa9937fbf8c Message Text = 0x7fa9937fbfb0 Buffer Length = 511 Text Len Ptr = 0x7fa9937fbf8a
    [ODBC][63194][1573150593.310858][SQLErrorW.c][318] Exit:[SQL_SUCCESS] SQLState = [IM001] Native = 0x7fa9937fbf8c -> 0 Message Text = [[unixODBC][Driver Manager]Driver does not support this function]
    [ODBC][63194][1573150593.310935][SQLTransact.c][210] Entry:

    anyone have a solution?

    ------------------------------
    Mark Bland
    ------------------------------

    #PlanningAnalyticswithWatson


  • 2.  RE: Tm1 to zos db2

    Posted Tue November 12, 2019 07:10 AM

    Not sure the answer, but it may help to see the following:


    1 - ODBC config in the tm1s.cfg file
    2- Confirm if you are using unixODBC (I think you are based on the error) and share your unixODBC config file
    3 - Example of the SQL query in your TI process
    4 - Confirm if a very simple SQL query works (e.g SELECT * from TABLE)
    5 - Version of the DB2 client on the system with TM1



    ------------------------------
    Stuart King
    IBM Planning Analytics Offering Manager
    ------------------------------

    Original Message


  • 3.  RE: Tm1 to zos db2

    Posted Tue November 12, 2019 12:18 PM
    We were trying to use odbc. 
    Worked if we used odbc to db2 UDB running on a linux box.  But would not work if we tried to a zos box. 
    ISQL worked on both odbc connection.

    We hooked up with another group that was running a similar setup and the major difference was they were using libdb2o.o library in tm1 cfg while we were using libodbc.o.  Once we switched the tm1 cfg to use libdb2o.o (from lib64) it worked like a champ.  No need for all the odbc configuration.   Something in the odbc setup does not like the way tm1 calls when using zos.

    Thanks for getting back to me but we are good now.  Have a great day.

    ------------------------------
    Mark Bland
    ------------------------------

    Original Message


  • 4.  RE: Tm1 to zos db2

    Posted Tue November 12, 2019 01:07 PM
    Glad to hear that you got it working!  unixODBC is only required if you have multiple ODBC data source types.  I don't think there is any other way to setup multiple data source types without unixODBC.

    ------------------------------
    Stuart King
    IBM Planning Analytics Offering Manager
    ------------------------------

    Original Message