Archives of the TeradataForum
Message Posted: Tue, 11 May 2004 @ 19:44:30 GMT
If you know how mush perm space the table had before the transaction started, you can use dbc.tablesize to see how much current perm is being used vs the final perm. You can use periodic size change to see how fast the base table is growing for an estimate of remaining time.
Rule of thumb, it takes 3 times longer to rollback then transaction processing. This will increase based on the number of NUSI's on the base table.
P.S. I had a table that took 3 days to rollback.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|