suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

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)