Informix Cluster Pro Tip!

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

Voice of bitter and well earned experience! Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ 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.

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 ------------------------------