RE: Upgrading from 7.31 to 9.3 - storage requirements

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