PK39589
=======

Problem Description:
  This is a performance enhancement for WCM syndication. Large SQL query and result set consumption required optimization.


Problem Solution:
   PK39589 contains code changes.
	 
Affected Users:
   All portal users.

Pre-Requisite(s):
   Portal Version: 6.0.0.0
   Portal Fixes:   none
   
Installation (PortalServer):
   NOTE:  YOU MUST FIRST DOWNLOAD THE UPDATE INSTALLER TOOL IN ORDER TO INSTALL A FIX.
          The Portal Update Installer can be downloaded from the following link:
          http://www.ibm.com/support/docview.wss?rs=688&uid=swg24006942

   1. Create temporary "fix" directory to store the jar file.
   3. Shutdown WebSphere Portal.
   4. Follow the fix installation instructions that are packaged with
      the Portal Update Installer on how to install the fix.
      Use -installDir <PortalServer directory path> as a parameter.
   5. Restart WebSphere Portal. 
   6. The temporary directory may be removed.

Post-Installation:

1. Execute the following SQL commands (DB2 Server Installations Only)

drop index jcr.ICMSTJCRWSNODESIX3
create unique index jcr.ICMSTJCRWSNODESIX3 on jcr.ICMSTJCRWSNODES (UUID, WSID) include (IID, CTID, COMPID, VID)

drop index jcr.ICMSTJCRWSNODESIX4
create unique index jcr.ICMSTJCRWSNODESIX4 on jcr.ICMSTJCRWSNODES (IID, WSID) include (UUID, CTID, COMPID, VID)

2. Tune the DB as follows:

http://publib.boulder.ibm.com/infocenter/wpdoc/v6r0/topic/com.ibm.wp.ent.doc/wpf/tune_db.html

Uninstall:
   NOTE:  FIXES MUST BE REMOVED IN THE ORDER THEY WERE APPLIED.  DO NOT REMOVE 
          A FIX UNLESS ALL FIXES APPLIED AFTER IT HAVE FIRST BEEN REMOVED.
          YOU MAY REAPPLY ANY REMOVED FIX.

   1. Shutdown WebSphere Portal.
   2. Follow the instructions that are packaged with the
      Portal Update Installer on how to uninstall the fix.
   3. Restart WebSphere Portal.