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
- 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.
- Drop the
identity.
db2 "alter table KMT_DEVICE_TYPE alter column UUID drop identity"
- 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)"
- Run the following command to exit the session.
db2 terminate
- Open a command-prompt and run the following
command.
- Linux®
- 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.
- Drop the
identity.
db2 "alter table KMT_DEVICE_TYPE alter column UUID drop identity"
- 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)"
- Run the following command to exit the session.
db2 terminate
- Open a command-prompt and run the following
command.