Production issue - reorging index affecting system performance

Production issue - reorging index affecting system performance

 

  

Hi,

We kicked of an index reorg last night and it is still running. We
issued:

db2 reorg indexes all for table vlsdbo.temp_ctl allow write access

This is affecting system performance. Any clean way to stop/pause this
index reorg?

Allison



-----------------------------------------
This email may contain confidential and privileged material for the
sole use of the intended recipient(s). Any review, use, retention,
distribution or disclosure by others is strictly prohibited. If you
are not the intended recipient (or authorized to receive for the
recipient), please contact the sender by reply email and delete all
copies of this message. Also, email is susceptible to data
corruption, interception, tampering, unauthorized amendment and
viruses. We only send and receive emails on the basis that we are
not liable for any such corruption, interception, tampering,
amendment or viruses or any consequence thereof.

DB2 & UDB email list listserv db2-l LazyDBA home page