Re: fragmented system tables

Volker Fraenkle wrote: > > Sven Tolkemit schrieb: > > > > 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? > > > > Thanks for answer! > > > > Sven > > Yes, there is. You have to unload and drop the tables. After, you can > create it with "first size" and "next size" (to prevent your tables from > high fragmentation) and load the tables. > > Note: At creating a table, the default lock level is "page". > > If there is enough space on the disk you can unload and load a complete > database with "dbexport"/"dbimport". Maybe, it works with tapes, too (I > know, it "works" with tapes, but depending on the size of db, it is > verry slow). Unless something has changed, should you do this with system tables? I've never tried to drop and recreate a system table before. Last I heard, this is a big no-no. John Carlson Informix DBA WH Smith, Inc.