|
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) |
