At 10:40 AM 7/1/99 -0500, you wrote:

An index build is accomplished by one machine instruction, so it cannot be 
interrupted.  Even a normal ENDJOB will not kill it, the index build will 
complete, and then the job will die.  You can do an ENDJOBABN, but this has 
to be initiated 10 minutes after a preceding ENDJOB, and I'm not positive 
that this will kill it either.

Al


>Scenario:
>We have several sales files that have a join logical
>built over them. Some of these sales files are
>quite large. A programmer inserted some code in
>the nightly processing CLP to re-org one of the
>smaller sales related files in this join logical. This
>is causing the access path of the large file to be
>re-built. Due to the size, this will take a few hours.
>The CL is quite large and has an environment that
>is quite hard to duplicate. This includes temp files
>and>
>Does anyone know of a way to cancel the index
>build without ending the job doing the build?
>
>Joe>
>>| This is the Midrange System Mailing List!
>| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
>| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
>| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
>| Questions should be directed to the list owner/operator: david@midrange.com
>+--


+--------------------------------------------------+
| Please do not send private mail to this address. |
| Private mail should go to barsa@ibm.net.         |
+--------------------------------------------------+

Al Barsa, Jr. - Account for Midrange-L
Barsa Consulting, LLC.  
400
Phone:  914-251-1234
Fax:            914-251-9406
http://www.barsaconsulting.com
http://www.taatool.com

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---


This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact [javascript protected email address].