consolidate extents
Emaus asked about the pros and cons of ALTER FRAGMENT ON TABLE or INDEX ... INIT IN to consolidate extents. Art Kagel said the disadvantage is the heavy logical log usage, and Jack Parker agreed strongly. Emaus, running IDS with HDR, asked whether the number of logs and the time required can be calculated. No answer in the thread.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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
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.
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.
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
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/