On Jul 10, 11:33=A0am, Ian <ianb...@[EMAIL PROTECTED]
> wrote:
> jane wrote:
> > Hi,
>
> > Just wondering, is there any way to do theonlinereorgto use
> >tem****arytablespaceinstead oftablespacetable existed.
>
> > since that is really a waste to have some space allocated aside only
> > for theonlinereorg..
>
> > I know offlinereorgcould usetem****arytablespace..is that so
> > difficult to add this feature toonlinereorg?
>
> > maybe had some reason ..
>
> You're misunderstanding the key difference between offline and
inplacereo=
rg.
>
> Offlinereorgcreates a copy of the *entire* table, and then drops the
> old copy of the table. =A0If you don't have enough space in the
originalt=
ablespaceto create this copy (or are really concerned about
thetablespaceHW=
M) you can tell the offlinereorgto build a copy in atem****arytablespace. =
=A0When it does this, it builds the copy in the
> temptablespace, drops the original table, and then copies the data
> from the temptablespaceback to the original datatablespace.
>
> Foronline(a.k.a. inplace)reorg, DB2 does the cleanup a page at a
> time. =A0So instead of having overhead of 2*table size, you only have
> a few extra pages overhead. =A0Therefore, it makes no sense to use
atempo=
rarytablespacefor an inplacereorg.- Hide quoted text -
>
> - Show quoted text -
Thanks for your reply..
but I'm still not quite understand the reorg inplace..
let's say even one extent at a time, it would not cause my tablespace
full if we do reorg online in the tablespace..but why I keep on
getting tablespace full message .. it seems more safer if I had
tablespace 50% free to do the online reorg...
|
