 |
 |
Archives of the TeradataForum
Message Posted: Mon, 23 Aug 1999 @ 23:53:09 GMT
| Subj: | | How to stop or avoid Rollback or recovery process |
| |
| From: | | Kenneth Stiglich |
A lot of times I have been in problems because some development people send wrong queries that take a lot of resources and time,
and after a few time the programmer discover that his query is wrong. At this point we stop the query but the machine starts an
automatic rollback, and we don't have any way to stop the rollback. Do you know if there is a way to stop a rollback, considering
that maybe the last table will be garbage data and you don't need to wait 8 hours rollback or more because you really don't need that
data.
I restarted the machine and the aborting process change to be a recovery process, but It's still consuming the same processor
resources.
Regards,
Kenneth Stiglich M.
Kenneth Stiglich M
Serv. Data WareHouse
Ingenieria de la Información
| |
