Fixes are available
6.1.0.3 Download: WebSphere Portal and WCM V6.1 fix pack 3, 6.1.5 feature pack
6.1.0.4 Download: WebSphere Portal and WCM V6.1.0 fix pack 4 & 6.1.5 fix pack 1
Recommended Updates for WebSphere Portal and Web Content Management V6.0
6.1.0.5 Download: WebSphere Portal and WCM V6.1.0 fix pack 5
6.1.0.6 Download: WebSphere Portal and WCM V6.1.0 fix pack 6
6.0.1.7 Download: WebSphere Portal and Web Content Manager V6.0.1, fix pack 7
APAR status
Closed as program error.
Error description
Improve query performance for portlet preferences
Local fix
Problem summary
New indices are introduced to optimize query performance for preferences of portlets. Additionally an obsolete index is removed.
Problem conclusion
When the APAR has been applied using the Portal Update Installer, then no changes are made to the database yet. Automated application of index modifications: To modify the indices this configuration task must be executed: "config-pk86903". To remove the index modifications this configuration task must be executed: "unconfig-pk86903" Once the modifications have been reverted, the APAR can be uninstalled again using the Portal Update Installer. Example: C:\IBM\WebSphere\PortalServer\config\WPSconfig.bat config-pk86903 (6.0.1.x only!) C:\IBM\WebSphere\wp_profile\ConfigEngine\ConfigEngine.bat config-pk86903 (6.1.0.x only) Manual application of index modifications: Alternatively the indices can be modified manually. The corresponding SQL statements can be found in these files: For Cloudscape: <PortalServer home>/config/templates/db/cloudscape/PK86903_install.sql For DB2 UDB LUW: <PortalServer home>/config/templates/db/db2/PK86903_install.sql For DB2 UDB for iSeries: <PortalServer home>/config/templates/db/db2_iseries/PK86903_install.sql For Oracle: <PortalServer home>/config/templates/db/oracle/PK86903_install.sql For MS SQL Server: <PortalServer home>/config/templates/db/sqlserver/PK86903_install.sql Also the indices can be removed manually. The corresponding SQL statements can be found in these files: For Cloudscape: <PortalServer home>/config/templates/db/cloudscape/PK86903_uninstall.sql For DB2 UDB LUW: <PortalServer home>/config/templates/db/db2/PK86903_uninstall.sql For DB2 UDB for iSeries: <PortalServer home>/config/templates/db/db2_iseries/PK86903_uninstall.sql For Oracle: <PortalServer home>/config/templates/db/oracle/PK86903_uninstall.sql For MS SQL Server: <PortalServer home>/config/templates/db/sqlserver/PK86903_uninstall.sql Note: Changes need to be applied to all of these three database domains equally: - RELEASE - COMMUNITY - CUSTOMIZATION Failing Module(s): Database Affected Users: All users Version Information: Portal Version(s): 6.0.1.5 Pre-Requisite(s): PK73993 Co-Requisite(s): --- Platform Specific: This fix applies to all platforms. A fix is available from Fix Central: http://www.ibm.com/eserver/support/fixes/fixcentral/swgquickorde r?apar=PK86903&productid=WebSphere%20Portal&brandid=5 You may need to type or paste the complete address into your Web browser.
Temporary fix
Comments
APAR Information
APAR number
PK86903
Reported component name
WEBSPHERE PORTA
Reported component ID
5724E7600
Reported release
61B
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-05-19
Closed date
2010-01-19
Last modified date
2010-01-19
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
WEBSPHERE PORTA
Fixed component ID
5724E7600
Applicable component levels
R60J PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSHRKX","label":"WebSphere Portal"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"6.1.0.2","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
19 January 2010