|
Problem IT04629
|
Status: Closed |
REORG RECLAIM EXTENTS ON MDC TABLE MAY WAIT ON ONLINE BACKUP LEADING TO SQL0964C TRANSACTION LOG FULL |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 9.7 Fix Pack 10. *
**************************************************************** |
| Local Fix: |
|
| Solution |
First fixed in DB2 Version 9.7 Fix Pack 10. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 26.09.2014
09.12.2014
09.12.2014 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP10
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.10
|
 |
