DB2 - L

  • 1.  DB2 z/OS - Lock on COLLECTION While running REORG REBANLANCE SHRLEVEL CHANGE

    Posted Oct 21, 2021 03:02 PM
    Edited by EKTA GUPTA Oct 21, 2021 03:04 PM
    Hello All,

    I am wondering if anyone has experience Reorg Rebalance SHRLEVEL CHANGE utility take X lock on COLLECTION.

    We had a situation where Deadlock happens when we were running 2 concurrent reorgs on two different tablespace

    - First REORG REBALNCE SHRLEVEL CHANGE on a TS which took X lock on a COLLECTION
    - Second REORG to materialize BP change on different TS which took X lock on a Package which is dependent on both the objects

    Why Reorg Rebalance took lock on collection?

    I appreciate if you could share any thoughts, idea or experience.

    Thanks for your help

    ------------------------------
    Ekta
    ------------------------------


  • 2.  RE: DB2 z/OS - Lock on COLLECTION While running REORG REBANLANCE SHRLEVEL CHANGE

    Posted Oct 22, 2021 12:49 PM
    When you reorg with rebalance packages have to be rebound. So at least X-lock in the packages are necessary. X-lock on the collection seems to me strange, because that would me you can't bind any package into this collection.

    ------------------------------
    WalterJanißenRetired
    ------------------------------



  • 3.  RE: DB2 z/OS - Lock on COLLECTION While running REORG REBANLANCE SHRLEVEL CHANGE

    Posted Oct 26, 2021 12:06 AM
    Thanks Walter for your response.

    We are agree that reorg rebalance and reorg to materialize BP changes need to  hold lock on dependent packages as they invalidate packages and Dynamic cache but why it hold lock on entire collection?

    ------------------------------
    Ekta
    ------------------------------



  • 4.  RE: DB2 z/OS - Lock on COLLECTION While running REORG REBANLANCE SHRLEVEL CHANGE

    Posted Oct 26, 2021 03:37 PM
    Hi Ekta,

    What was the exact deadlock error message?

    ------------------------------
    Jørn Thyssen
    Rocket Software
    2021 IBM Champion
    ------------------------------