Archives of the TeradataForum

Message Posted: Tue, 11 May 2004 @ 19:44:30 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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.

Bill H

P.S. I had a table that took 3 days to rollback.

	<Prev	Next>		<<First	<Prev	Next>	Last>>