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.
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?
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?
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.
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?
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).
