470,816 Members | 1,204 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,816 developers. It's quick & easy.

DB2 UDB V8 inplace reorg

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
Nov 12 '05 #1
1 5157
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

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

27 posts views Thread by Raquel | last post: by
1 post views Thread by hikums | last post: by
16 posts views Thread by andy.standley | last post: by
reply views Thread by Roger | last post: by
reply views Thread by mvsmsh | last post: by
reply views Thread by mvsmsh | last post: by
reply views Thread by mihailmihai484 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.