Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Dear all,
Perhaps this Q&A has been posted earlier, but i do
appreciate that if someone could explain again here...
After the dbexport-import exercise, the archive only
took 20 minutes to complete the backup. After few
weeks down the road, the archive started to experience
slowness and now it took more than 5 hours to complete
the entire backup. In term of data and space
utilization, there's only ~400 MB increased since the
last dbeport-import.
onstat -d
==========Chunks
address chk/dbs offset size free bpages
flags pathname
5a51e1f8 1 1 0 50000 45893
PO- /dev/db15
5a51e814 2 2 0 200000 179947
PO- /dev/db1
5a51e8f0 3 3 250000 200000 2947
PO- /dev/db1
5a51e9cc 4 4 0 350000 348615
PO- /dev/db2
5a51eaa8 5 5 0 350000 348853
PO- /dev/db3
5a51eb84 6 6 0 350000 348685
PO- /dev/db4
5a51ec60 7 7 0 1000000 4
PO- /dev/db5
5a51ed3c 8 7 0 1000000 0
PO- /dev/db6
5a51ee18 9 7 0 1000000 2
PO- /dev/db7
5a51eef4 10 7 0 1000000 6
PO- /dev/db8
5a51efd0 11 7 0 1000000 1
PO- /dev/db9
5a51f0ac 12 7 0 1000000 91051
PO- /dev/db10
5a51f188 13 7 0 1000000 634384
PO- /dev/db11
5a51f264 14 7 0 1000000 999997
PO- /dev/db12
14 active, 2047 maximum
What factors that cause the archive become slow? Your
reply is highly appreciated.
Thanks & regards,
miyaki
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
sending to informix-list
miyaki wrote:
> After the dbexport-import exercise, the archive only
> took 20 minutes to complete the backup. After few
> weeks down the road, the archive started to experience
> slowness and now it took more than 5 hours to complete
> the entire backup. In term of data and space
> utilization, there's only ~400 MB increased since the
> last dbeport-import.
>
> onstat -d
> ==========
[...snip...]>
> What factors that cause the archive become slow? Your
> reply is highly appreciated.
What version of IDS? What platform? Without that, we're guessing.
With that, there might be an easy explanation, or there might not.
--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.