DB2 FOR LUW / DB2FORLUW / B10 - DB2

After replacing PD corruption with the db2cat tool, the same SQL
statement continues to produce -901 messages with "Invalid svar
len" for graphic or vargraphic columns.  As a result FODC_AppErr
folders are created.

db2cat takes the codepage and value from the catalog column
length and longlength and regenerates to cd->col_len and
cd->blob_len.  In this case the table Composite codepage and the
codepage for the vargraph column were set to 0.  Codepage 0 for
varchar/vargraphic is incorrect.  DB2 therefore needs to
retrieve the codepage from DBCSCODEPG for graphic data type
instead of CODEPAGE catalog.

In short, we need to fix db2cat's regenerate option.  The
col_len and blob_len should be

****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to fix pack                                          *
****************************************************************

Drop and recreate the table.

not known / see Local fix

forerunner  : IT17042 
follow-up : 

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

03.08.2017
10.10.2017
10.10.2017