Re: Fragmented Table

Posted in 1997

Leo_Chen@usc.com.tw — 29 Jan 1997 07:38:10 -0500 — source: Informix-list mailing list archive (1991-1998)

Hello Burton : try this : 1. export the database with those spls 2. drop database 3. alter the next size of sysprocbody & sysprocplan by sql statement ( not by dbaccess's menu screen) 4. import the database again Hope it helps!! leo I have recently taken over a project with over 300 stored procedures. Because of this, sysprocbody and sysprocplan are tremendoulsy interleaved/fragmented. Is there a way to correct this? I wasn't sure about running index clustering or dropping and re-creating system tables. TIA Chris Burton cburton@gte.net