|
Problem IT17042
|
Status: Closed |
-901: INVALID SVAR LEN, PRODUCING FODC_APPERR |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
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 << = 1 for the graphic data type. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Db2 10.5 Fix Pack 9 or higher *
**************************************************************** |
| Local Fix: |
Drop and recreate the table. |
| Solution |
First fixed in Db2 10.5 Fix Pack 9 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 14.09.2016
29.09.2017
29.09.2017 |
| Problem solved at the following versions (IBM BugInfos) |
9.0.
|
| Problem solved according to the fixlist(s) of the following version(s) |
