PinnedKacper Kubica·Mar 20, 2024What 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…
Kacper Kubica·Nov 3Schema-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·Aug 1Restoring a Single Tablespace in Db2 LUWRestoring just one tablespace in Db2 LUW is a DBA’s best friend for quick recovery without downtime on the entire database. It shines when…
Kacper Kubica·Jul 1db2look: How to get the DDL using command line (Db2 LUW)If you’ve ever had to migrate objects between environments, convince a reluctant developer that “the column is actually nullable,” or just…
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·Apr 6Locks and Isolation Levels in Db2 LUWEver felt like your Db2 database is playing tug-of-war with concurrent users? Locks and isolation levels are the referees ensuring data…