RE: sysdistrib table all fragmented

1. Dont. (consolidate in place) 2. dbexport, reinitialise the instance, dbimport. 3. consolidate the table(s) into a new dbspace or chunk. MW -----Original Message----- From: owner-informix-list@iiug.iiug.org [mailto:owner-informix-list@iiug.iiug.org]On Behalf Of brian@asl.ca Sent: Wednesday, December 06, 2000 11:22 AM To: informix-list@iiug.org Subject: sysdistrib table all fragmented One our databases has a sysdistrib table that has a few extents grabbed. The problem is that they are blocking other "normal" tables from consolidating. How can I get sysdistrib to reconsolidate? Any of the sys tables for that matter? I get a "511 cannot alter system catalog. Thanks, Brian. Sent via Deja.com http://www.deja.com/ Before you buy.

In article <90keg8$k71$1@news.xmission.com>, <murray@quanta.co.nz> wrote: > > > 1. Dont. (consolidate in place) Why don't consolidate in place? Exactly what database operations do you have in mind when not recommending consolidating in place? "ALTER FRAGMENT ON TABLE <table> INIT IN <dbspace or fragment expression>" or "ALTER INDEX <index> TO CLUSTER"? > 2. dbexport, reinitialise the instance, dbimport. Drop the exported database? > 3. consolidate the table(s) into a new dbspace or chunk. How? > > MW > > -----Original Message----- > From: owner-informix-list@iiug.iiug.org > [mailto:owner-informix-list@iiug.iiug.org]On Behalf Of brian@asl.ca > Sent: Wednesday, December 06, 2000 11:22 AM > To: informix-list@iiug.org > Subject: sysdistrib table all fragmented > > One our databases has a sysdistrib table that has a few extents > grabbed. > The problem is that they are blocking other "normal" tables from > consolidating. > > How can I get sysdistrib to reconsolidate? Any of the sys tables for > that matter? I get a "511 cannot alter system catalog. > > Thanks, > > Brian. > > Sent via Deja.com http://www.deja.com/ > Before you buy. > Sent via Deja.com http://www.deja.com/ Before you buy.