|
|
Archives of the TeradataForum
Message Posted: Fri, 09 Mar 2001 @ 07:37:22 GMT
Subj: | | Re: Abort Session from BTEQ |
|
From: | | Mike Philips |
Hi all,
A further question re the vexing problem of the possibility of aborting ROLLBACKing sessions...
Is there any way to determine/estimate the proportion completed? (I have an insert/select that was killed, but the ratio of rollback
time to expected normal completion time is now of the order of 30 (i.e. 60 hr / 2 hr). In this case, the select was admittedly a fairly
complex SQL construct using derived tables etc.)
Many thanks
Mike Philips
| |