Re: Help: Reducing Extents
In article <33A1B178.5CB7@arrowintl.com>, Chad Laity
<chad_laity@arrowintl.com> writes
>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??
>
>Thanks,
>Chad Laity
>chad_laity@arrowintl.com
>wick@fast.net
Use dbexport and dbimport to export/import the database.
You will need exclusive access to the database whilst you do this.
--
David Williams