Archives of the TeradataForum
Message Posted: Thu, 01 Aug 2002 @ 19:23:58 GMT
| Subj: || || Re: Rollback on long-running update |
| From: || || David R. Stoolman |
An ER or Enhancement Request is in place to Kill a Killer Rollback. I believe NCR is planning on providing that feature in 5.0 or 5.1.
Yes in most of our pasts a stupid situation gets going, then cancelled and the rollback runs many times the time it ran forward. Killing a
killer rollback will leave you with an empty table that you must recover yourself.
But maybe you can recover the table in 1-2 hours , where the rollback may take 20 - 30 times that much! You will have a choice with that