DB2 - Problem description
Problem IT37088 | Status: Closed |
A NON ENCRYPTED DATABASE THAT IS RESTORED AS AN ENCRYPTED DATABASE IS NOT CONNECTABLE AFTER THE RESET DB CFG COMMAND. | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
Original unencrypted database that is restored as an encrypted database fails to connect after submitting a RESET DATABASE command. $ db2start; $ db2 create db testdb; $ export PATH=~/sqllib/gskit/bin:$PATH; $ . ~/sqllib/db2profile; $ ~/sqllib/gskit/bin/gsk8capicmd -keydb -create -db "$HOME/ne.p12" -pw "pass" -type pkcs12 -stash; $ db2 update dbm cfg using keystore_location $HOME/ne.p12 keystore_type pkcs12; $ db2 backup database testdb; $ db2 get db cfg for testdb | grep -i "encr"; Encryption Library for Backup (ENCRLIB) = Encryption Options for Backup (ENCROPTS) = Encrypted database = NO $ db2 drop database testdb; $ db2 restore database testdb encrypt; $ db2 get db cfg for testdb | grep -i "encr"; Encryption Library for Backup (ENCRLIB) = libdb2encr.so Encryption Options for Backup (ENCROPTS) = CIPHER=AES:MODE=CBC:KEY LENGTH=256 Encrypted database = YES $ db2 reset db cfg for testdb; DB20000I The RESET DATABASE CONFIGURATION command completed successfully. $ db2 get db cfg for testdb | grep -i "encr"; Encryption Library for Backup (ENCRLIB) = libdb2encr.so Encryption Options for Backup (ENCROPTS) = CIPHER=AES:MODE=CBC:KEY LENGTH=256 Encrypted database = NO $ db2 connect to testdb SQL1655C The operation could not be completed due to an error accessing data on disk. SQLSTATE=58030 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Please, review description and install fix in 11.1 Fix Pack * * 7 * **************************************************************** | |
Local Fix: | |
N/A | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Please, review description and install fix in 11.1 Fix Pack * * 7 * **************************************************************** | |
Comment | |
Please, review description and install fix in 11.1 Fix Pack 7 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 02.06.2021 17.04.2022 17.04.2022 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |