DB2 FOR LUW / DB2FORLUW / B10 - DB2

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.

****************************************************************
* USERS AFFECTED:                                              *
* all                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* upgrade to version 11.1 M4FP5                                *
****************************************************************

keiner bekannt / siehe Local-Fix

Vorgänger  : 
Nachfolger : IT30061 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

24.09.2018
22.08.2019
22.08.2019