| Latest versions | fixlist |
| 11.1.0.7 |
 |
| 10.5.0.9 |
|
| 10.1.0.6 |
|
| 9.8.0.5 |
|
| 9.7.0.11 |
|
| 9.5.0.10 |
|
| 9.1.0.12 |
|
| Have problems? - contact us. | |
| Register for free |
|
| Contact form |
|
DB2 - Problem description
| Problem IT03126 | Status: Closed |
APPLICATION PERFORMING LOCK ESCALATION CANNOT BE FORCED | |
| product: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
| Problem description: | |
An application that is holding a large number of locks may take a long time to complete lock escalation. As a result, other applications may experience lock waits, timeouts, deadlocks. Lock escalation is not interruptable, and as a result, the system may appear to be hanging. Currently, the only options are to forcibly bring down DB2, or wait until the lock escalation completes. This APAR will add an enhancement to allow the lock escalation process to be interrupted, so that an agent that is in lock escalation can be forced. | |
| Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * This change will allow applications performing lock * * escalation to be interrupted. * **************************************************************** * RECOMMENDATION: * * Upgrade to the latest fix pack. * **************************************************************** | |
| Local Fix: | |
| Solution | |
Problem is first fixed in DB2 UDB version 9.7 fix pack 10. | |
| Workaround | |
not known / see Local fix | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 11.07.2014 10.11.2014 10.11.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 |
|