Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 13 Sep 1999 @ 23:54:48 GMT


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


Subj:   Archive Processing
 
From:   Thomas Stanek

At our site, we are restoring (using the COPY statement) multiple tables from an archive tape to a database with a name different than the database that was archived in an MVS environment. The table names are the same.

I noticed that, for each table that is restored, the system starts a scan of the tapes from the beginning, even though it processes the tables in alphabetical order. I thought that the archive process stores the tables within a database in alphabetical order on the tape. Therefore, when restoring, the utility should be able to do one sequential pass of the tape.

Is this correct? If so, is this a JCL problem where the JCL needs to specify something like a NOREWIND parameter?

Also, when performing an ANALYZE of an archive in a job step separate from the archive itself, does the Archive utility logon to the system? If so, what user ID is used, since the output from the ANALYZE step does not indicate that a logon occurred? We were running an Analyze step and it failed because the TDP was not available (CLI0280). Is the TDP required, even for an analyze step?


Respectfully,

Tom Stanek
TFS CONSULTING



     
  <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