Re: syscolumns extents

Posted in 1998

Art S. Kagel — Tue, 31 Mar 1998 16:43:08 -0500 — source: Informix-list mailing list archive (1991-1998)

DNICKE@RIA-EMH2.ARMY.MIL wrote: > > Informix OnLine 5.0 > HPUX 10.20 > HP-755 Server > Database w/135 tables > > I started getting a warning that syscolumns has more than 8 > extents. I don't remember having an opportunity to set > extents or sizes on system tables. The table has 2352 rows. > Is this critical and is there a safe way to modify the > table's extents? No big deal. The warning at 8 extents was an arbitrary choice of when to give you notice that you MAY need to look at defragmenting a table. The system tables are accessed mostly from the BUFFER pool and Data Dictionary Cache. This should not afffect performance. Art S. Kagel

Related threads

Re: Another C UDR problem
Informix 10 permissions problem?
Posting from the Informix-list