DB2 FOR LUW / DB2FORLUW / A50 - DB2

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.

****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to release inclusive of this fix. Refer to SYSROUTE  *
* APAR.                                                        *
****************************************************************

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.

not known / see Local fix

forerunner  : 
follow-up : IT26452 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

21.08.2018
27.09.2018
27.09.2018