DB2 - Problembeschreibung
Problem IT26394 | Status: Geschlossen |
DB2 TAKES Z LOCK WHEN ATTACHING PARTITION TO TABLE | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problembeschreibung: | |
Command such as ALTER TABLE MYSCHEMA.TESTTABLE ATTACH PARTITION STARTING('2018-01-25') ENDING('2018-01-25') FROM MYSCHEMA.TESTTABLE1 May result in. DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL0911N The current transaction has been rolled back because of a deadlock or timeout. Reason code "68". SQLSTATE=40001 This may due to a z lock that should not be acquired during the process. This can happen when a table has columns with default values that is being attached to the partition table with different default values. This triggers an ALTER TABLE under the covers that acquires the z-lock and conflicts with the lock held by the attach partition. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * upgrade to version 11.1 M4FP5 * **************************************************************** | |
Local-Fix: | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : Nachfolger : IT30061 | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 24.09.2018 22.08.2019 22.08.2019 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version |