Oninit cdi / Archive
Talk to an expert →

consolidate extents

Posted in 2008

Topics: Storage & Space Management

emaus — — source: IIUG Forums & Mailing Lists

Hi all, - To consolidate the extents of the table: ALTER FRAGMENT ON TABLE name_table INIT IN name_dbspaces_new - To consolidate the extents of the indixes ALTER FRAGMENT ON INDEX name_index INIT IN name_dbspaces_new My query is to know the advantages and disadvantages of this syntax. It has some restrictions on use of this syntax. Thanks _________________________________________________________________ Ingresá ya a MSN en Concierto y disfrutá los recitales en vivo de tus artistas favoritos. http://msninconcert.msn.com/music/archive/es-la/archive.aspx

↪ replying to emaus
Art Kagel — — source: IIUG Forums & Mailing Lists

The disadvantage is the logical log usage that's required for the reorg. Art On Thu, Oct 30, 2008 at 4:57 PM, emaus <in4mixperu@hotmail.com> wrote: > Hi all, > > - To consolidate the extents of the table: > > ALTER FRAGMENT ON TABLE name_table INIT IN name_dbspaces_new> > - To consolidate the extents of the indixes > > ALTER FRAGMENT ON INDEX name_index INIT IN name_dbspaces_new> > My query is to know the advantages and disadvantages of this syntax. It has > some restrictions on use of this syntax. > > Thanks > > _________________________________________________________________ > Ingresá ya a MSN en Concierto y disfrutá los recitales en vivo de tus > artistas > favoritos. > http://msninconcert.msn.com/music/archive/es-la/archive.aspx > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.

↪ replying to Art Kagel
Jack Parker — — source: IIUG Forums & Mailing Lists

I'll second that. Big time. j. Sane ego te vocavi. Forsitan capedictum tuum desit. -----Original Message----- =46rom: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]On Behalf O= f Art Kagel Sent: Thursday, October 30, 2008 4:01 PM To: ids@iiug.org Subject: Re: consolidate extents [13861] The disadvantage is the logical log usage that's required for the reo= rg. Art On Thu, Oct 30, 2008 at 4:57 PM, emaus <in4mixperu@hotmail.com> wrote= : > Hi all, > > - To consolidate the extents of the table: > > ALTER FRAGMENT ON TABLE name_table INIT IN name_dbspaces_new> > - To consolidate the extents of the indixes > > ALTER FRAGMENT ON INDEX name_index INIT IN name_dbspaces_new> > My query is to know the advantages and disadvantages of this syntax= . It has > some restrictions on use of this syntax. > > Thanks > > _________________________________________________________________ > Ingres=E1 ya a MSN en Concierto y disfrut=E1 los recitales en vivo = de tus > artistas > favoritos. > http://msninconcert.msn.com/music/archive/es-la/archive.aspx > > > > *********************************************************************= ******* *** > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opini= ons and do not reflect on my employer, Oninit, the IIUG, nor any other organi= zation with which I am associated either explicitly or implicitly. Neither d= o those opinions reflect those of other individuals affiliated with any= entity with which I am affiliated nor those of the entities themselves. *********************************************************************= ******* *** Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Art Kagel
emaus — — source: IIUG Forums & Mailing Lists

It is possible to calculate the number of logical logs required to consolidate. I have IDS + HDR Thanks The freedom of Linux ... The power of Informix ---------------------------------------- > To: ids@iiug.org > From: art.kagel@gmail.com > Subject: Re: consolidate extents [13861] > Date: Thu, 30 Oct 2008 17:00:59 -0400 > > The disadvantage is the logical log usage that's required for the reorg. > > Art > > On Thu, Oct 30, 2008 at 4:57 PM, emaus wrote: > >> Hi all, >> >> - To consolidate the extents of the table: >> >> ALTER FRAGMENT ON TABLE name_table INIT IN name_dbspaces_new>> >> - To consolidate the extents of the indixes >> >> ALTER FRAGMENT ON INDEX name_index INIT IN name_dbspaces_new>> >> My query is to know the advantages and disadvantages of this syntax. It has >> some restrictions on use of this syntax. >> >> Thanks >> >> _________________________________________________________________ >> Ingresá ya a MSN en Concierto y disfrutá los recitales en vivo de tus >> artistas >> favoritos. >> http://msninconcert.msn.com/music/archive/es-la/archive.aspx >> >> >> >> > ******************************************************************************* >> Forum Note: Use "Reply" to post a response in the discussion forum. >> >> > > -- > Art S. Kagel > Oninit (www.oninit.com) > IIUG Board of Directors (art@iiug.org) > > Disclaimer: Please keep in mind that my own opinions are my own opinions and > do not reflect on my employer, Oninit, the IIUG, nor any other organization > with which I am associated either explicitly or implicitly. Neither do > those opinions reflect those of other individuals affiliated with any entity > with which I am affiliated nor those of the entities themselves. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > _________________________________________________________________ Descargá ya gratis y viví la experiencia Windows Live. http://www.descubrewindowslive.com/latam/index.html

↪ replying to Jack Parker
emaus — — source: IIUG Forums & Mailing Lists

It is possible to calculate the bug time required to consolidate. I have IDS + HDR Thanks The freedom of Linux ... The power of Informix ---------------------------------------- > To: ids@iiug.org > From: jack.parker4@verizon.net > Subject: RE: consolidate extents [13862] > Date: Thu, 30 Oct 2008 17:06:32 -0400 > > I'll second that. Big time. > > j. > > Sane ego te vocavi. Forsitan capedictum tuum desit. > > -----Original Message----- > =46rom: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]On Behalf O= > f Art > Kagel > Sent: Thursday, October 30, 2008 4:01 PM > To: ids@iiug.org > Subject: Re: consolidate extents [13861] > > The disadvantage is the logical log usage that's required for the reo= > rg. > > Art > > On Thu, Oct 30, 2008 at 4:57 PM, emaus wrote= > : > >> Hi all, >> >> - To consolidate the extents of the table: >> >> ALTER FRAGMENT ON TABLE name_table INIT IN name_dbspaces_new>> >> - To consolidate the extents of the indixes >> >> ALTER FRAGMENT ON INDEX name_index INIT IN name_dbspaces_new>> >> My query is to know the advantages and disadvantages of this syntax= > .. It > has >> some restrictions on use of this syntax. >> >> Thanks >> >> _________________________________________________________________ >> Ingres=E1 ya a MSN en Concierto y disfrut=E1 los recitales en vivo = > de tus >> artistas >> favoritos. >> http://msninconcert.msn.com/music/archive/es-la/archive.aspx >> >> >> >> > *********************************************************************= > ******* > *** >> Forum Note: Use "Reply" to post a response in the discussion forum. >> >> > > -- > Art S. Kagel > Oninit (www.oninit.com) > IIUG Board of Directors (art@iiug.org) > > Disclaimer: Please keep in mind that my own opinions are my own opini= > ons and > do not reflect on my employer, Oninit, the IIUG, nor any other organi= > zation > with which I am associated either explicitly or implicitly. Neither d= > o > those opinions reflect those of other individuals affiliated with any= > entity > with which I am affiliated nor those of the entities themselves. > > *********************************************************************= > ******* > *** > Forum Note: Use "Reply" to post a response in the discussion forum. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > _________________________________________________________________ Ingresá ya a MSN Deportes y enterate de las últimas novedades del mundo deportivo. http://msn.foxsports.com/fslasc/

Related threads

Glossary