DB2 - Problem description
Problem IT25046 | Status: Closed |
RESTORE WITH "SHOW MASTER KEY DETAILS" DID NOT SHOW ALL THE KEY LABEL | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
The problem can be reproduced as follows 1) database sample is created as an encrypted database with key label MK1 2) in db cfg ENCRLIB is set to the encrypted lib file Encryption Library for Backup (ENCRLIB) = /opt/IBM/DB2/V11.1.2ifix/lib64/libdb2encr.so.1 Encryption Options for Backup (ENCROPTS) = 3) db2 "backup db sample online encrypt encropts 'Master Key Label=MK2:Master Key Label=MK3'" 4) db2 "restore db sample encropts 'SHOW MASTER KEY DETAILS'" then check the key label information, it just showed MK1, and MK2/MK3 are ignored. KeyStore Type: PKCS12 KeyStore Location: /home/db2inst1/keystores/ne-keystore.p12 KeyStore Host Name: host01 KeyStore IP Address: 192.168.1.1 KeyStore IP Address Type: IPV4 Encryption Algorithm: AES Encryption Algorithm Mode: CBC Encryption Key Length: 256 Master Key Label: MK1 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.1 Mod 4 Fixpack 5 or higher * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 13.05.2018 16.01.2020 16.01.2020 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |