Some tables hasn't peakperm

The Teradata Database channel includes discussions around advanced Teradata features such as high-performance parallel database technology, the optimizer, mixed workload management solutions, and other related technologies.
Teradata Employee

Some tables hasn't peakperm



I execute each night the macro for reset peakperm on all tables in my datawarehouse, but there are some tables that hasn't peakperm after loader. ¿Why? I don't understand that tables are loaded and there isn't peakperm for them. 


Can anybody help me? 



Senior Apprentice

Re: Some tables hasn't peakperm



I don't know if you've resolved this yet...


Assuming that you're referring to the 'DBC.ClearPeakDisk' macro then this might be down to the sequence in which you do this processing.


That macro sets the PeakPermSpace column to 0.

Until you do any maintenance processing against a table the PeakPerm will stay at 0. (SELECTs don't seem to cause this to be updated - which makes sense).


So if your processing was in the following order:

- 'reset peakperm'

- loader

- reporting


Then that is what I'd expect to see.


Is that what happened?




Ward Analytics Ltd - information in motion