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

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