A fix is available
APAR status
Closed as new function.
Error description
If documents are loaded into WSRR with a large number of elements, these can cause performance issues when they come to be indexed or retrieved for Text Search. It may be that these elements (or other object types and attributes) are deemed to not necessarily be searchable.
Local fix
Problem summary
**************************************************************** USERS AFFECTED: All users of WebSphere Service Registry and Repository V8.5 **************************************************************** PROBLEM DESCRIPTION: When performing operations using the text search index a very large query can be generated if a large number of objects match the criteria of the search. These potentially exceedingly large queries can result in significant database performance degradation during the processing of the query. This results in other database operations being unable to complete whilst the database processes the index query. Typically these large queries are the result of large files such as XSDs or WSDLs, which when loaded create a large number of logical objects representing the different components of these documents. In addition, during the indexing operations to add or update objects into the index, or performing a complete reindex of the text based documents, timeouts can occur if it takes a large amount of time to process all the objects that are stored within WSRR.
Problem conclusion
Contact IBM Support if you believe you require this fix as it requires explicit enablement. This fix is targeted for inclusion in WSRR V8.5.6.2
Temporary fix
Comments
APAR Information
APAR number
IJ04339
Reported component name
SERVICE REGISTR
Reported component ID
5724N7200
Reported release
850
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2018-02-22
Closed date
2018-11-21
Last modified date
2018-11-21
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
SERVICE REGISTR
Fixed component ID
5724N7200
Applicable component levels
R850 PSY
UP
[{"Line of Business":{"code":"LOB45","label":"Automation"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSWLGF","label":"WebSphere Service Registry and Repository"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"850"}]
Document Information
Modified date:
13 September 2021