Category: Posts-By-Category

nhkoningshof 1

Ember Speaking at DB2 Symposium in Eindhoven on 11 June

For the 5th blogiversary of db2commerce.com, I’m taking a European trip. It has been more than decade since I’ve been overseas, so I’m very much looking forward to it. I’ll be speaking at the DB2 Symposium in Einhoven on 11 June! I’ll be giving a day-long intensive on Lessons Learned Running DB2 for E-Commerce. An outline of what I’ll be...

IanB 6

Generating Log Archive Activity Histograms

A few weeks ago, Ember posted a tweet mentioning that being able to see a histogram showing frequency of transaction log archive activity would be helpful. I had already done some work in this area by parsing the diagnostic log file (db2diag.log) for log archive messages, but I thought I could throw together a quick example of how to do this using...

2

Binding DB2 Base Packages for Various Versions

When connecting between different versions of DB2, you generally need to bind packages from the different versions against the DB2 database. Just because you’ve bound db2ubind and db2cli on the server does not mean that all possible clients connecting in are covered. Sometimes binds happen implicitly, but sometimes they don’t. And you don’t necessarily want to grant a user rights...

Abhik 0

DB2 Workload Manager (WLM) as a Monitoring Solution– Analyzing WLM Information (Part 3 of 3)

This is part three of a three part series. The full series includes: DB2 Workload Manager (WLM) as a Monitoring Solution – Understanding WLM (Part1 of 3) DB2 Workload Manager (WLM) as a Monitoring Solution– How to Set up WLM (Part 2 of 3) DB2 Workload Manager (WLM) as a Monitoring Solution– Analyzing WLM Information (Part 3 of 3) The...

AprilFools 4

The Coming pureScale Invasion

I’ve thought for a long time that one of the biggest issues that IBM has faced in getting more traction with pureScale is that it’s only included in the Advanced editions of DB2 – Advanced Workgroup Server Edition and Advanced Enterprise Server Edition. The recent announcement of the Business Application Continuity Offering will help expand the pureScale footprint to even more...

4

Giving Automatic Maintenance a Fair Try

I’m a control freak. I think that control freaks tend to make good DBAs as long as they don’t take it too far. My position for years has been that I would rather control my runstats, reorgs, and backups directly than trust DB2’s automatic facilities. But I also try to keep an open mind. That means that every so often...