IBM Support

IT22463: IBM SPECTRUM CONTROL UPGRADED INSTANCES OF DB2 HAVE "CURRENTLY COMMITTED(CUR_COMMIT) = DISABLED" WHICH MAKES WEBUI VERY SLOW.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • With this setting all WebUI queries will get blocked until the
    probes/events processing commit their changes.
    Newer version of DB2 have instead
    Currently Committed                        (CUR_COMMIT) = ON
    This means that the previously committed data will be returned
    and there is no blocking for the WebUI.
    
    The installer has to check if CUR_COMMIT is  DISABLED and if it
    is then it will have to enable it ( DB2 9.7 ).
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * IBM Spectrum Control 5.2.x users upgrading to 5.2.13,        *
    * 5.2.14, or 5.2.15                                            *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * This setting impacts WebUI queries and may get blocked until *
    * the probes/events processing commit their changes have       *
    * completed.                                                   *
    * Newer version of DB2 have instead                            *
    * Currently Committed (CUR_COMMIT) = ON                        *
    *                                                              *
    * This means that the previously committed data will be        *
    * returned and there is no blocking for the WebUI.             *
    *                                                              *
    * The installer has been updated to check if CUR_COMMIT is     *
    * DISABLED and if it is then it will enable it                 *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply fix maintenance when available                         *
    ****************************************************************
    

Problem conclusion

  • The fix for this APAR is contained in the following maintenance
    package:
    
    | refresh pack  |  5.2-TIV-TPC-RP0016  |  March 2018
    
    http://www.ibm.com/support/docview.wss?&uid=swg21320822
    
    The target dates for future releases do not represent a formal
    commitment by IBM. The dates are subject to change without
    notice.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT22463

  • Reported component name

    TPC ADVANCED

  • Reported component ID

    5608TPCA0

  • Reported release

    52D

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-09-20

  • Closed date

    2017-12-06

  • Last modified date

    2017-12-06

  • 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

    TPC ADVANCED

  • Fixed component ID

    5608TPCA0

Applicable component levels

[{"Business Unit":{"code":"BU029","label":"Software"},"Product":{"code":"SSC6VJ","label":"IBM Spectrum Control Advanced Edition"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"52D"}]

Document Information

Modified date:
04 September 2023