Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 18 Jun 2015 @ 12:40:33 GMT

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

Subj:   Re: Restore/copy from multi stream files using
From:   Geoffrey Rommel

FILEDEF is specified on the command line, FILE in the script.

I haven't done a multi-stream restore in several years, but it used to be this way. (1) As Mark mentioned, you need to restore the streams in separate jobs. These can be run in parallel, as long as they all use different logon ID's. Specify the NO BUILD option. (2) Then, after all restores are finished, you need to do a final BUILD on the table. If the table has no indexes, this will run quickly.

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