DB2 - L

 View Only
  • 1.  Latch on index

    Posted Nov 17, 2021 02:24 PM
    Hi 
    I am wondering to know how to reduce latch on index.
    Thanks for your help 
    Regards 
    Leila 


  • 2.  RE: Latch on index

    Posted Dec 13, 2021 01:58 PM
    Edited by Joe Huang Dec 13, 2021 03:06 PM
    We reduced index latches  using larger BP for indexes
    Cheers 
    Joe 
    BUFFERPOOL Total Latch LC06 count
    BP32K2   VPSIZE  10000 38407
    BP16K0   VPSIZE  10000 55109
    BP8K0   VPSIZE  10000 100390
    BP40    VPSIZE  10000 176710