As the size of database and the volume of transactions increase, many of Db2 transactions tend to spend significant amount of wait time in database read and log write I/Os.
zHyperLink is introduced to help reduce b2 transaction latency.
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.
En este artículo, exploramos el concepto de REST, en donde veremos por qué es importante, y lo que debemos saber para comenzar a trabajar con servicios RESTful.
In Part 1 of this blog we looked at the different ways to create or convert to Partition by Growth (PBG) table spaces. In this part we will review the advantages and disadvantages of PBGs, when it might be appropriate to use them, and making changes to existing PBGs.