Archives of the TeradataForum

Message Posted: Fri, 01 Sep 2006 @ 09:29:02 GMT

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

<-- 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?

Thanks

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