DB2 FOR LUW / DB2FORLUW / A50 - DB2

This APAR is opened to inform customers with Columnar organized
tables in the database of the following:
If columnar organized table has at least one character or
graphic data type column, then , once 10.5 FP10 is
installed, upgrade to 11.1 has to be done to one of the
following
levels:
- upgrade to 11.1 GA or 11.1 Mod 1 Fix Pack 1
- wait for 11.1 Mod 3 Fix Pack 3 iFix002 or 11.1 Mod 4 Fix Pack
4 to be released and upgrade
to these fixpaks.

If above is not done, db2ckupgrade will fail with SQL10007N
Message "5556" could not be retrieved. Reason code: "4" when
upgrading from v10.5fp10 to v11.1

To check if you have tables that could cause this issue in your
database , please, run this query :

"SELECT DISTINCT T.TBSPACEID, T.TABLEID, T.TABSCHEMA, T.TABNAME

                from SYSCAT.TABLES T JOIN SYSCAT.COLUMNS C
                on T.TABSCHEMA = C.TABSCHEMA and T.TABNAME =
C.TABNAME
                WHERE T.TABLEORG='C' and
SUBSTR(T.PROPERTY,21,1)!='Y'
                and (C.TYPENAME='CHARACTER' or
C.TYPENAME='GRAPHIC')
                ORDER BY TBSPACEID DESC"

****************************************************************
* USERS AFFECTED:                                              *
* N/A                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Real APAR with the fix is IT25322, firstly fixed in Db2 11.1 *
* Fixpack 3 Mod 2.                                             *
****************************************************************

No workaround.

not known / see Local fix

cancelled

forerunner  : IT25322 
follow-up : 

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

12.06.2018
16.09.2018
16.09.2018