In 2007, Db2 Version 9 introduced decimal floating point (DECFLOAT) as a new SQL data type. Since then, the storage and data manipulation of DECFLOAT(16) and DECFLOAT(34) data types have been supported. But what about DECFLOAT performance? And performance improvements of this datatype?
IBM’s Db2 Analytics Accelerator (formerly called “IDAA”) has been available for over 8 years, as IBM bought Netezza in 2010. However, many Db2 professionals still don’t have exposure to this technology.