Installation / Migration on Linux with 9.4 (large chunks)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tbarth@barth-rz.de - 22 Apr 2004 08:43 GMT

Hi,

I have a question regarding IDS 9.4.
Using our current 7.31 we have 2 gig chunks for the db. Now we plan to move
to
9.4. How can we migrate the system from 2 gig to 8 gig chunks, convert and
use again without problems. Any guidelines available ? Any advice ?
Thanks in advance !

Mit freundlichen Gr??en

Torsten Barth

Certified Solution Consultant mySAP SCM (OF)
---------------------------------------------------------------------------------------------------------

Barth Rechenzentrum + Systemhaus GmbH & Co. KG
Organisation & SW-Entwicklung
M?hleneschweg 5
D- 49090 Osnabr?ck
Telefon +49 541 609 10 - 88
Telefax +49 541 609 10 - 89
mailto: tbarth@barth-rz.de

sending to informix-list

Reply to this Message

Jonathan Leffler - 30 Apr 2004 07:54 GMT

> I have a question regarding IDS 9.4. Using our current 7.31 we have
> 2 gig chunks for the db. Now we plan to move to 9.4. How can we
> migrate the system from 2 gig to 8 gig chunks, convert and use
> again without problems. Any guidelines available? Any advice?

I've not seen any responses...

It depends on your requirements. If chunk 0 of your root dbspace must
also be resized, you are looking at a complete unload and reload of
the system, I think. Assuming you aren't 100% fanatical about
increasing the size of chunk 0 of the root dbspace, then you can add
the new large chunks, migrate the data into them (alter fragment), and
then drop the old ones. If the new big chunks must be built on disk
space already occupied by 'small' (2GB) chunks, then I think you are
back to unload and reload operations -- you need enough spare space to
copy the data around.

Signature

Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/

Reply to this Message