It has been a while since I wrote one of these, and it’s about time!
Recap
In June of 2018, I set a new goal for myself.
… Read the rest Continue reading »Long-term goal (by 2035): Work on data science in a way that makes the world a better place.
Category: Featured
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 many other images) mounting volumes somewhere other than the default location.… Read the rest
Continue reading »
Free Digital Education Opportunity: IBM User Group Days!
What is IBM User Group Days?
On May 19 and 20, IBM is hosting several tracks of great sessions. Some of these come out of content that would have happened at THINK, and others are collaborations with the user groups from various technologies.… Read the rest
Continue reading »
DB2 Administrative SQL Cookbook: List Privileged IDs that do not Have the Connect Authority
Purpose
To list IDs that have one or more privileges, but do not have the CONNECT authority through a direct grant, a group, or a role, either explicitly or implicitly. I used this to find IDs I might need to grant CONNECT to before revoking connect from PUBLIC.… Read the rest
Continue reading »
A Single Source of Truth – Even More Elusive in the Cloud Era?
Introduction
I would like to begin by thanking Ember for allowing me to be a guest blogger and explaining the motivation behind writing this blog.
The “need for speed” in today’s world has led to a sweeping reform where old ideas are discarded too rapidly.… Read the rest
Continue reading »
How do I Install SQL?
I have seen the question several times on various groups or forums – “How do I install SQL?”. From a DBA standpoint, this isn’t even a properly formed question. From a developer learning standpoint the question makes sense. I needed Python, I went and downloaded Anaconda.… Read the rest
Continue reading »
SQL+RDBMS Basics: What is a Commit?
This post is cross-platform and applies to all RDBMSes.
It is interesting to see, as a person experienced with a technical tool, some of the disadvantages of the newer ways of learning technical topics. When I started in IT, you learned some of the concepts in college, you learned some things working on the job with other DBAs who knew what they were doing, and you filled in the gaps by going to week-long classes once a year to get some detailed and hands-on official training.… Read the rest
Continue reading »
Packaging and Licensing of Db2 for LUW – Version 11.5
Edit 2020-01-02: corrected limit for free Db2 on Cloud to the correct 200 MB. Original text is still in the document, in strikeout.
This is one of the few blog entries where I include the Db2 version number right in the title.… Read the rest
Continue reading »
Troubleshooting SQL0803N
SQL0803N is an error message that means the SQL statement just issued failed due to violating a unique constraint within the database. The ‘N’ at the end of this error means that this statement failed and was not executed, but that it is probably not a database system issue.… Read the rest
Continue reading »
Why dsmtop isn’t Even Half as Good as db2top
I think I’m beginning to better understand why IBM is not fond of tools like db2top. The truth is that the developers really only get exposure to the largest Db2 clients. These are the ones that really pay the developer’s salaries, after all.… Read the rest
Continue reading »
The DBA is Dead? No, the DBA as Gatekeeper is Dead!
I still remember this meeting when I had been a DBA for less than a year at IBM. It was IBM, so I was the lone primary DBA for this internal client. With 3 whole months of experience and a shiny college degree.… Read the rest
Continue reading »
Index of Introductory Db2 Topics
This blog entry is designed to serve as a roadmap for current blog entries directed at those newer to Db2. In my mind, this likely includes anyone who has been working with Db2 for less than 2 years. However, often there are areas we spend more time in than others, so I think of these topics also as "spackle" - to fill in gaps for the self-taught. Note that some of the topics below are not links. This is because they're areas I plan to blog about in the future.
Continue reading »