Archives of the TeradataForum
Message Posted: Fri, 01 Sep 2006 @ 09:29:02 GMT
<-- Anonymously Posted: Wednesday, August 30, 2006 16:29 -->
I performed a cluster archive (8 simultaneous data arcs) of a 170 gb table. Each of the 8 pieces came back in under 8 minutes. Data Dict archive and Release Lock times were small.
When I recover the table (sumitting the copy statements in paralle), it takes 35-40 minutes to recover the 8 data pieces (running in parallel).
The Build Table step is taking less than 5 minutes.
The table in question has a short width and several indices.
The box has ~ 72 amps, 8 nodes.
I have the number of session set at 2 sessions per node.
I would like to get the recovery time down to 200% of the archive time.
I am considering bumping up the number of sessions. However, I don't want to "hog" all the sessions on the box.
Any thoughts or recommendations?
Does anyone know the last time this topic was discussed in the Forum?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|