How to investigate Db2 copies installed on a Windows system
According to one of the definitions from the UrbanDictionary, adding the words “in bed” to any sentence can make that sentence “more interesting”. I like to think that the Db2 LUW world equivalent of that is taking a task – such as working with Db2 copies – and adding words “…on Windows”.… Read the restContinue reading »
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 »
Learning SQL can feel intimidating, even to some experienced DB2 DBAs. For years, you could administer Db2 without using SQL. There are a lot of developers, too who want to learn SQL. The set-thinking of SQL can be confusing. The complete detachment from the physical layer can confound others.… 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 »