Informix

 View Only
  • 1.  Informix Cluster Pro Tip!

    IBM Champion
    Posted Thu June 11, 2020 09:11 AM
    When dropping a chunk from a DB cluster that includes an RSS node that has DELAY_APPLY set, it's a really good idea to wait until after the delay window has passed before removing the link/chunk from that node.

    It's an even better idea to not reassign that chunk to a different dbspace before the window has passed.

    Thank you for coming to my TED talk.

    ------------------------------
    TOM GIRSCH
    ------------------------------

    #Informix


  • 2.  RE: Informix Cluster Pro Tip!

    IBM Champion
    Posted Thu June 11, 2020 09:28 AM
    Voice of bitter and well earned experience!

    Art S. Kagel, President and Principal Consultant
    ASK Database Management


    Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference.  Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.








  • 3.  RE: Informix Cluster Pro Tip!

    IBM Champion
    Posted Thu June 11, 2020 09:34 AM
    One I "earned" mere hours after earning the "It doesn't matter how many chunks you throw at it if the tblspace has hit 32 GB" experience.

    ------------------------------
    TOM GIRSCH
    ------------------------------