DB2 FOR LUW / DB2FORLUW / B50 - DB2

The distribution key order may be invalid when a table is
created based on a SELECT.

For example:
CREATE TABLE A(A INT, B INT) ORGANIZE BY COLUMN DISTRIBUTE BY
(B, A);
CREATE TABLE B AS (SELECT * FROM A) WITH DATA;
SELECT TABNAME, COLNAME, PARTKEYSEQ FROM SYSCAT.COLUMNS WHERE
TABNAME IN ('A','B')
ORDER BY TABNAME, COLNO;

TABNAME|COLNAME|PARTKEYSEQ
-------|-------|----------
A |A | 2
A |B | 1
B |A | 1
B |B | 2

This is not what should be happening. The distribution key of
table B should be inherited from table A.

****************************************************************
* USERS AFFECTED:                                              *
* all                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Db2 11.5.5.0 or higher                            *
****************************************************************

N/A

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

11.08.2020
20.11.2020
20.11.2020