Archives of the TeradataForum

Message Posted: Fri, 08 Jun 2012 @ 09:06:28 GMT


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

Subj:		Re: Deleting records from DBC.TransientJournal table

From:		Md, Asifuddin

I am deleting some records from ResUsageSps table to get space back for DBC.

I notice that while ResUsageSps table size is going down though deletes TransientJournal table size is going up with the same rate. TransientJournal table is a system table and I can't open its definition nor browse.

My question is, "Can we purge records from this table?"

Some more on this.

Answer to your verification is NO. Reason it is made visible mostly to provide the DBA a visibility of what is occupying space.

Be sure that you have enough space in DBC and keep an eye on jobs. At times Long running Delete's/Updates skew TJ on certain Vproc or whole system.

Also ANSI transactions with missing ET are culprit too.

The occupied TJ space stays the same until the missing et txn is detected and corrected.

Note there comes a distinction of TJ with systems Pre-WAL and Post-Wal. Pre-Wal is outdated though.

     select  vproc
            ,sum(currentperm)
     from    dbc.tablesize
     where   databasename = 'dbc'
       and   tablename    = 'TransientJournal'
     group by 1
     order by 2 desc
     ;

     select  databasename
            ,sum(currentperm)
            ,sum(maxperm)
     from    dbc.diskspace
     order by 2 desc
     group by 1
     ;

Asif
TD


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

Attachments

Library

Quick Reference