Forgot your password?
Document Actions
Primary Key duplication on insert
Primary Keys Duplicated - You cannot insert new records due Duplicated PK.
If you are using "identity columns as generated" you have to reset the PK using the commands below:
1 - Find the PK max value:
db2 "select max(<COLUMN_PK_NAME>) from <table_name>"
2 - Restart the value of PK identity column using MAX PK VALUE + 1:
db2 "ALTER TABLE <table_name> ALTER COLUMN <column_name> RESTART WITH <column_max_value> + 1"
Hacker Rangers - Gamification for CyberSecurity