Is there a way we can gather the %age of temp table space being comsumed at a given point of time. Similarly is it possible to get such diagnostics for the amount of bufferpool being used against the allocated amounts.
Also, does DB2 maintain these quantities over a period of time. I am looking for the average %age of Temp space and buffer space being used. This number will help me rethink the amount allocated for the table space and buffer pool.