DB2 - Problembeschreibung
Problem IT04629 | Status: Geschlossen |
REORG RECLAIM EXTENTS ON MDC TABLE MAY WAIT ON ONLINE BACKUP LEADING TO SQL0964C TRANSACTION LOG FULL | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - 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. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 9.7 Fix Pack 10. * **************************************************************** | |
Local-Fix: | |
Lösung | |
First fixed in DB2 Version 9.7 Fix Pack 10. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 26.09.2014 09.12.2014 09.12.2014 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP10 | |
Problem behoben lt. FixList in der Version | |
9.7.0.10 |