Author: Ember Crooks

0

Another TSA State Issue

One of the features I would most like IBM to add into DB2 is the managing of TSA States through DB2 commands. I’m not a TSA expert, but I would like to find a class or opportunity to study it further. There are plenty of scenarios where I have to go in as root and run various commands to get...

3

HADR_TIMEOUT vs. HADR_PEER_WINDOW

It has taken me a while to fully understand the difference between HADR_TIMEOUT and HADR_PEER_WINDOW. I think there is some confusion here, so I’d like to address what each means and some considerations when setting them. In general, you’ll only need HADR_TIMEOUT when using HADR and only need HADR_PEER_WINDOW when using TSA(db2haicu) or some other automated failover tool. HADR_TIMEOUT HADR...

4

Rest In Peace, Adam Schneider

When you go to conferences, you tend to develop a group of friends that you hang out with and compare notes with and spend your evenings chatting with. As a blogger, I also spend time and energy trying to help other DBAs and give them opportunities. Adam Schneider was one of a small group of DBAs I spent my free...

4

Binding Packages

I approach binding from a physical/system DBA point of view. I’m not an application developer, and don’t understand all the possible intricacies of binding. But there is some information and tips I can share on binding packages in DB2. There are definitely some application developer topics included here. Static vs. Dynamic SQL This is a basic division in how SQL...

1

High Level Overview of Reads On Standby

With DB2 9.7 Fixpack 1, IBM started supporting reads on the HADR standby. This was a bit of an exciting feature for some of us. But in practice there are enough restrictions that it ends up not being an option that many clients choose. Reporting Server The main thing my clients want from this feature is to be able to...

0

New WCS Troubleshooting Webcast from IBM

This post is specific to WebSphere Commerce. I’m usually pretty critical of the IBM webcasts about WebSphere Commerce. There have been some pretty bad or incomplete ones in relation to WebSphere Commerce databases(“run dbclean” is the most frustrating, general advice ever). So I went into the one I listened to on Tuesday with low expectations. When billable hours are on...

0

Tips for Using the IBM DB2 Information Center Part 3: Information Structure – Parameter and Message Reference and General Guidance

This article is the third in a series about the IBM DB2 Information Center. Please check out the other articles in this series: Tips for Using the IBM DB2 Information Center Part 2: Information Structure – System Monitor and Syntax Tips for Using the IBM DB2 Information Center Part 1: Navigating Adminstration Guide: Performance / Parameter References Man, it would...