Archives of the TeradataForum
Message Posted: Thu, 06 Jan 2000 @ 15:36:24 GMT
Subj: | | Re: How to retrieve ROLLBACK information from the system? |
|
From: | | Eric J. Kohut |
If you are on V2 R3 the rollback time should be about 1.5 times the time it took to run the delete up to the point it was aborted.
If you are on a previous version plan on 2.5 - 3 times the amount of time assuming you have not added a tremendous amount of Other data
and completely filled up your disks or a ton of new CPU work is going on.
These times should both be measured with the same amount and type of work on the system when the delete was running and Should be used as
a rough guideline but not a law.
Thanks,
EJK
Eric J. Kohut
Senior Solutions Consultant - Teradata Solutions Group - Retail
NCR Corp.
|