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 many other images) mounting volumes somewhere other than the default location.… Read the restContinue reading »
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.
Setting the Page Size
The smallest unit of I/O that DB2 can handle is a page.… Read the restContinue reading »
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 Database”, which is part of my “Basics” series of slides.… Read the restContinue reading »
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 – and you really should read all 6 pages of that article – it is fascinating for a database geek.… Read the restContinue reading »
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 for DB2 certification was the ‘Family Fundamentals’ one, because it focused so heavily on SQL and other things I didn’t do day-in and day-out at the time.… Read the restContinue reading »