PK73993: IMPROVE QUERY PERFORMANCE OF PORTAL ACCESS CONTROL

APAR status

• Closed as program error.

Error description

• On DB2 UDB LUW, DB2 UDB for iSeries and DB2 UDB for z/OS the
  following database query might take very long until it returns,
  if many pages exist:
  "SELECT OID, CREATED, MODIFIED, RES_TYPE, EXTERNAL_OID,
  EXTERNAL_UID, PARENT_OID, OWNER_TYPE, OWNER_UID, INHERITANCE,
  PROPAGATION, EXTERNALIZED, IS_PRIVATE, NAME, IS_LEAF FROM
  community.PROT_RES WHERE PARENT_OID IN (?, ..., ?) AND RES_TYPE
  IN (?, ?) AND IS_PRIVATE = 0"
  The amount of parameter markers in the "IN" list for column
  "PARENT_OID" is arbitrary, but the low performance can be the
  same.
  

Local fix

Problem summary

• On DB2 UDB LUW, DB2 UDB for iSeries and DB2 UDB for z/OS the
  following database query might take very long until it returns,
  if many pages exist:
  "SELECT OID, CREATED, MODIFIED, RES_TYPE, EXTERNAL_OID,
  EXTERNAL_UID, PARENT_OID, OWNER_TYPE, OWNER_UID, INHERITANCE,
  PROPAGATION, EXTERNALIZED, IS_PRIVATE, NAME, IS_LEAF FROM
  community.PROT_RES WHERE PARENT_OID IN (?, ..., ?) AND RES_TYPE
  IN (?, ?) AND IS_PRIVATE = 0"
  The amount of parameter markers in the "IN" list for column
  "PARENT_OID" is arbitrary, but the low performance can be the
  same.
  

Problem conclusion

• On applicable DB2 databases the indices IX2110E and IX2110F will
  be removed and the indices IX2110E2 and IX2110G will added.
  
  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-pk73993".
  To remove the index modifications this configuration task must
  be executed:
     "unconfig-pk73993"
  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-pk73993   (6.0.1.x only!)
  C:\IBM\WebSphere\wp_profile\ConfigEngine\ConfigEngine.bat
  config-pk73993  (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:
  
  6.0.1.x only:
  For DB2 UDB LUW: <PortalServer
  home>/config/templates/db/db2/PK73993_install.sql
  For DB2 UDB for iSeries: <PortalServer
  home>/config/templates/db/db2_iseries/PK73993_install.sql
  For DB2 UDB for z/OS: <PortalServer
  home>/config/templates/db/db2_zos/PK73993_install.sql
  
  6.1.0.x only:
  For DB2 UDB LUW: <PortalServer
  home>/base/wp.db.impl/config/templates/db/db2/PK73993_install.sq
  l
  For DB2 UDB for iSeries: <PortalServer
  home>/base/wp.db.impl/config/templates/db/db2_iseries/PK73993_in
  stall.sql
  For DB2 UDB for z/OS: <PortalServer
  home>/base/wp.db.impl/config/templates/db/db2_zos/PK73993_instal
  l.sql
  
  Also the indices can be removed manually. The corresponding SQL
  statements can be found in these files:
  
  6.0.1.x only:
  For DB2 UDB LUW: <PortalServer
  home>/config/templates/db/db2/PK73993_uninstall.sql
  For DB2 UDB for iSeries: <PortalServer
  home>/config/templates/db/db2_iseries/PK73993_uninstall.sql
  For DB2 UDB for z/OS: <PortalServer
  home>/config/templates/db/db2_zos/PK73993_uninstall.sql
  
  6.1.0.x only:
  For DB2 UDB LUW: <PortalServer
  home>/base/wp.db.impl/config/templates/db/db2/PK73993_uninstall.
  sql
  For DB2 UDB for iSeries: <PortalServer
  home>/base/wp.db.impl/config/templates/db/db2_iseries/PK73993_un
  install.sql
  For DB2 UDB for z/OS: <PortalServer
  home>/base/wp.db.impl/config/templates/db/db2_zos/PK73993_uninst
  all.sql
  
  Note: Changes need to be applied to all of these four database
  domains equally:
     - RELEASE
     - COMMUNITY
     - CUSTOMIZATION
     - JCR
  
  Failing Module(s):
     Database
     Portal Access Control
     Performance
  
  Affected Users:
     All users
  
  Version Information:
      Portal Version(s): 6.0.1.1
       Pre-Requisite(s): PK47660
        Co-Requisite(s): ---
  
      Portal Version(s): 6.0.1.3
       Pre-Requisite(s): PK66066
        Co-Requisite(s): ---
  
      Portal Version(s): 6.0.1.4
       Pre-Requisite(s): PK66066
        Co-Requisite(s): ---
  
      Portal Version(s): 6.0.1.5
       Pre-Requisite(s):
        Co-Requisite(s): ---
  
      Portal Version(s): 6.1.0.0
       Pre-Requisite(s): PK66066
        Co-Requisite(s): ---
  
      Portal Version(s): 6.1.0.1
       Pre-Requisite(s):
        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=PK73993&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 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

• R60E PSY

     UP

• R60G PSY

     UP

• R60H PSY

     UP

• R60J PSY

     UP

• R610 PSY

     UP

• R61A PSY

     UP