By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,812 Members | 875 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,812 IT Pros & Developers. It's quick & easy.

DB2 UDB V8 inplace reorg

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.