suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IT24744 Status: Closed

CRASH RECOVERY MIGHT FAIL OR INTRODUCE DATABASE CORRUPTION WHEN USING AN
ENCRYPTED DATABASE

product:
DB2 FOR LUW / DB2FORLUW / B10 - DB2
Problem description:
The issue only happens on encrypted databases.  In rare cases, 
asynchronous page-cleaner agents might incorrectly flush 
modified pages to disk before the corresponding log records have 
been flushed to disk.  This is in violation of Db2's write-ahead 
logging protocol.  If a database crash occurs while a page has a 
change on disk whose corresponding log record is not on disk, 
then the subsequent crash recovery might fail or it might 
complete successfully while leaving database objects in an 
inconsistent state.  This might result in a wide variety of 
errors or might cause Db2 to return incorrect results.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Db2 11.1 Mod 4 Fixpack 4 or higher                * 
****************************************************************
Local Fix:
Run db2dart or INPSECT to examine the database after running 
crash recovery on an encrypted database.  To turn encrypted 
database to un-encrypted can be done by restore.
available fix packs:
Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix002 for Linux, UNIX, and Windows

Solution
First fixed in Db2 11.1 Mod 4 Fixpack 4
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
16.04.2018
27.11.2018
27.11.2018
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)