Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 26 Jan 2004 @ 13:19:10 GMT


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


Subj:   Re: How to figure out who is filling up the Transient Journal
 
From:   Christopher Platt

look to see who has highest cpu/io ratio and who has been on the longest...

you can also generally look into mload_spool database if you have one and see who has wt/uv/et tables and that will help to narrow down your list of targets. you should always keep a robust dbc as the TJ can overcome your allocation for the dbc database and grind your system to a halt. we have demonstrated this with an unqualified delete on one of the many join indexes that you set up while you worked here...

keep in mind that ccl ( ncrs customer care link ) does not alarm when DBC is full... one of lifes little mysteries as to why they don't protect their "queen" ( dbc ) a bit better.



     
  <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