Re: fragmented system tables

Posted in 1998

Art S. Kagel — Wed, 13 May 1998 16:26:17 -0400 — source: Informix-list mailing list archive (1991-1998)

Sven Tolkemit wrote: > > Hi people, > > we discovered, that the system tables (systables,sysindexes, etc.) on > our Online 7.23.UC1 are very fragmented. We think, this leads into > performance problems. Is there a way to defragment the tables? Definitive answer: NO! You cannot defragment the system tables and it WILL NOT affect performance. This is because all system table information is cached in the Data Dictionary Cache. However, if you have more than about 300 ACTIVE tables in all databases (run onstat -g dic to see the current state of the Data Dictionary) you may need to increase the size of the data dictionary cache. I posted instructions for doing this to someone yesterday and also back in March. Check the IIUG Archives. Art S. Kagel

Related threads

Posting from the Informix-list
Migrating from IDS 9.40.UC6 to 11.50.UC3
Ip for a network session
questions onstat -g