Kacper Kubica·2d agoSchema-Level Grants in Db2 11.5 LUW: A Game Changer for PermissionsI think that my favourite improvement that came with the upgrade from Db2 11.1 to 11.5 are the schema-level permissions. You don’t have to…
Kacper Kubica·Oct 1PureScale — what it is and how it works (Db2 LUW)In the high-stakes world of enterprise databases, where downtime costs millions and data volumes explode overnight, IBM Db2 pureScale…
Kacper Kubica·Sep 14How to generate test data in Db2 LUWRecently I was preparing a case study for my DBA colleagues about dmctop. My case required some test data to be later modified and…
Kacper Kubica·Sep 1Executing DB2 Changes from Command Line: CLP Options GuideWhen it comes to data changes (like altering a table or creating an index), it seems to me that most DBAs use GUI tools like TOAD…
Kacper Kubica·Jun 2Db2 LUW Automatic Storage: Simplified Space ManagementAutomatic Storage in Db2 LUW automates container allocation and management for tablespaces, eliminating manual path definitions. DBAs no…
Kacper Kubica·May 1Deep Dive into Db2 LUW System Tables and CatalogsDb2 LUW relies on a robust system of tablespaces, schemas, and views to manage metadata like object definitions, privileges, and stats. Key…
Kacper Kubica·Mar 11File System caching in Db2 LUWFile system caching in Db2 LUW is one of those knobs everyone has heard about, but few have actually benchmarked properly. Let’s walk…
Kacper Kubica·Feb 13Indexes in Db2 LUW — what they are and how they workImagine your Db2 table is a massive phone book with millions of entries. Without an index, finding “Kowalski” means flipping every page —…
Fioravante Augusto Bossi·Feb 15, 2023How to handle application data types errors when migrating the Db2 LUW database to AWS RDS…Every time we think about migrating a legacy database to AWS then we must think about two special tools:
