Archives of the TeradataForum
Message Posted: Mon, 23 Aug 1999 @ 23:53:09 GMT
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.
Kenneth Stiglich M.
Kenneth Stiglich M
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|