Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2003

    Question Unanswered: How to check informix DB

    Dear All,

    I'm using baan application on informix db. I would like to know that how do I measure and key indicators that this database need to be reorg or not?


  2. #2
    Join Date
    Aug 2002
    Informix databases usually don't need to be reorganized. Unlike Oracle, informix does reuse free space, caused by deletions.
    The only reason why you should reorg your tables in Informix is that you chose a wrong extent size for your table.
    Chek the number of extents allocated to a table in the sysptnhdr table in the sysmaster database.
    The partnumber can be joined with the sysptprof table to get the exact table name.
    the nextns column displays the number of extents.
    For a 2K page size 200 extents is really alarming.
    best to keep under 20 extents.

  3. #3
    Join Date
    Mar 2003
    I'm also come from Baan/Informix side.
    I think that the best way for you to reorganize the tables/indexes is to export & import the company data using bdbpre & bdbpost utilities. If you have large extents you may need to adjust your inf_storage file to change your tables extents initial and next size.

Posting Permissions

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