IBM Support

IT13750: SQL QUERIES THAT DO NOT USE 'BIND' VARIABLES CAUSES PERFORMANCE ISSUES

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.

Direct links to fixes

si_52_build_5020500_interimfix_12
si_52_build_5020500_interimfix_12

 

APAR status

  • Closed as program error.

Error description

  • SQL queries that do not use 'bind' variables causes
fragmentation in the shared pool (memory) and hence performance
issues.


Environment Information:

SI HotfixVersion: 5020401_BR57240_400472_HF2
Database: Oracle 11.2.0.3
OS-System: Linux 2.6.32-279.9.1.el6.x86_64,amd64

The following are the queries that do not use
'bind' variables:

1) SELECT SYSTEMNAME FROM SCHEDULE WHERE SCHEDULEID = 26

2) SELECT SCI_SUBGROUP_LIST.USERGROUP_KEY
  FROM SCI_SUBGROUP_LIST, YFS_USER_GROUP
WHERE     SCI_SUBGROUP_LIST.PARENTGROUP_KEY =
'1366902489263--196337842'
       AND SCI_SUBGROUP_LIST.USERGROUP_KEY =
YFS_USER_GROUP.USERGROUP_KEY
       AND YFS_USER_GROUP.ACTIVATEFLAG = 'Y'

Local fix

  • STRRTC - 462869
PC / PC
Circumvention: None

Problem summary

  • Users Affected:
All

Problem Description:
SQL queries not using bind variables causing performance issues.

Platforms Affected:
All

Problem conclusion

  • Resolution Summary:
A code fix has been provided.

Delivered in:
5020500_12
5020601_7

Temporary fix

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    IT13750
    • 

  • Reported component name
    STR B2B INTEGRA
    • 

  • Reported component ID
    5725D0600
    • 

  • Reported release
    524
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt / Xsystem
    • 

  • Submitted date
    2016-02-11
    • 

  • Closed date
    2016-03-23
    • 

  • Last modified date
    2017-03-08
    • 





    

  • 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
    STR B2B INTEGRA
    • 

  • Fixed component ID
    5725D0600
    • 



Applicable component levels


    

  • R525  PSY
       UP
    • 








      
              
                            

              

              [{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS3JSW","label":"IBM Sterling B2B Integrator"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.2.4","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            08 March 2017
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback