Check out the DB2 SQL Reference 1 Manual for ROLLUP and GROUPING SETS.
These are some of the newer functions, and I have yet to use them in a
production application, but I believe they might meet your needs..