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.

 

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":"LOB02","label":"AI Applications"}}]

Document Information

Modified date:
08 March 2017