This is a new series that has been percolating in my head for a while. When I help clients with SQL, we’re often adding (or removing) indexes to help SQL performance. It has been said (though not by me) that SQL re-write is obsolete because the Db2 Optimizer will take care of that.… Read the restContinue reading »
I’ve been moving along well this year on my data science journey. I’ve been thoroughly enjoying an edX class: Python for Data Science from UC San Diego. I started using Jupyter Notebooks (Python Kernel) over a year and a half ago, so I am enjoying the course on three levels:
- It seems easy because I have a background in Python, basic programming, and Linux systems
- I’m learning more about the Python libraries I use for Db2 health checks, and more about DataFrames that builds on my self-taught knowledge.
DB2 has an “interesting” relationship with Windows OS, and one of the areas where that relationship comes to the surface is user authentication and authorization, particularly when one is trying to use Active Domain groups for authorization purposes.
Here are a few pointers:
- Don’t use CLIENT authentication – this authentication method is explicitly excluded from the ability to use AD groups for authorization purposes.
Well, I knew it was going to be slow, and that is part of why my plan is a 20-year plan instead of just a short-term plan. The fall was particularly difficult due to a couple of issues at work and two conferences that I absolutely loved, but that took time away from the already 60-hour work weeks that I needed to be putting in.… Read the restContinue reading »
For more than 5 years I’ve managed to average at least one blog entry a week through fluctuating workloads and even through changing employers. And then came this autumn. The combination of a couple of large clients and going into holiday peak period for a couple of retail clients, collided with the IDUG EMEA conference where I was presenting two new sessions nearly combined to do me in.… Read the restContinue reading »
I have published several articles on PowerShell. But the “Hello, Db2 World!” series is designed to be a quick and fairly simple way of properly connecting to a Db2 database. Check out the GitHub repository folder for this blog entry.
Note that before starting, you should have a Db2 Client installed on the server you wish to connect from.… Read the restContinue reading »
Critical to recovering a database, but largely invisible, it is a good idea to understand the recovery history file, what it contains, and how to access it.
What is the Recovery History File?
The recovery history file is one of the many files associated with a database, but it is one of the most important.… Read the restContinue reading »