Archives of the TeradataForum
Message Posted: Tue, 20 Aug 2002 @ 21:41:34 GMT
The size of the transient journal suddenly grew extremely large in the last week. I suspect it being generated by an abort request. The administration guides say that the obsolete rows are periodically deleted.
I was wondering, If it is possible to manually delete the rows in a transient journal (is it safe?). If so, how? and, can it be done using sql.
Also, Is there anyway to go back and find out, which user query or user caused this.
Thanks in advance.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|