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 ?
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 ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
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.
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.
ASKER
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).
ASKER
ok, thanks
ASKER
Anything is check the size of the log ?