5.x to 11.70 migration disk usage increase
anybody know just how much disk space increase I should expect on a migration(rebuild) of our clients 5.x instance to 11.70 64 bit ? Currently they have three databases using about 14 gigs spread out over 9 dbspaces, two of which are blobspaces. AIX 6.1 just need a rough guage as I need to provide an estimate up front on increased disk space needed. The instance has about 40% of its disk space currently free across all dbspaces exception being the critical dbspaces. Thanks, Mark
That should be plenty. Index keys will increase by 4bytes each and the internal rules about when to split an index node will be different than in 5.xx. Also, 5.xx had attached indexes only. Version 11's detached indexes will allocate independent extents which by default will be sized according to the ratio of the rowsize to the key length multiplied by the existing extent size of the table. In 11.70 you can control the extent sizing of the indexes independently, but you will need to size the extents of the tables and indexes intelligently. The existing table extents include space for index pages which will not be in those extents in 11.xx. If you don't do the calculations, empty extent space allocated to the tables may suck up space needed by index extents. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Sep 1, 2011 at 4:27 PM, MARK JALKIEWICZ <mark.jalkiewicz@verizon.net > wrote: > anybody know just how much disk space increase I should expect on a > migration(rebuild) of our clients 5.x instance to 11.70 64 bit ? Currently > they have three databases using about 14 gigs spread out over 9 dbspaces, > two > of which are blobspaces. > > AIX 6.1 > > just need a rough guage as I need to provide an estimate up front on > increased > disk space needed. The instance has about 40% of its disk space currently > free > across all dbspaces exception being the critical dbspaces. > > Thanks, > > Mark > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --90e6ba21241d20f03f04abe76a43
Don't forget about the system databases which will be created as well. |------------> | From: | |------------> >--------------------------------------------------------------------= -----------------------------------------------------------------------= -------| |"Art Kagel" <art.kagel@gmail.com> = = | >--------------------------------------------------------------------= -----------------------------------------------------------------------= -------| |------------> | To: | |------------> >--------------------------------------------------------------------= -----------------------------------------------------------------------= -------| |ids@iiug.org = = | >--------------------------------------------------------------------= -----------------------------------------------------------------------= -------| |------------> | Date: | |------------> >--------------------------------------------------------------------= -----------------------------------------------------------------------= -------| |09/01/2011 03:52 PM = = | >--------------------------------------------------------------------= -----------------------------------------------------------------------= -------| |------------> | Subject: | |------------> >--------------------------------------------------------------------= -----------------------------------------------------------------------= -------| |Re: 5.x to 11.70 migration disk usage increase [24833] = = | >--------------------------------------------------------------------= -----------------------------------------------------------------------= -------| |------------> | Sent by: | |------------> >--------------------------------------------------------------------= -----------------------------------------------------------------------= -------| |ids-bounces@iiug.org = = | >--------------------------------------------------------------------= -----------------------------------------------------------------------= -------| That should be plenty. Index keys will increase by 4bytes each and the internal rules about when to split an index node will be different than= in 5.xx. Also, 5.xx had attached indexes only. Version 11's detached index= es will allocate independent extents which by default will be sized accord= ing to the ratio of the rowsize to the key length multiplied by the existin= g extent size of the table. In 11.70 you can control the extent sizing of= the indexes independently, but you will need to size the extents of the tab= les and indexes intelligently. The existing table extents include space for= index pages which will not be in those extents in 11.xx. If you don't d= o the calculations, empty extent space allocated to the tables may suck u= p space needed by index extents. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinion= s and do not reflect on my employer, Advanced DataTools, the IIUG, nor any ot= her organization with which I am associated either explicitly, implicitly, = or by inference. Neither do those opinions reflect those of other individuals= affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Sep 1, 2011 at 4:27 PM, MARK JALKIEWICZ <mark.jalkiewicz@verizon.net > wrote: > anybody know just how much disk space increase I should expect on a > migration(rebuild) of our clients 5.x instance to 11.70 64 bit ? Currently > they have three databases using about 14 gigs spread out over 9 dbspa= ces, > two > of which are blobspaces. > > AIX 6.1 > > just need a rough guage as I need to provide an estimate up front on > increased > disk space needed. The instance has about 40% of its disk space curre= ntly > free > across all dbspaces exception being the critical dbspaces. > > Thanks, > > Mark > > > > ***********************************************************************= ******** > Forum Note: Use "Reply" to post a response in the discussion forum. > > --90e6ba21241d20f03f04abe76a43 ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =
Indeed, there are three new system databases which will reside in the rootdb dbspace. They are not large, but may require you to increase your rootdb space a bit. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Fri, Sep 2, 2011 at 9:02 AM, Madison Pruet <mpruet@us.ibm.com> wrote: > Don't forget about the system databases which will be created as well. > > |------------> > | From: | > |------------> > >--------------------------------------------------------------------= > -----------------------------------------------------------------------= > -------| > |"Art Kagel" <art.kagel@gmail.com> = > > = > > | > >--------------------------------------------------------------------= > -----------------------------------------------------------------------= > -------| > |------------> > | To: | > |------------> > >--------------------------------------------------------------------= > -----------------------------------------------------------------------= > -------| > |ids@iiug.org = > > = > > | > >--------------------------------------------------------------------= > -----------------------------------------------------------------------= > -------| > |------------> > | Date: | > |------------> > >--------------------------------------------------------------------= > -----------------------------------------------------------------------= > -------| > |09/01/2011 03:52 PM = > > = > > | > >--------------------------------------------------------------------= > -----------------------------------------------------------------------= > -------| > |------------> > | Subject: | > |------------> > >--------------------------------------------------------------------= > -----------------------------------------------------------------------= > -------| > |Re: 5.x to 11.70 migration disk usage increase [24833] = > > = > > | > >--------------------------------------------------------------------= > -----------------------------------------------------------------------= > -------| > |------------> > | Sent by: | > |------------> > >--------------------------------------------------------------------= > -----------------------------------------------------------------------= > -------| > |ids-bounces@iiug.org = > > = > > | > >--------------------------------------------------------------------= > -----------------------------------------------------------------------= > -------| > > That should be plenty. Index keys will increase by 4bytes each and the > internal rules about when to split an index node will be different than= > in > 5.xx. Also, 5.xx had attached indexes only. Version 11's detached index= > es > will allocate independent extents which by default will be sized accord= > ing > to the ratio of the rowsize to the key length multiplied by the existin= > g > extent size of the table. In 11.70 you can control the extent sizing of= > the > > indexes independently, but you will need to size the extents of the tab= > les > and indexes intelligently. The existing table extents include space for= > > index pages which will not be in those extents in 11.xx. If you don't d= > o > the calculations, empty extent space allocated to the tables may suck u= > p > space needed by index extents. > > Art > > Art S. Kagel > Advanced DataTools (www.advancedatatools.com) > Blog: http://informix-myview.blogspot.com/ > > Disclaimer: Please keep in mind that my own opinions are my own opinion= > s > and > do not reflect on my employer, Advanced DataTools, the IIUG, nor any ot= > her > organization with which I am associated either explicitly, implicitly, = > or > by > inference. Neither do those opinions reflect those of other individuals= > > affiliated with any entity with which I am affiliated nor those of the > entities themselves. > > On Thu, Sep 1, 2011 at 4:27 PM, MARK JALKIEWICZ > <mark.jalkiewicz@verizon.net > > wrote: > > > anybody know just how much disk space increase I should expect on a > > migration(rebuild) of our clients 5.x instance to 11.70 64 bit ? > Currently > > they have three databases using about 14 gigs spread out over 9 dbspa= > ces, > > > two > > of which are blobspaces. > > > > AIX 6.1 > > > > just need a rough guage as I need to provide an estimate up front on > > increased > > disk space needed. The instance has about 40% of its disk space curre= > ntly > > > free > > across all dbspaces exception being the critical dbspaces. > > > > Thanks, > > > > Mark > > > > > > > > > ***********************************************************************= > ******** > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --90e6ba21241d20f03f04abe76a43 > > ***********************************************************************= > ******** > > Forum Note: Use "Reply" to post a response in the discussion forum. > > = > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --90e6ba6e84400ed01904abf50222