DB2 - Problem description
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) |