Link to home
Start Free TrialLog in
Avatar of marrowyung
marrowyung

asked on

reorg indexes and reorg table for DB2 V8.1

Dear all,

is the use of reorg table  and reorg indexes  for DB2 V8.1 only for reclaim disk space only? what else?

1) will this command give trouble?

reorg indexes all for table ROOT.T595

reorg table ROOT.T595 inplace allow write access

2) can I do reorg indexes all for table ROOT.T595 inplace allow write access ?

so that I reorg/rebuilt index online ?
Avatar of marrowyung
marrowyung

ASKER

it seems that  reorgs generate a lot of transaction log, however must be logged, so there is no way to reduce or predict amount of logging to be done .

Anything is check the size of the log ?
ASKER CERTIFIED SOLUTION
Avatar of Kent Olsen
Kent Olsen
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ok, but you can brief what is the main different between them ? what use is it?

I will read that later on as I am trying to solve some urgent problem.

someone said online reorg is much better, hard to believe.
Online REORG keeps the database up while the REORG runs.  Offline REORG requires that the database be offline or quiesced.  (Maybe just a full table lock.  I don't remember.)

If you can tolerate the database being unavailable for some period, use the offline reorg.  If you need to keep the database up, use the online reorg, though it might slow down database queries.
basically reorg index first or reorg table first?
Table.  Reorganizing the table moves data around within the table.  Do that, then reorganize the index(es).
ok, thanks