IIUG Software Repository Files

Subject: Help: Reducing Extents
From: John Clutterbuck <John.Clutterbuck@sbs.siemens.co.uk>
Newsgroups: comp.databases.informix
Date: Mon, 23 Jun 1997 17:45:37 +0100

> I am running a electronic document management system (EDMS) that uses
> Informix 7.22 as a back end to manage the documents.  The EDMS system
> warns me when there are database problems that slow performance.  In
> this case it warned me that there were too many extends for the tables
> listed below:
> 
> DBMS Tables With More Than 5 Extents
>  # of Extents          Type          Name
>            36         Table arrowdev:dm_sysobject_s
>            22         Table arrowdev:syscolumns
>            21         Table arrowdev:dmr_content_s
>            19         Table arrowdev:sysviews
>            17         Table arrowdev:dm_sysobject_r
>            15         Table arrowdev:dmr_content_r
>            14         Table arrowdev:dmi_object
>            12         Table arrowdev:dm_type_r
>             8         Table arrowdev:sysobjstate
>             7         Table arrowdev:dmi_queue_item_s
>             7         Table arrowdev:sysconstraints
>             6         Table sysmaster:syscolumns
> 
> How do I reduce the number of extents to improve performance??


Here is a perl script I use to defrag tables and the script it uses to
run the SQL under a transaction and only commit if no errors.

These are supplied without warrenty of any kind. If they are useful I am
glad. If they trash you're database, I or my company are not
responsible.

But please let me know of any bugs or improvements.
# John Clutterbuck               Tel: +44 1703 765021
# Siemens Business Services      email: jclutterbuck@sbs.siemens.co.uk
# Phi House, Enterprise Road
# Chilworth, Hampshire, SO16 7NS