Blog

What if you put your Db2 LUW database under a microscope? What would you see? What’s the smallest identifiable unit, into which the database can be divided? Let's check the anatomy of Db2 LUW.

When we think about a relational database, we see tables, where you can add, delete and sort rows. We also see schemas that connect these tables. But how does it look from the storage perspective?

Recently I REORGed some big tables. Even though they were partitioned, it turned out that some partitions are too big to be reorganised in Db2 11.1 (and earlier). I had to upgrade to 11.5. Curious?

Meet the DMS storage model, alternative for SMS tablespaces. In case of DMS we allocate a big chunk of contiguous disk space as a container and give the control over it to Db2...

Why do you tidy your room sometimes? How do you know when it’s the time to do it? Do you do it on a weekly basis or when it’s too cluttered? This is how I do it (in the Db2 LUW world).

How do we know that a REORG is needed? And why do we even need to reorganise the tables at all? Here is a case study on a simple schema with the REORGCHK tool in our hand.

How do you know that your table needs a reorg? Are there many empty pages? Maybe you did many deletes lately or changed column types? Or maybe you just want to reorder the rows?

Most of the tables require a REORG from time to time. Therefore we have to regularly check which tables must be reorganised and perform the REORG. But what if all of that work could be automated?

It turned out the installation of Db2 12.1 on M-based MacBooks is still not so straighforward. Here are step by step instructions on how to do it.

How to recreate a table with its data in the correct schema? db2move? db2look? What tools are useful here?

This article is about connecting remotely to a database and a more advance topic: federation. I'll show you how to set up federation step by step.

How do you monitor Db2 LUW databases? What tools do you use? What do you struggle with? Here is what tools are the most useful in different scenarios.

What would you say if your grandmother asked you what is your job? How would you explain what is "database" and what does "Db2" mean?