Make your fact table a multi-dimensional-cluster.
That's ll do. I agree that DPF would be overkill.
If you don't have a low cardinality column that offers itself up for
MDC, just add another column e.g.
yearmonth GENERATED ALWAYS AS (INTEGER(date)/100)
Then cluster on the yearmonth column.
If you have 3 years worth of data this would partition the table into
3 * 12 => 36 slices.

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/