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 IT24743 Status: Closed

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

product:
DB2 FOR LUW / DB2FORLUW / A50 - 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 only                                     *
****************************************************************
* 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.  To turn encrypted
database to un-encrypted can be done by restore.
Solution
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : 
follow-up : IT24968 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
16.04.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)