Archives of the TeradataForum
Message Posted: Fri, 08 Jun 2012 @ 09:06:28 GMT
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
|