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