DB2 - Problem description
Problem IT39109 | Status: Closed |
BCD DECIMAL USING 0XF FOR SIGN NIBBLE MIGHT GET CONVERTED TO NEGATIVE VALUE | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
Data received over CLI that use 0xF as sign nibble in BCD format get interpreted as negative value, while 0xF indicates a positive BCD value. DB2 VSE is using this old data format. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * DECIMAL data ingest as BCD using 0xF in sign nibble. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 v11.5.7.0. * **************************************************************** | |
Local Fix: | |
Avoid using 0xF for sign when ingesting DECIMAL data into Db2. | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * DECIMAL data ingest as BCD using 0xF in sign nibble. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 v11.5.7.0. * **************************************************************** | |
Comment | |
Fix included in Db2 v11.5.7.0. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 17.11.2021 25.11.2021 09.12.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |