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 IT24968 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:                                              * 
* Encrypted Databases                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Please, see Error Description and install this fix.          * 
****************************************************************
Local Fix:
Run db2dart or INPSECT to examine the database after running 
crash recovery on an encrypted database.  Turn encrypted 
database to un-encrypted 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
Please, see Error Description and install this fix.
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
04.05.2018
16.07.2018
16.07.2018
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)