Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
JOHN CARLSON — — source: Informix-list mailing list archive (1991-1998)
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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.