IBM Support

JR34001: JOB FAILED WITH "ERROR LOADING ORCHODBC" AFTER UPGRADING ODBC DRIVER TO V5.3

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Job failed with "error loading orchodbc" after upgrading ODBC
    driver to v5.3
    

Local fix

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    DS751 ODBC EE stage users
    ****************************************************************
    PROBLEM DESCRIPTION:
    JOB FAILED WITH "ERROR LOADING ORCHODBC" AFTER UPGRADING ODBC
    DRIVER TO V5.3
    ****************************************************************
    RECOMMENDATION:
    The customer has been recomended to follow the following steps
    for proper functioning (depending on the customer machine
    scenario)
    
    1. There is no need to copy the two libraries from
    branded_odbc/lib to $DSHOME/lib. This is NOT recomended. So
    there is no patch for this.
    
    2. The appropriate branded_odbc/lib path where the new DD 5.3 is
    installed should be in the starting of the list of paths in
    LD_LIBRARY_PATH env var.
         You need to rename the old DD branded_odbc to another
    directory.
    
    3. Also you need to correct the new branded_odbc/lib path in the
    dsenv file.
    
       When you say that , you are able to run things successfully
    before dsenv is run and with symbol resolution errors after
    dsenv, then it concludes that the env vars being set in dsenv
    are pointing to something old. So please set them consistently.
    
    4. Change the DSN entries pointing to new library in the new
    upgraded DD's branded_odbc/lib
    
    This is going to solve the problem. There is no need to copy the
    libraries in to $DSHOME/lib
    
    ****************************************************************
    

Problem conclusion

  • JOB FAILED WITH "ERROR LOADING ORCHODBC" AFTER UPGRADING ODBC
    DRIVER TO V5.3
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR34001

  • Reported component name

    WIS DATASTAGE

  • Reported component ID

    5724Q36DS

  • Reported release

    751

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-08-17

  • Closed date

    2009-11-30

  • Last modified date

    2009-11-30

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Modules/Macros

  • ODBC
    

Fix information

  • Fixed component name

    WIS DATASTAGE

  • Fixed component ID

    5724Q36DS

Applicable component levels

  • R751 PSN

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.5.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
30 November 2009