How the Db2 enforces the unique key

It’s utilizes unique index to avoid identical key values storage in database. A unique index must be created whenever a table is to be created with primary key.
DB2 marks the table as unavailable until the needed indexes are created explicitly and prevents the duplicate entities into the table that has unique key
DB2 enforces the unique index when INSERT,UPDATE statements are applied to the table and it’s also enforces the unique index during the LOAD utility execution

Add Comment
0 Answer(s)

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.