DB2 - Problembeschreibung
Problem IT26045 | Status: Geschlossen |
RESTORE OF A NON-ENCRYPTED DATABASE INTO AN ENCRYPTED ONE (TO IMPLEMENT ENCRYPTION) WILL NOT ALLOW ACTIVATION OF THE DATABASE | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
Reproduction of the issue with an online backup: - Create unencrypted database, set to archiving, create table, 5 inserts - Online backup with no transaction during backup - Copy out all of the logs in active log path - Update dbm to encrypted - Drop database - Restore using overflow, encrypted - Rollforward to EoL and stop - Activate database - An error is hit on first log write: 2018-08-18-22.12.26.880402-420 I8775A1847 LEVEL: Error PID : 16057330 TID : 24625 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : SAMPLE HOSTNAME: server1 EDUID : 24625 EDUNAME: db2loggw (SAMPLE) 0 FUNCTION: DB2 Common, Cryptography, cryptP12KSGetSecretKey, probe:492 MESSAGE : ECF=0x90000645=-1879046587=ECF_CRYPT_KEYSTORE_EXPECTED_LABEL_NOT _FOUND NOTE: This problem can also be reproduced with an offline backup. Online vs. offline doesn't matter. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to release inclusive of this fix. Refer to SYSROUTE * * APAR. * **************************************************************** | |
Local-Fix: | |
A) Restore the online/offline backup to a non-encrypted database. or B) Only copy logs that are needed from active to overflow: - deactivate database - db2 get db cfg (note down "First active log file") - copy out all active logs (just in case) - follow regular procedure to restore encrypt - Only copy the active log files prior to "First active log file" to overflow - rollforward or C) If offline backup can be done, don't copy any active logs. | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : Nachfolger : IT26452 | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 21.08.2018 27.09.2018 27.09.2018 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version |