IBM Support

LI76488: CMVC 215607 - PREVENT CTXMGMT INSERT WITH RUNAS -1002 TO AVOID ITL ORACLE LOCK CONTENTION

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Oracle limits the number of concurrent (uncommitted) DML
    operations that update a data/index block.
    When the limit is reached, new connections attempting to update
    the same block will block in ITL lock wait.
    
    Under particular scenarios, WebSphere Commerce code can insert
    rows in the CTXMGMT table using runAsId of -1002,
    and the runAsId is updated to the actual non-generic user ID in
    a subsequent UPDATE statement in the same transaction.
    
    Under high load, when the number of concurrent transactions
    inserting into the CTXMGMT table exceeds the Oracle limit,
    there could be ITL lock contention on the index by RUNAS_ID
    (I0000896) for those rows inserting -1002 as the value.
    

Local fix

Problem summary

  • USERS AFFECTED:
    WebSphere Commerce 7 Oracle installations with high volume sites
    
    PROBLEM ABSTRACT:
    Prevent database inserts into the CTXMGMT table when the runAs
    userId is -1002 to avoid ITL Oracle Lock contention
    
    BUSINESS IMPACT:
    With high volume, if there is a slow down in the database, ITL
    locks could show as a symptom.  Also, if there is a burst of
    inserts to the CTXMGMT table, the locking could block a large
    percentage of database connections and Web Container threads
    leading to an outage
    
    RECOMMENDATION:
    

Problem conclusion

  • WebSphere Commerce code was updated so if the runAsId is known,
    the original insert will be done using the non-generic
    user Id instead of inserting runAsId  -1002 and then updating to
    the non-generic Id during the same transaction
    
    -------------------------------------------------------------
    The latest available maintenance information can be obtained
    from the Recommended Fixes for WebSphere Commerce technote:
    http://www.ibm.com/support/docview.wss?rs=3046&uid=swg21261296
    

Temporary fix

Comments

APAR Information

  • APAR number

    LI76488

  • Reported component name

    WC COM PROF ILI

  • Reported component ID

    5724I4004

  • Reported release

    600

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    YesSpecatt / Pervasive

  • Submitted date

    2011-11-03

  • Closed date

    2011-12-06

  • Last modified date

    2012-07-04

  • 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

    WC COM PROF ILI

  • Fixed component ID

    5724I4004

Applicable component levels

  • R600 PSY

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSPK6A","label":"WebSphere Commerce Professional"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"6.0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
04 July 2012