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: 15 Jun 2023