Direct links to fixes
APAR status
Closed as program error.
Error description
CRTST stored procedure does a select * and uses IDX_STMT_REL_SUBJ index which is a 6 column index on a 6 column table. So an index scan is not much more efficient than a table scan. Changing the index to a 3 column index has a huge impact on the performance. This APAR is intended to change the 6 column index to a 3 column index.
Local fix
Problem summary
Performance when loading complex WSDL documents might be very poor when using a DB2 database. Other aspects of WSRR performance might also be suboptimal.
Problem conclusion
It was found that real world DB2 performance is improved by removing the IDX_STMT_REL_SUBJ index defined in the provided createWsrrTables1.sql database script. This index has now been removed from the script and this change is targeted for inclusion in fix pack 3 for WSRR v7.5 and fix pack 1 for WSRR v8.0. For existing WSRR DB2 databases, the manual step to apply this APAR is simply to drop the IDX_STMT_REL_SUBJ index from the main WSRR database.
Temporary fix
Comments
APAR Information
APAR number
IV24930
Reported component name
SERVICE REGISTR
Reported component ID
5724N7200
Reported release
750
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2012-07-18
Closed date
2012-07-20
Last modified date
2012-07-20
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
R750 PSY
UP
R800 PSY
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSWLGF","label":"WebSphere Service Registry and Repository"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.5","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
20 July 2012