Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
Next> Last>>  

Subj:   Improving recovery performance
From:   Anomy Anom

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


  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020