Thanks a lot. I have Redhat ES 3, IDS 9.40 UC 7
I will consider your suggestions. Right now we're not that bad and can
afford a little downtime.
On Tue, May 20, 2008 at 4:08 PM, Art Kagel <art.kagel@[EMAIL PROTECTED]
> wrote:
> You would:
>
> dbaccess mydatabase -
>> unload to 'mytable_unload.unl' select * from mytable;
>> truncate table mytable;
>> load from 'mytable_unload.unl' insert in to mytable;
>> ^D
>> ^D
>
> The truncate will only work if you have a later version of Informix that
> sup****ts that command (it's a VERY good idea to always post your version
and
> platform information when you post). If not, you'll have to exit
dbaccess,
> run a 'dbschema -d mydatabase -t mytable -ss mytable.sql' to get a
schema of
> the table, drop it, recreate it with the schema, possibly recreate
foreign
> keys on other tables that reference 'mytable', and then reload the data.
> (FYI - you can use my dbschema replacement utility, myschema, with its
-F
> option that also outputs those referencing foreign keys - dbschema won't
do
> it! Myschema is part of the package utils2_ak which you can download
from
> the IIUG Software Repository or the Oninit WEB Site - www.oninit.com)
>
> or you can reload the file using dbload which may avoid long transaction
and
> lock table overflow problems if the table is large.
>
> You may want to increase the table's NEXT SIZE to reduce future
> fragmentation.
>
> However, the best (and usually fastest) way to reorg a fragmented table
is
> to use:
>
> ALTER FRAGMENT ON mytable INIT IN some_dbspace;
>
> The named dbspace can be the same one the table already lives in or a
> different one (or even a fragmentation expression). This command only
needs
> sufficient logical log space to avoid a long transaction rollback and
all
> indexes and constraints remain in place during and after the reorg.
>
> Have you checked that the table is badly fragmented first? Unless the
table
> has several dozen fragments, it is unlikely that fragmentation is having
a
> major performance impact. If you are having severe performance problems
> then it is more likely that your engine is not properly configured or
tuned
> for your applications. I would recommend that you contact one of the
> several excellent consultancies that work with Informix users for a
> comprehensive server health check. I will shamelessly mention Oninit,
the
> consultancy I work for, as one, but there are several others out there
that
> a GOOGLE search for 'Informix consultant' will reveal. I only avoid
naming
> them 'cause I'm getting old and if I forget one I'll insult some good
friend
> or other. 8^)
>
> Art S. Kagel
> Oninit
>
> On Tue, May 20, 2008 at 3:38 PM, Gentian Hila <genti.tech@[EMAIL PROTECTED]
>
wrote:
>>
>> I was told that to improve performance sometimes is a good idea to
>> ex****t and im****t a table instead of sizing it (it's easier I've been
>> told)
>>
>> How do I ex****t/im****t table in IDS 9.40? (table not database)
>>
>> Thanks
>> _______________________________________________
>> Informix-list mailing list
>> Informix-list@[EMAIL PROTECTED]
>> http://www.iiug.org/mailman/listinfo/informix-list
>
>
|
