Education
Abstract
There is a difference in DECIMAL data type precison for Netezza and Db2 Warehouse products.
Content
The maximum precision of the Db2 data type is 31 digits. The maximum precision of the Netezza data type is 38 digits.
Check whether you can redefine the precision of the data type to comply with the Db2 limit. If not, consider using the DECFLOAT data type, which has a maximum precision of 34 digits.
db_migrate script checks if data range of Netezza source is above the precision of 31 - if so, db_migrate terminates with error. If no such values exist, a field will be automatically converted to lower 31 digits precision.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSHRBY","label":"IBM Integrated Analytics System"},"Component":"","Platform":[{"code":"PF004","label":"Appliance"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
17 October 2019
UID
ibm10730271