Some tables hasn't peakperm

Database
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

Hi, 

 

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? 

 

Thanks! 

1 REPLY
Senior Apprentice

Re: Some tables hasn't peakperm

Hi,

 

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?

 

Cheers,

Dave

Ward Analytics Ltd - information in motion
www: http://www.ward-analytics.com