DB2 - Problembeschreibung
Problem IT04117 | Status: Geschlossen |
REORG RECLAIM EXTENTS ON MDC TABLE MAY WAIT ON ONLINE BACKUP LEADING TO SQL0964C TRANSACTION LOG FULL | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
A REORG RECLAIM EXTENTS on MDC table may be blocked by a concurrently ongoing online backup. Online backup holds the Internal Online Backup Lock while a tablespace is archived. The REORG agent is waiting on this lock during the RECLAIM EXTENTS operation and cannot COMMIT while waiting. This can lead to REORG holding the oldest transaction and logfiles filling up ending in SQL0964C, transaction log full situations. This also affects REORG RECLAIM EXTENTS on ITC and BLU tables. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 10.5 Fix Pack 5. * **************************************************************** | |
Local-Fix: | |
Lösung | |
First fixed in DB2 Version 10.5 Fix Pack 5. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 01.09.2014 20.04.2015 20.04.2015 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.5.0.5 |