A fix is available
APAR status
Closed as program error.
Error 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
Local fix
N/A
Problem summary
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Please, review description and install fix in 11.1 Fix Pack * * 7 * ****************************************************************
Problem conclusion
Please, review description and install fix in 11.1 Fix Pack 7
Temporary fix
Comments
APAR Information
APAR number
IT37088
Reported component name
DB2 FOR LUW
Reported component ID
DB2FORLUW
Reported release
B10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2021-06-02
Closed date
2022-04-17
Last modified date
2022-04-17
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
DB2 FOR LUW
Fixed component ID
DB2FORLUW
Applicable component levels
RB10 PSY
UP
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
03 May 2022