Db2 Experts on a Data Science Quest
The IT industry is a change machine. It is full of change. It always has been. As I get older, I wonder if it really is changing more, or if I’m just becoming set in my ways.
The first time I heard the term “DevOps” many years ago, I thought of it as a ploy for developers to get access directly to production.… Read the rest
Continue reading »
I have recently encountered an interesting issue – after an IPS (Intrusion Prevention System) upgrade, client applications suddenly stopped being able to connect to some database instances – not all of them, but just a to a subset.… Read the rest
Continue reading »
I have been recently tasked with creation of an early warning solution for a memory condition from which some of our DB2 databases have been occasionally suffering. Once the condition is encountered, the only resolution is to restart the instance which can cause an impact.… Read the rest
Continue reading »
The IDUG Virtual conference kicked off today, and I thought I’d share my excitement and a few observations.
Today was mostly the opening keynote and the spotlight sessions. Recordings of Monday’s sessions will be available on-demand for conference attendees later in the week, so if you haven’t even registered yet, do so and replay them.… Read the rest
Continue reading »
If you’ve read the blog for a while, you realize I’m a big fan of the IDUG conferences. I’ve gone to the North American one every year for the better part of a decade now, and the European one for several years.… Read the rest
Continue reading »
Db2 is a bit unusual among RDBMSes in that it does not perform authentication. No matter what, you need some external authority to perform authentication. Usually that is either the OS or LDAP, though there are other options. If using LDAP, either transparent LDAP or security plugins can be used.… Read the rest
Continue reading »
It has been a while since I wrote one of these, and it’s about time!
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.
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 »
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 »
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 »
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 »
Having worked on teams of Db2 DBAs, largely in consulting roles, the value of good documentation is huge. This is once again clear to me as I start a position with a new company. The documentation here happens to be excellent and it makes getting a new person (me!)… Read the rest
Continue reading »