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 an IBM employee.… 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 »