Re: 511 error

Well, I need to correct myself. You CAN modify the NEXT SIZE for a system table. Problem is when you find out you already have 200+ extents that it's pretty much too late. -Bill } } Hi, } } sysobjstate is a system table created by informix. Informix } doesn't seem to permit altering these tables. } } I have seen several other system tables violate the extent } guidelines(less than 8). I don't believe there is anything you } can do about it. I've tried altering extent sizes and } altering indexes to cluster. } } I understand that Informix does not have the information to size } the system tables since they depend on user defined databases. } But it would be nice if we could at least modify the NEXT SIZE } of these tables for extents. } } -Bill } > } > Hi all: } > } > I am trying to do an "alter index objdesc to cluster" in order to fix } > sysobjstate in my database which is upto 200+ extents... } > } > How can I fix this? } > } > } > * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * } > } > } } } -- } Bill Ennis Voice: 312-474-7516 } SSA Fax: 312-474-7460 } 500 W. Madison email: ennis@ssax.com ennis@accesschicago.net -- Bill Ennis Voice: 312-474-7516 SSA Fax: 312-474-7460 500 W. Madison email: ennis@ssax.com ennis@accesschicago.net