Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 29 Nov 2007 @ 17:08:41 GMT


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


Subj:   Re: Statistics in BT; ET;
 
From:   Anomy Anom

<-- Anonymously Posted: Thu, 29 Nov 2007 11:03 -->

John,

Yes, that is impossible due to the way our process works. The population of the WRK tables are based upon steps above it like updates to target tables. Then updates to target tables follow the WRK inserts as well. These are all wrapped in an BT ET for rollback and restart purposes.

Seem like the statements inside the BT ET could be committed individually (as if they were not in a BT ET) , to allow the stats to be collected, but then the Transient journals would still be kept around (for the entire BT ET) in case of a failure, then the entire thing could roll back anyway. This would allow the stats to run within the BT ET. Seems like this would be a very common problem for many Data Warehouses processing jobs.


Thanks



     
  <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