Results 1 to 2 of 2

Thread: DB2/Linux woes.

  1. #1
    Join Date
    Nov 2003
    Posts
    1

    Unhappy Unanswered: DB2/Linux woes.

    Okay, let me toss my specs out first and get that out of the way. I'm running RedHat 8, trying to connect to an AS/400, using the DB2 "conpe" version 8.1, and I have unixODBC as my ODBC system. I think that covers it.

    Here's my situation: We've got an AS/400 here at work, and I need to get a Linux machine to talk to it via ODBC so they can exchange i formation. Mostly, the Linux machine needs to pull data, for user validation, catalogue lists, etc. Unfortunately, I cannot get my Linux machine to talk to the AS/400. Now, I know the AS/400's ODBC port is open, because I can use MS Access to import table from it. The Windows DSN, via Rumba (from what used to be Wall Data), works. My Linux DSN does not.

    I have wracked my brains, Googled, and looked through the DB2 information over on unixodbc.org; however, nothing works. At the risk of sounding like a DB2 newbie, which I am, can someone tell me what I'm doing wrong? What to I need to tweak in my odbcinst.ini and odbc.ini files to get isql, and subsequent scripts/apps, to connect across the network? Can I connect from a Linux client to an AS/400 by giving unixODBC an IP address? Any help would be appreciated! Thanks in advance!

    Also, the following are my odbcinst.ini and odbc.ini files, respectively:

    --- odbcinst.ini ---

    [PostgreSQL]
    Description = ODBC for PostgreSQL
    Driver = /usr/lib/libodbcpsql.so
    Setup = /usr/lib/libodbcpsqlS.so
    FileUsage = 1

    [iSeries Access ODBC Driver]
    Description = iSeries Access for Linux ODBC Driver
    Driver = /opt/ibm/iSeriesAccess/lib/libcwbodbc.so
    Setup = /opt/ibm/iSeriesAccess/lib/libcwbodbc.so
    Threading = 2
    FileUsage = 1

    [DB2]
    Description = DB2 Driver
    Driver = /opt/IBM/db2/V8.1/lib/libdb2.so
    FileUsage = 1
    DontDLClose = 1

    --- odbc.ini ---

    [AS400]
    Description = Connects to the as400
    Driver = DB2

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1

    Re: DB2/Linux woes.

    Originally posted by turbov21

    I have wracked my brains, Googled, and looked through the DB2 information over on unixodbc.org;

    ...

    Also, the following are my odbcinst.ini and odbc.ini files, respectively:

    --- odbcinst.ini ---

    [PostgreSQL]
    Description = ODBC for PostgreSQL
    Driver = /usr/lib/libodbcpsql.so
    Setup = /usr/lib/libodbcpsqlS.so
    FileUsage = 1

    [iSeries Access ODBC Driver]
    Description = iSeries Access for Linux ODBC Driver
    Driver = /opt/ibm/iSeriesAccess/lib/libcwbodbc.so
    Setup = /opt/ibm/iSeriesAccess/lib/libcwbodbc.so
    Threading = 2
    FileUsage = 1

    [DB2]
    Description = DB2 Driver
    Driver = /opt/IBM/db2/V8.1/lib/libdb2.so
    FileUsage = 1
    DontDLClose = 1

    --- odbc.ini ---

    [AS400]
    Description = Connects to the as400
    Driver = DB2
    I'm not an expert in unixODBC but I suspect you might be attempting to use a wrong driver. I'd think you would use "iSeries Access ODBC Driver" and not "DB2 Driver" in your odbc.ini


    Also, when you were googling, have you googled this:

    http://www-1.ibm.com/servers/eserver...s/linux/guide/
    ---
    "It does not work" is not a valid problem statement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •