As mentioned by n_i, DPF is based on a share nothing architecture, which is more appropriate for data warehouses (which is why it is now called InfoSphere Warehouse). Share nothing architectures like DPF are used in parallel database applications, where each query runs in parallel on each node (accessing the data for a particular table that each node contains) and the coordinator node "glues" the answers from each node back into a single answer to be return to the SQL statement requesting the query.
PureScale is based on a shared disk architecture, more appropriate for OLTP.