Direct links to fixes
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
This fix will be included in IBM Traveler 9.0.1.5 and all later releases. For the latest Traveler Maintenance release information see this technote: http://www.ibm.com/support/docview.wss?uid=swg24019529
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
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSYRPW","label":"Lotus Notes Traveler"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.0.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
28 May 2015