home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IT03081 Status: Geschlossen

AUTO DELETION OF BACKUP OBJECTS NO LONGER WORKING AFTER SWITCHING BETWEEN
ARCHIVAL AND CIRCULAR LOGGING

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
Auto deletion of backup objects is enabled via the 
AUTO_DEL_REC_OBJ db cfg parameter. 
 
When changing from archival logging to circular logging ( and 
back as needed ), it is possible log this auto deletion will 
stop working. 
This is triggered by the fact that  the log file sequence in the 
history files gets reset, so the log file numbers will start 
back at 0. 
 
This can cause the prune history logic to become confused and 
set the timestamp from where to prune backup images back at the 
beginning of the history file, thereby failing to prune images 
that should be removed.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* all                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade the database server to V9.7 Fix Pack 9               * 
****************************************************************
Local-Fix:
As a workaround, the entries to be pruned can manually be 
updated using the "UPDATE HISTORY" command and changing 
the obsolete history entries from 'A' (active) to 'D' (delete).
verfügbare FixPacks:
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows

Lösung
This problem has first been fixed in v9.7 Fix Pack 9
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
10.07.2014
10.07.2014
10.07.2014
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP9
Problem behoben lt. FixList in der Version
10.5.0.4 FixList