DB2 - Problembeschreibung
Problem IC74950 | Status: Geschlossen |
DB2 MIGHT ENCOUNTER 'DEADLOCK' ERROR WHEN PERFORMING DROP TABLE AND RENAME TABLE SIMULTANEOUSLY. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problembeschreibung: | |
When concurrently perform RENAME TABLE and DROP TABLE on two different tables but with similar namings, the two statements may lead to a deadlock among the catalog tables, SYSIBM.SYSVIEWDEP and SYSIBM.SYSDEPENDENCIES. The problem is more likely to happen if the table being dropped has dependent views and other objects (e.g. index or trigger) defined on it. To identify the problem, you need to use DB2 event monitor to collect detailed information for deadlocks. When the deadlock error occurs, in the event monitor output you will see the following entries: Table of lock waited on : SYSDEPENDENCIES Schema of lock waited on : SYSIBM Data partition id for table : 0 Tablespace of lock waited on : SYSCATSPACE Type of lock: End of table Mode of lock: U - Update Mode application requested on lock: U - Update Text : RENAME TABLE NEWTON.T1 Table of lock waited on : SYSVIEWDEP Schema of lock waited on : SYSIBM Data partition id for table : 0 Tablespace of lock waited on : SYSCATSPACE Type of lock: Row Mode of lock: S - Share Mode application requested on lock: X - Exclusive Text : DROP TABLE NEWTON.T2 | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All users running Linux, Unix and Windows servers on DB2 * * v9.5 Fix Pack 7 or earlier are affected. * **************************************************************** * PROBLEM DESCRIPTION: * * When concurrently perform RENAME TABLE and DROP TABLE on two * * different tables but with similar namings, the two * * statements may lead to a deadlock among the catalog tables, * * SYSIBM.SYSVIEWDEP and SYSIBM.SYSDEPENDENCIES. * * The problem is more likely to happen if the table being * * dropped has dependent views and other objects (e.g. index or * * trigger) defined on it. * * * * To identify the problem, you need to use DB2 event monitor * * to collect detailed information for deadlocks. * * When the deadlock error occurs, in the event monitor output * * you will see the following entries: * * * * * * Table of lock waited on : SYSDEPENDENCIES * * Schema of lock waited on : SYSIBM * * Data partition id for table : 0 * * Tablespace of lock waited on : SYSCATSPACE * * Type of lock: End of table * * Mode of lock: U - Update * * Mode application requested on lock: U - Update * * Text : RENAME TABLE NEWTON.T1 * * * * Table of lock waited on : SYSVIEWDEP * * Schema of lock waited on : SYSIBM * * Data partition id for table : 0 * * Tablespace of lock waited on : SYSCATSPACE * * Type of lock: Row * * Mode of lock: S - Share * * Mode application requested on lock: X - Exclusive * * Text : DROP TABLE NEWTON.T2 * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 LUW Version 9.5 Fix Pack 8 or higher levels. * **************************************************************** | |
Local-Fix: | |
Perform DROP TABLE statement and RENAME TABLE statement sequentially. | |
verfügbare FixPacks: | |
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows | |
Lösung | |
First fixed in DB2 LUW Version 9.5 Fix Pack 8. | |
Workaround | |
Perform DROP TABLE statement and RENAME TABLE statement sequentially. | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC75112 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 10.03.2011 07.07.2011 07.07.2011 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.5., 9.5.FP8 | |
Problem behoben lt. FixList in der Version | |
9.5.0.8 |