SEO

#1 (**permalink**) 04-20-2008, 08:31 AM

Greetings all,

Before I start digging into this, I want to check and see if this
is a known issue.

I am setting up a new 9.40.FC6 on AIX 5.2.0 on an H80. I have
a small database that we use on our current setup, which is an IDS
7.31.UC7 on AIX 4.3.3 on an identical H80, that I use for testing.

Basically, I used my existing onconfig from the 7.31 IDS as a
starting onconfig for the 9.40 IDS. Everything appears to work
just fine except the dbexport of this small (3.5 Meg) database.
It takes over 6 minutes to export the database, yet it takes only
20 seconds for the dbimport. Normally, I would expect these times
to be the other way around.

On my current system, the dbexport takes under 1 minute and the
dbimport take about 2 minutes, which has been fairly consistent
and seems rather normal.

Any ideas on why the 9.40 dbexport takes so long while the
dbimport runs so much faster?

Thanks in advance,

Tom

#2 (**permalink**) 04-20-2008, 08:31 AM

I ran into the exact same problem. You probably have a table with
<byte> data type. This will slow the export down. I called TS and
they confirmed this.

FYI

#3 (**permalink**) 04-20-2008, 08:31 AM

There are also some slow index build issues if the box does not have
enough memory for sorts. I do not know if that is what you are running
into, but we did. 9.4 seems to want more memory than 7.31 almost
everywhere.

Sincerely,

Christopher Coleman

President
Kansas City Informix Users Group
www.iiug.org/kciug

Database Analyst
Medication Management
Mediware Information Systems, Inc.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Slow dbexport