|
Problem IT35165
|
Status: Closed |
DB_MIGRATE ISSUE WITH INTERNAL FORMAT WHEN INPUT STRING AFTER CODEPAGE CONVERSION EXCEED THE TARGET COLUMN SIZE.
|
| product: |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 |
| Problem description: |
Addresses the following issues:
1. larger varchar/varbinary size from NZ which is not
accommodated in Db2 varchar size limit need to be migrated in
clob/blob datatype.
2. Input string after codepage conversion exceeds target column
size is getting uploaded truncated without any error message
thrown. Ideally it should report an error and process should
abort for user to take necessary action.
3. with Codeunit32 character enforcement is not done. a large
number of character's are getting loaded than the expected
number of characters in Codeunit32 columns. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Db2 11.5.5.1 or higher *
**************************************************************** |
| Local Fix: |
Use text format (which result in error expected from internal
format) or increase the column size to have the complete data
loaded. |
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Db2 11.5.5.1 or higher *
**************************************************************** |
| Comment |
Upgrade to Db2 11.5.5.1 or higher |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 03.12.2020
01.04.2021
01.04.2021 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
