Question: what is distribution key in db2?
Answer: What is a Distribution key? A distribution key is a column (or set of columns) that dictate the database partition on which DB2 will physically store a row in a table. This means that a distribution key applies to each (hash partitioned) table and not to the entire database.