IBM Support

LO84846: USE OF INDEX HINT MAY REDUCE PERFORMANCE OF DATABASE QUERY

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

  • Customer reported that one of the Traveler server's database
    queries is using an index hint and actually did some modeling to
    show it can reduce performance.  There are no other queries
    using an index hint so this appears most likely to be accidental
    addition to the query SQL syntax.  Will remove the hint.
    

Local fix

  • NA
    

Problem summary

  • One of the queries in the Traveler Server's database was using
    an index hint, which was proven by a customer to reduce
    performance.
    

Problem conclusion

  • The Notes Traveler Server was updated to remove the hint, thus
    improving performance
    

Temporary fix

Comments

APAR Information

  • APAR number

    LO84846

  • Reported component name

    LOTUS NOTES TRA

  • Reported component ID

    5724E6204

  • Reported release

    901

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2015-05-01

  • Closed date

    2015-05-28

  • Last modified date

    2015-05-28

  • 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

    LOTUS NOTES TRA

  • Fixed component ID

    5724E6204

Applicable component levels

  • R901 PSY

       UP



Document information

More support for: IBM Traveler

Software version: 9.0.1

Reference #: LO84846

Modified date: 28 May 2015