Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sat, 21 Aug 2004 @ 14:06:54 GMT


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


Subj:   Iinitiating Parallel processing from Queryman
 
From:   Ken Hansen

Has anyone experienced erratic performance on Teradata v 5 in respect of parallel/serial processing of Multi-Step_Requests (MSRs)?

An MSR submitted for overnight parallel processing, to insert into an empty table, failed and the third step took many hours to roll back. My client's DBA then advised that MSR's must be initated via BTEQ rather than Queryman, or wrapped with BT/ET. Is this a misunderstanding?

I can prove parallel processing of some short MSRs but the documentation appears ambiguous. Is there a way of checking whether the request was actually submitted for parallel or serial processing?


Ken Hansen
Ivy House Associates



     
  <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: 27 Dec 2016