IBM Support

PH09108: Updates to unsubscribed users delay user database upgrade

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When a CQ user has been subscribed to a user database and later
    on unsubscribed, any upgrade of the user database will replay
    the unsubscription. In case where a large number of users have
    been unsubscribed, this can lead to large times to complete user
    database upgrades.
    
    Steps to reproduce:
    Just have a user subscribed to a database, explicitly or via
    group membership and then unsubscribe it to that database. The
    next time you upgrade that same database you always get the
    unsubscribed user updated, even if the change you want to
    propagate has nothing to do with that user (like changing the
    password of some other user).
    if your have 4000 users subscribed to a database and you change
    the password of one of them, the upgrade of the user database
    updates only that single user. If you then unsubscribe 3000 of
    those users and late on change the password of one of the
    remaining 1000 users then the upgrade of the user database will
    update 3001 users.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ClearQuest                                                   *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * When a ClearQuest user has been subscribed to a user         *
    * database and later unsubscribed, any upgrade of the user     *
    * database will replay the unsubscription.  This causes slower *
    * performance for user database upgrades as you have more      *
    * unsubscribed users.                                          *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    

Problem conclusion

  • A fix is available 9.0.1.11 and 9.0.2.3.
    ClearQuest has been fixed so that the unsubscribed users are
    marked inactive during user database upgrades.  This results in
    better performance.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH09108

  • Reported component name

    CLEARQUEST WIN

  • Reported component ID

    5724G3600

  • Reported release

    901

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-02-27

  • Closed date

    2021-01-11

  • Last modified date

    2021-01-11

  • 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

    CLEARQUEST WIN

  • Fixed component ID

    5724G3600

Applicable component levels

  • R901 PSY

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSSH5A","label":"Rational ClearQuest"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"901","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
19 November 2021