Re: systabauth fragmentation

>From: uunet!lexmark.com!CJSENFT >Subject: systabauth fragmentation >Date: Thu, 1 Jul 1993 19:34:53 GMT >X-Informix-List-Id: <news.3720> >In one of my databases the systabauth table is fragmented into 10 >segments. What's the best way to fix a system table when this happens. >I usually unload the table, recreate it and reload. But, I'm afraid >to try anything like this with a system table. (1) It probably doesn't matter. That is to say, the 8 extent limit makes a marginal difference to performance, but the difference is going to be small bits of a tenth of a percent. (2) You can set next extent size on a system table: ALTER TABLE Systabauth MODIFY NEXT SIZE 64; (3) You won't be able to rebuild any system table short of dropping the database and rebuilding it. Yours, Jonathan Leffler (johnl@obelix.informix.com) #include <disclaimer.h>