Choosing the BEST RDBMS
When I started working as a DBA in 2001, the relational database management system choices were more limited and the choice itself was often left up to a system architect. Rarely did developers have a say, and even DBAs only…
Tag RDBMS
Posts on data for a Relational Database Management System
RDBMS Concept: Buffer Pool
One of the things that learning a new RDBMS is teaching me is that there are some concepts that are common to RDBMSes. It is helping me to identify some of those concepts, and I learn a lot from the…
Disappearing Data in PostgreSQL
I recently discovered an interesting (and frustrating) issue while running PostgreSQL in Kubernetes. While the issue technically isn’t specific to Kubernetes, per se, it is certainly easy to encounter in Kubernetes for users of the official PostgreSQL Docker image (and…
Licensing Your Database Software on Virtual Platforms
Disclaimer: I am not an expert on Oracle RDBMS licensing. Please verify any and all licensing statements about IBM or Oracle before relying on them. I am likely biased towards IBM, having based my career on them, but am not…
DB2 LUW – What is a Page?
The logical view of a database consists of the standard objects in any RDBMS – Tables, Indexes, etc. There are a number of layers of abstraction between this and the physical hardware level, both in the OS and within DB2.…
DB2 Basics: What is an Instance?
I was reviewing my many hundreds of slides that I use when training DBAs, and realized that some of my “Basics” slides might lead to good blog topics. My single most popular blog post ever is “How to Catalog a…
Oracle’s SCN Flaw – could it happen in DB2?
I read an article on a flaw in Oracle that was recently discovered. It had to do with the SCN number that is constantly increasing in any database: Thanks to my friend Fitz for bringing it to my attention…
Newbie differences between DB2 and Oracle
So I’m obviously biased in favor of DB2, but here are a few things that have surprised me to learn are different in Oracle. Terminology differences are rampant. This list is a bit scattered as it’s mostly a brain dump,…
DB2 vs. Oracle – handling dates
So as I may have mentioned before, I’m learning Oracle. I’ve always been a DB2 DBA, having started out as strictly a Physical/Systems DBA. Thus SQL is a skill I’ve built very slowly, over time. I thought the hardest test…
WebSphere Commerce – Oracle or DB2
So I’m obviously biased on this. I’ve been a DB2 DBA for 10 years and believe in DB2 very strongly. Some of my biases against Oracle may be completely unfounded. I’m actually learning Oracle so I can support clients who…