Oh, yes it does. My first problem though is just to calculate the current size (for the upgrade), and then off course leave space for growth.

But I have a lot to work with now, thanks to everyone.


Dirk

-----Original Message-----
From: Gorazd Hribar Rajteriè [mailto:REMOVE_gorazd.hribar@telekom.si]
Sent: Tuesday, October 07, 2003 4:56 PM
To: informix-list@iiug.org
Subject: Re: Upgrading from 7.31 to 9.3 - storage requirements

Doesn't your database grow? I would take your assumption and estimate growth
rate for lets say 6 months...

Gorazd

"Dirk Moolman" <DirkM@mxgroup.co.za> wrote in message
news:bluc7m$25m$1@terabinaries.xmission.com...
>
> Or if I can put it another way -
>
> am I correct in assuming I can calculate this by
>
> 1. calculating the table sizes (rowsize * nrows) ... if update statistics
is up to date, and then
> 2. add to that (index size + 4) * nrows, for each index
>
> Will this be close enough ?
>
>
> -----Original Message-----
> From: Dirk Moolman
> Sent: Tuesday, October 07, 2003 10:36 AM
> To: informix-list@iiug.org
> Subject: FW: Upgrading from 7.31 to 9.3 - storage requirements
>
> Anyone ?
>
> -----Original Message-----
> From: Dirk Moolman
> Sent: Wednesday, October 04, 2003 10:38 AM
> To: informix-list@iiug.org
> Subject: Upgrading from 7.31 to 9.3 - storage requirements
>
> I know that the indexes are detached in version 9, so upgrading from 7 to
9 will require more storage.
>
> Question: Does anyone have a query I can use that will calculate my
storage requirements for the upgrade ?
>
>
>
>
> sending to informix-list
>
> sending to informix-list
>
> sending to informix-list


sending to informix-list