RE: Round-Robin Fragmentation

Posted in 2000

Hannes Visagie — Thu, 13 Jul 2000 14:33:26 +0200 — source: Informix-list mailing list archive (1991-1998)

1. Yes. 2. You can fragment them across disks fragment by expression (mod(mm_yyww , 4 ) = 0 ) in mmhdbs0 , (mod(mm_yyww , 4 ) = 1 ) in mmhdbs1 , (mod(mm_yyww , 4 ) = 2 ) in mmhdbs2 , (mod(mm_yyww , 4 ) = 3 ) in mmhdbs3 ; 3. You can have many slices per DB space. No 2 gig limit. Yes 2 Gig limit per chunk. Remember U can use partition/slice 2 {backup} also for raw space -----Original Message----- From: Surfer! [SMTP:nevis-view@nospam.demon.co.uk] Sent: Thursday, July 13, 2000 12:35 PM To: informix-list@iiug.org Subject: Round-Robin Fragmentation 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!