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":"LOB45","label":"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
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback