PM14832: IMPROVE ACCESS ON DATABASE TABLE PROT_RES

APAR status

• Closed as program error.

Error description

• On Portal systems using non-DB2 database backends, the following
  database queries sometimes are slow even though they are backed
  by indexes.
  
  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 (:1)
  AND RES_TYPE IN (:2, :3)
  AND IS_PRIVATE = 0
  
  
  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
  OWNER_UID = :1
  AND RES_TYPE = :2
  
  
  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
  RES_TYPE = :1
  AND EXTERNAL_OID = :2
  AND EXTERNAL_UID IS NULL
  

Local fix

• n/a
  

Problem summary

• On Portal systems using non-DB2 database backends, the
  following database queries sometimes are slow even though they
  are backed by indexes:
  
  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 (:1) AND RES_TYPE IN (:2,
  :3) AND IS_PRIVATE = 0
  
  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 OWNER_UID = :1 AND RES_TYPE = :2
  
  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 RES_TYPE = :1 AND EXTERNAL_OID = :2 AND
  EXTERNAL_UID IS NULL
  

Problem conclusion

• Indexes IX2110E and IX2110F are replaced by IX2110E2 and
  IX2110G.
  
  Failing Module(s):
     Database
  
  Affected Users:
     All users
  
  Version Information:
     Portal Version(s): 6.1.0.3
      Pre-Requisite(s): ---
       Co-Requisite(s): ---
  
  Manuel Steps:
     None
  
  Platform Specific:
     This fix applies to all platforms.
  
  
  PM14832 is part of Cumulative Fix 06 for Portal 6.1.0.3/6.1.5.0.
  
  The fix is available from Fix Central:
  
  http://www.ibm.com/eserver/support/fixes/fixcentral/swgquickorde
  r?apar=PM14900&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

• R61C PSY

     UP