db2 reorg indexes all for table vlsdbo.temp_ctl (stop pause start)

NOTICE TO RECIPIENT: If you are not the intended recipient of this
e-mail, you are prohibited from sharing, copying, or otherwise using or
disclosing its contents. If you have received this e-mail in error,
please notify the sender immediately by reply e-mail and permanently
delete this e-mail and any attachments without reading, forwarding or
saving them. Thank you.




"MacIntyre Allison "
<db2udbdba-ezmlmshield-x38977028.[Email address protected]
10/24/2007 10:38 AM

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
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.


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



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