|
Problem IC73660
|
Status: Geschlossen |
HISTORY FILE OPENED IN INCORRECT MODE MAY RESULT IN HISTORY FILE CORRUPTION |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problembeschreibung: |
Due to the misuse of a confusing flag, when we open the history
file we will be opening it incorrectly with NO_FLUSH_ON_CLOSE,
which means do not flush the data to disk when closing the file
handle. This can be a problem if the database server then
crashed, causing the data in the file system cache to disappear
and never make disk.
The symptoms of the issue include history file corruption after
a server crash. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* See error description *
****************************************************************
* RECOMMENDATION: *
* In most cases the corrupted history file can be manually *
* removed from the database directory. However, it is *
* recommended to upgrade to the latest fixpak that contains *
* the fix to avoid the problem. *
**************************************************************** |
| Local-Fix: |
In most cases the history file can repair itself from the
secondary backup, if that is not possible, simply remove the
history file in the database directory and a new one will be
created automatically. However the data in the original history
file will be lost. The result of loosing this history file
information will include not being able to use the recovery
command for lost backup entries, however recovery and
rollforward would still be an option if applicable to the
database. |
| verfügbare FixPacks: |
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
|
| Lösung |
v95 fp 8 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 05.01.2011
06.07.2011
06.07.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.5.FP8
|
| Problem behoben lt. FixList in der Version |
| 9.5.0.8
|
 |
