Round-Robin Fragmentation
Posted in 2000
Topics: General Discussion
Three questions: 1) Am I correct in thinking this can be done with Online 7.30 (SOLARIS)? 2) What should I do with the indexes for the tables which need fragmenting? 3) This is being done to overcome the limit on # slices with Solstice (Veritas is apparently too expensive) combined with the 2GB limit in Online. Are there any other limits I could fall across leading to another embarrassing failure? TIA -- Surfer!
"Surfer!" wrote: > > Three questions: > > 1) Am I correct in thinking this can be done with Online 7.30 > (SOLARIS)? Yes > 2) What should I do with the indexes for the tables which need > fragmenting? Either detach the indexes to a single dbspace or fragment by expression based on they beginning of their key so queries can use fragment elimination on the indexes at least (no fragment elimination with ROUND ROBIN just load balancing). > 3) This is being done to overcome the limit on # slices with > Solstice (Veritas is apparently too expensive) combined with the 2GB > limit in Online. Are there any other limits I could fall across leading > to another embarrassing failure? Solstice IS Veritas VM, though usually a few version behind and therefore occassionally buggy. No problems I know of. Art S. Kagel