Technical Content

IDUG News Technical Content

Recently, on November 14th, IBM released the new version 12 of Db2 LUW and with that, as for every LUW version, a new version of Db2 Connect and the...

Read Post

A tablespace Scan is chosen by the optimizer for the retrieval of data from a query for many different reasons, often times when no other access...

Read Post

For the past 30 years, Transport Layer Security (TLS) has been the cornerstone of securing data in transit on the web. Billions of messages are sent...

Read Post

Some say the query optimizer can be thought of as the brain of your database management system. How is it possible to integrate neural networks into...

Read Post

Are column masks really secure as they seem to be? A few years ago, I published a blog on how to unmask the masked data. I believe this is the right...

Read Post

A recent post in this blog by Emil Kotrc, “Unmasking the masked data,” brought awareness to a potential risk with using column masks. In this...

Read Post

Storage systems play an important role in database recovery. Since storage capabilities are one of the central characteristics of cloud...

Read Post

Db2 Warehouse is a transactional database that has been used for decades to implement data analytics solutions, covering the full spectrum from deep...

Read Post

From the time it was first announced, I really liked the idea of converting a PBG (partition by growth) tablespace to PBR (partition by range)....

Read Post

Db2 Warehouse has recently gone through a significant transformation with the addition of a storage layer that supports Cloud Object Storage (COS)...

Read Post

With replication of data becoming ever more popular and needed, even in a bi-directional way, infoSphere Data Replication (IIDR aka CDC) can be...

Read Post

The AI Optimizer in Db2 blog post introduced the motivation for the AI query optimizer in Db2. This blog focuses on the high-level features covered...

Read Post