Error creating user-defined device group on a migrated system

Error message is displayed when you try to create a user-defined device group on some of the systems with IBM Security Guardium Key Lifecycle Manager, Version 2.7 that has migrated data.

To create a user-defined device group on such systems with migrated data, you must run the following steps.
Windows
  1. Open a command-prompt and run the following command.
    d2cmd
    set DB2INSTANCE=sklmdb27
    db2 connect to sklmdb27 user username using password

    Where,

    sklmdb27
    Identified by the DB2DBNAME property.
    username
    Identified by the DB2ADMIN property
    password
    Password for the database.
  2. Drop the identity.
    db2 "alter table KMT_DEVICE_TYPE alter column UUID drop identity"
  3. Start the identity with number higher than the existing user-defined group with highest uuid value.
    db2 "alter table KMT_DEVICE_TYPE alter column UUID  set GENERATED BY DEFAULT AS IDENTITY 
    (START WITH 10100 INCREMENT BY 1 MINVALUE 1 MAXVALUE 32767 CYCLE CACHE 20)"
  4. Run the following command to exit the session.
    db2 terminate
Linux®
  1. Open a command-prompt and run the following command.
    . ~sklmdb2/sqllib/db2profile
    db2 connect to sklmdb27 user username using password

    Where,

    sklmdb27
    Identified by the DB2DBNAME property.
    username
    Identified by the DB2ADMIN property
    password
    Password for the database.
  2. Drop the identity.
    db2 "alter table KMT_DEVICE_TYPE alter column UUID drop identity"
  3. Start the identity with number higher than the existing user-defined group with highest uuid value.
    db2 "alter table KMT_DEVICE_TYPE alter column UUID  set GENERATED BY DEFAULT AS IDENTITY 
    (START WITH 10100 INCREMENT BY 1 MINVALUE 1 MAXVALUE 32767 CYCLE CACHE 20)"
  4. Run the following command to exit the session.
    db2 terminate