Category: Posts-By-Category

LovePark 3

Participating in the DB2 Community

One of the questions I ask in every interview these days is “How do you participate in the DB2 community and keep up to date on new features in DB2?” If I am hiring for a more junior position, this might morph into “What sources do you use to learn about DB2?”. I sometimes worry that this is or will...

log-file-saturation 6

Preventing Log Saturation

A few days ago, I was involved in a conversation on Twitter with Ember and Erwin Hattingh, a DB2 DBA from the Netherlands whom I met at IDUG in Dublin last November. Ember expressed her surprise at how well DB2 handled a nasty situation: It's not every day #DB2 blows your mind with the ability to stay up in a...

2

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. Problem Description In this case, I was not patching...

1

Going Beyond 2 Servers – HADR as a High Availability/Disaster Recovery option.

When the client considers high availability and disaster recovery, they often do not know what they are talking about. Many times the client may be dropping buzzwords like “five nines”. To them this is the definition of disaster recovery. In other cases, they are thinking of a worst-case scenario where a whole data center falls off the face of the...

file0002061413324 1

db2commerce.com Year in Review – 2015

Site Stats 2015 was again a record year for db2commerce.com. This year saw over 380,000 page views, which is more than 100,000 more than last year! I expect next year to not be such a drastic increase because my traffic has been fairly even through this year instead of the rapid series of upward steps I’ve seen in previous years....

file7551347375723 1

DB2 Basics: The DB2 LUW Sample Database

I find the DB2 sample database useful for trying new things and proving to myself how things work. Why Use the Sample Database? The DB2 sample database is useful for a variety of reasons. Testing Connectivity Sometimes when building a new database server, we need to test connectivity from an application server or some random client into the new server....