"rdudejr" <rd*****@gmail.comwrote in message
news:11**********************@h48g2000cwc.googlegr oups.com...
Hi all,
Ive got a script Ive built which runs reorgs on all tables needing it
based on output of reorgchk. The reorgs are ran inline. This past
weekend, the reorgs were running against 450 tables on a database that
is about 250 GB in size. The reorgs took all weekend and bled into
the week. Ultimately they did not finish. Where should I start
looking to speed this up? Thanks
rdudejr
What is an "inline" reorg? There are regular and on-line reorgs. A script
that runs a regular reorg does so sequentially, one table at a time. A
script that does an on-line reorg does it asynchronously, starting the next
reorg before the last reorg has finished. That has implications regarding
the amount work space needed for the reorgs if they are done simultaneously.
A reorg needs lots work space to run efficiently, either free space in the
tablespace where the table and indexes are located, or in a system temporary
tablespace if you specify that it be used for the reorg (see the REORG
command).