DB2 UDB V8 inplace reorg

[Anna Hutter]

Hello,

this question is about DB2 UDB V8 and its inplace reorganisation.
It seems that in small tables, an inplace reorg doesn´t start. Is
there a limit in size of a table when a reorg starts? How can I be
sure that a reorg has successfully finished?

I found three methods to watch if an asynchronous reorg has finished:
a) db2 "select * from table(sysproc.snapshot_tbreorg('reo_test',0))
as t"
b) db2 get snapshot for tables on reo_test
c) db2 list history reorg all for db reo_test

Now I´ve started a reorg on a table but I can´t find out if this reorg
has finished although it tells me the reorg has started:

DB20000I The REORG command completed successfully.
DB21024I This command is asynchronous and may not be effective
immediately.
TIA
Anna

[Sean McKeough]

Hi Anna,

Yes, the reorg will not run on tables that are less than 3 pages in
size. I think something is put to the history file when this happens.

Anna Hutter wrote:

Hello,

this question is about DB2 UDB V8 and its inplace reorganisation.
It seems that in small tables, an inplace reorg doesn´t start. Is
there a limit in size of a table when a reorg starts? How can I be
sure that a reorg has successfully finished?

I found three methods to watch if an asynchronous reorg has finished:
a) db2 "select * from table(sysproc.snapshot_tbreorg('reo_test',0))
as t"
b) db2 get snapshot for tables on reo_test
c) db2 list history reorg all for db reo_test

Now I´ve started a reorg on a table but I can´t find out if this reorg
has finished although it tells me the reorg has started:

DB20000I The REORG command completed successfully.
DB21024I This command is asynchronous and may not be effective
immediately.
TIA
Anna