Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 04 Jul 2005 @ 10:40:31 GMT


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


Subj:   Re: Monitor Rates Settings
 
From:   David Wellman

Hi,

Very common rates are to have Logging set to 600 seconds (10 minutes). Additionally, you probably wouldn't have all the tables enabled as normal. The ones that you typically want enabled all the time are SPMA and SVPR (may be make this summary mode if you have lots of AMPs or are really concerned about disk space), you'll need IPMA if you are using PMON.

Also, set up a regular housekeeping job to move data from the real DBC tables to a history database on a regular basis.


Cheers,

Dave



     
  <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