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…
Kashiffarhaan·Aug 31Stop making the LLM rediscover your database: How to build agents for legacy & undocumented…Legacy database agents have a problem that is easy to underestimate. The model can write SELECT, UPDATE, DELETE AND INSERT .
SHAILENDRA UPADHYAY·Aug 31Cross-Database Row Count Validation: Using Java JDBCDatabase migrations are rarely complete when the data has merely been copied from one platform to another. One of the most important…
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…
Zahir Mohideen·Jul 30Database Independence…Write one database code independent of DBMS ….We will write the SQL to the lowest common denominator … Should not use Vendor’s Extensions …
Prashanth Madi·Jul 17From Db2 to Azure DocumentDB: How a Fortune-Scale Healthcare Provider Cut Database Costs by 80%A field story on migrating a mission-critical claims platform from IBM Db2 to Azure DocumentDB — plus the implementation patterns and best…
