Re: Cancelling an index build

["Al Barsa, Jr." <barsa2@xxxxxxx>]

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
+---