Question: what is difference between index and primary key in db2?
Answer: In a DB2 table, a Primary Key uniquely identifies the row, no two rows can have the same Primary Key value. (A Primary Key is not required, but you can only have 1). An Index Key can be unique, or not. In an Index Key you can have multiple Rows with the same Index Key Value.