IBM Support

IT32945: SQLPROCEDURES CALLS FROM THE ODBC DRIVER PERFORM POORLY AGAINST ORACLE 12C

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • When using the Datadirect Oracle ODBC driver, the first stored
    procedure call that is made by a message flow, after the
    restart of either the integration node or integration server,
    takes significantly longer to complete. This issue is only
    observes when executing the stored procedure call against
    Oracle 12c. The same call returns quickly when run against
    Oracle 11.
    
    
    
    The problem has been identified with the
    Datadirect ODBC driver in the way synonyms are fetched during
    the SQLProcedures call.
    

Local fix

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    All users of App Connect Enterprise V11.0 and IBM Integration
    Bus v10.0 connecting to Oracle using ODBC.
    
    
    Platforms affected:
    MultiPlatform, z/OS
    
    ****************************************************************
    PROBLEM DESCRIPTION:
    After an integration node or integration server restart, the
    first call to an Oracle stored procedure from the message flow
    takes significantly longer to complete against Oracle 12c, but
    the same stored procedure call if run against Oracle 11
    completes quickly.
    

Problem conclusion

  • Product now includes upgraded Datadirect ODBC drivers for Oracle
     that addresses the performance issue with Oracle 12c stored
    procedure invocation.
    
    ---------------------------------------------------------------
    The fix is targeted for delivery in the following PTFs:
    
    Version    Maintenance Level
    v10.0      10.0.0.23
    v11.0      11.0.0.11
    
    The latest available maintenance can be obtained from:
    http://www-01.ibm.com/support/docview.wss?rs=849&uid=swg27006041
    
    If the maintenance level is not yet available,information on
    its planned availability can be found on:
    http://www-1.ibm.com/support/docview.wss?rs=849&uid=swg27006308
    ---------------------------------------------------------------
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT32945

  • Reported component name

    INTEGRATION BUS

  • Reported component ID

    5724J0540

  • Reported release

    A00

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-05-21

  • Closed date

    2020-12-15

  • Last modified date

    2020-12-15

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

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

Fix information

  • Fixed component name

    INTEGRATION BUS

  • Fixed component ID

    5724J0540

Applicable component levels

[{"Line of Business":{"code":"LOB36","label":"IBM Automation"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSNQK6","label":"IBM Integration Bus"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.0"}]

Document Information

Modified date:
16 December 2020