Some of my clients, instead of engaging me for day-to-day support, engage me for expert assistance only when it all really hits the fan. This issue occurred for one of those clients, who had other support performing the HADR failovers while the Linux kernel was upgraded.… Read the restContinue reading »
More on IBM’s RFE Program for Db2 on LUW
Once IBM made the Request For Enhancement (RFE) program workable last year, I blogged about it and tweeted about it, but now that we’ve seen more action on it, I thought I’d share some additional details.
What is an RFE?
First off, an RFE is a request for some feature or functionality in Db2 that does not exist today.… Read the restContinue reading »
High Availability Options for Db2 LUW
Why Should a Database be Highly Available?
It is significantly easier to implement high availability at other levels than it is at the database level. Often the database server is one of the more powerful servers in an environment, and without some fancy footwork there can be only one live copy of data.… Read the restContinue reading »
IBM’s June Announcements About DB2
Updated 6/26/2017 to include links on details for DSM 2.1.4 and a link to the DB2Night Show replay.
June 22 and the week surrounding it brought a number of announcements from IBM about DB2.
IBM has recognized that they need to invest more in marketing DB2.… Read the restContinue reading »
Strange Problem Installing DB2 11.1, Fix/Mod Pack 1 on Ubuntu
I ran into an interesting problem installing 11.1, fix/mod pack 1 on Ubuntu, and thought I would share. Please read to the bottom before trying anything, as this entry goes through things I tried that did not work before I got to what did work.… Read the restContinue reading »
DB2 Upgrade Detail: Upgrading Event Monitor Tables
I am a huge fan of always running a locking event monitor, and also using other event monitors when appropriate. This means that most databases I support have at least one event monitor, whether it is active or not. With some version changes, the structure of tables that event monitors write to are changed.… Read the restContinue reading »
Starting a DB2 Instance in a Quiesced State
Some applications are really good at continually trying to re-establish connections to a database. This can be useful when I want to quickly bounce the database and have the app reconnect without also having to bounce the app. It is problematic when I need DB2 to be down and stay down, but still allow me to work with it.… Read the restContinue reading »
DB2 Basics: Patching DB2
Like any software, DB2 requires frequent patching. A database should be one of the most secure parts of any enterprise, and keeping it secure means keeping up with the fixes that are delivered in fix packs.
DB2 delivers many things through fixpacks, including:
- Security Fixes
- Bug Fixes
- New Functionality – though IBM goes back and forth on this
IBM delivered Native Encryption in Fix Pack 5 of DB2 10.5.… Read the restContinue reading »
Deprecated, Discontinued, and Changed Defined for DB2
With each new release of DB2, there is a list of three different categories of old functionality that is somehow different in the new version. The use of these terms can be confusing if you don’t look at them every day.… Read the restContinue reading »
TSAMP Issue on Fixpack
As always, when I feel pain, I share the knowledge that pain gained me with my blog readers. Man, that was a painful fixpack. I was upgrading an AIX HADR pair from 10.5 fixpack 3 to 10.5 fixpack 5. My experience has generally been that TSA is painful when patching DB2.… Read the restContinue reading »
DB2 Upgrade Detail: Upgrading Explain Tables
Explain tables change in structure from version to version of DB2. If you want to continue to use the same set of explain tables across a DB2 upgrade, you must take special action to upgrade them.
Explain tables are used when generating a human-readable version of the access plan for a query.… Read the restContinue reading »