Victor Chang and others have published a white paper on row compression on DB2 9.
At a high level, authors have achieved significantly better performance running DSS queries in a compressed database using only half as many disks as the uncompressed database. They have also discussed about some best practice techniques that are useful when applying the row compression feature using DB2 9.