How to recreate a table with its data in the correct schema? db2move? db2look? What tools are useful here?
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?
