Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    11

    Unanswered: Defragmenting the system tables

    Hi,

    Some of the system tables is taking more extetns (14 extents). Is there any way to defragment these system tables.

    informix.sysprocplan
    informix.sysprocbody
    informix.syscolumns


    Thanks

  2. #2
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    You can't defragment system tables. Best way i sto alter their next extent size with the 'ALTER TABLE' statement.
    rws

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •