Question: what is dpsi in db2?
Answer: In Db2 11, you can specify the maximum degree of parallelism for a parallel group in which a data partitioned secondary index (DPSI) is used to drive parallelism. A DPSI is a nonpartitioning index that is physically partitioned according to the partitioning scheme of the table.