RE: Round-Robin Fragmentation
See below
> -----Original Message-----
> From: Surfer! [SMTP:nevis-view@nospam.demon.co.uk]
> Sent: Thursday, July 13, 2000 6:35 AM
> 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)?
>
Yes, it can . . . at least with HP . . . . 8-)
> 2) What should I do with the indexes for the tables which need
> fragmenting?
>
Just detach them; such as
CREATE INDEX idx_name ON fragged_table (col_names here) INsome_other_dbspace
> 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?
We're HP, so I can't help with that one.
John Carlson
Informix DBA
WHSmith USA