IBM Support

PK89946: IMPROVE PORTAL ACCESS CONTROL PERFORMANCE WITH ORACLE DATA BACKE NDS

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The following SQL query performs poorly on Oracle databases:
    SELECT COUNT(*) FROM jcr.PROT_RES WHERE ( OWNER_UID =
    :1 AND RES_TYPE = :2 )
    The reason is the asterisk inside the COUNT aggregation
    function.
    

Local fix

Problem summary

  • The following SQL query performs poorly on Oracle databases:
    SELECT COUNT(*) FROM jcr.PROT_RES WHERE ( OWNER_UID = :1 AND
    RES_TYPE = :2 )
    The reason is the asterisk inside the COUNT aggregation
    function.
    

Problem conclusion

  • The asterisk inside COUNT has been replaced with the name of
    the primary key column 'OID'.
    
    Manual Steps:
       None
    
    Failing Module(s):
       Database
    
    Affected Users:
       All users
    
    Version Information:
        Portal Version(s): 6.0.1.1
         Pre-Requisite(s): PK48716
          Co-Requisite(s): ---
    
        Portal Version(s): 6.0.1.5
         Pre-Requisite(s): PK88425
          Co-Requisite(s): ---
    
        Portal Version(s): 6.1.0.1
         Pre-Requisite(s): PK88425
          Co-Requisite(s): ---
    
        Portal Version(s): 6.1.0.2
         Pre-Requisite(s): PK88425
          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=PK89946&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

    PK89946

  • Reported component name

    WEBSPHERE PORTA

  • Reported component ID

    5724E7600

  • Reported release

    600

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-06-26

  • Closed date

    2009-07-28

  • Last modified date

    2009-07-28

  • 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

  • R60J PSY

       UP

  • R61A PSY

       UP

  • R61B PSY

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSHRKX","label":"WebSphere Portal"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"6.0","Line of Business":{"code":"LOB31","label":"WCE Watson Marketing and Commerce"}}]

Document Information

Modified date:
21 December 2021