Author: Ember Crooks

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

2

Tips on Using db2advis with Multiple Queries

Many times, the SQL analysis I do is extremely focused – mostly on SQL that is a proven resource hog or a suspected problem. Analyzing all SQL used in a particular process can be a bit different, and may not be something that is frequently done in WebSphere Commerce databases. Recently, I had the output of statement event monitors while...

5

Explain Part 3 – Visual Explain

Please start with the first two articles in this series: Explain Part 1 – Explain and the DB2 Optimizer Explain Part 2 – Command Line Explain Plans Using db2exfmt Explain is one of the few areas where I can see the argument for using a GUI. There are some neat features in Visual Explain and I haven’t seen many bugs...