Author: Ember Crooks

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...

1

The DBA Ethos

I am a DBA. No matter what title my company gives me, my primary job is designing, engineering, and supporting DB2 databases. DBAs sometimes have a bad reputation. I was a bit surprised the first time my engineering colleagues told me how lucky we were to have such great involved DBAs. Don’t get me wrong – I know I am...

0

Tips for Using the IBM DB2 Information Center Part 2: Information Structure – System Monitor and Syntax

My goal with this series is to provide some tips and tricks you might not be aware of for finding information in the IBM DB2 Information Center. Check out Part 1 in this series: Tips for Using the IBM DB2 Information Center Part 1: Navigating As I mentioned in Part 1, I started working with IBM DB2 documentation just before...

8

Tips for Using the IBM DB2 Information Center Part 1: Navigating

Note: this post refers to an obsolete version of the IBM DB2 Knowledge center, and therefore many of the links are broken. For details on the current version, see The New IBM DB2 Knowledge Center The IBM DB2 Information Center is a wonderful resource if you know what you’re looking for. Unfortunately, sometimes you do not know exactly what you...

2

Quick Tip: db2look and Triggers

Just a quick tip today. I’ve been dealing quite a lot with triggers lately, and found the -td option on db2look very useful. I hadn’t had cause to use it before, but it has now become part of my default syntax. In my case, I was moving 963 triggers from a development system to production, and db2look without the -td...

16

DB2 LUW – What is a Page?

The logical view of a database consists of the standard objects in any RDBMS – Tables, Indexes, etc. There are a number of layers of abstraction between this and the physical hardware level, both in the OS and within DB2. Setting the Page Size The smallest unit of I/O that DB2 can handle is a page. By default, the default...