PinnedWhat is Db2?“What’s your job?” — I was asked by my friend after a tennis game. “I’m a Db2 database administrator” — I answered immediately. “Oh…Mar 20, 2024Mar 20, 2024
All you need to know about the FEDERATION and remote database connection in Db2 LUWBefore becoming a DBA, I worked at IBM as a Db2 LUW support engineer. The very first ticket I got was about some issue between Db2 LUW and…Mar 24Mar 24
I created my table in the wrong schema! How to change the table schema in Db2 LUW?If you already have some experience with Db2 LUW (or just any other relational database system), you must have made lots of silly mistakes…Dec 13, 2024Dec 13, 2024
I installed Db2 LUW 12.1 on Mac (with Apple Silicon) — here is how to do it!I have been waiting months for this day. When I was told (at PDUG conference) that Db2 12.1 would be released on November 14th, I started…Nov 18, 2024Nov 18, 2024
Automate your REORGs in Db2 LUW (simple script inside)Running REORGs is one of the cyclic maintenance jobs you run against your tables. The best time to reorganise a table is the lowest traffic…Oct 4, 2024Oct 4, 2024
How to properly REORG a TABLE in Db2 LUW — different scenariosHow 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…Sep 13, 2024Sep 13, 2024
How to tell if your tables need a REORG? A case study using REORGCHK (Db2 LUW)When I started my first job as a DBA, I was shown the crontab of one of the database servers I was supposed to manage. I remember noticing…Aug 14, 2024Aug 14, 2024
Clean up your table! Why, when and how to REORG a Db2 LUW table (introduction)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…Jul 22, 2024Jul 22, 2024
DMS — database managed space in Db2 LUWLong time ago the disk space in Db2 LUW was always managed by the operating system. This storage model is called (in Db2 world) the SMS…Jun 1, 2024Jun 1, 2024
Too big to be REORGed (Db2 LUW)Recently I REORGed some big tables. Even though they were partitioned, it turned out that some partitions are too big to be reorganised in…May 21, 20241May 21, 20241
