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…
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…
It is no secret that I’ve been doing more work with DB2 on Windows lately. I know a number of clients who are looking for DBAs with experience with DB2 on Windows and are frustrated that they cannot find more…
I get it. The database server is a single point in many environments that have many points at most levels. Therefore any problem that affects more than one point must be the database. As DBAs, sometimes we feel the database…
Any DBAs faced with having to administer and maintain a large number of instances and databases will quickly find themselves swamped with work unless they learn to script most of their workload. Of course, the benefits of scripting do not…
I have been working with multiple instances on Windows servers lately, and have learned a few things about them, so I thought an article about multiple instances in general would be a good thing. The Basics First, if you don’t…
Having just solved this problem for the second time in two weeks, I thought I’d blog about it to make it easier to find the next time. Problem This genereally occurs when you are executing a PowerShell script using the…
Not long ago, I posted some of the details of using PowerShell as your command line for DB2 on Windows. I am definitely addicted to PowerShell as my command line when I have to work on Windows servers. I also…
I have worked with DB2 on Windows on and off over the years and have largely not enjoyed it all that much. Most likely because the vast majority of my time is spent on UNIX and Linux systems, so when…
