June 2008
Volume 9, Issue 12

IN THIS ISSUE:

1. CSI:DB2 — Proving the database's guilt or innocence
* Scott Hayes tests DB2's DNA to prove performance accountability
2. Informix update
* The Informix High Performance Loader, Part 2
* Unravelling the mysteries of the dbspace structure in IDS
3. From the wiki
* Go head to head with Thinking in Sets author Joe Celko's SQL puzzle
4. Tech term of the day
* Such mistakes are easily made on today's keyboards, but the term "fat finger" goes back farther than you'd think
5. Viral video
* The two most beautiful words in the English language?

*************************************

1. CSI:DB2 — Proving the database's guilt or innocence

* The DB2 DNA Test for Performance Accountability
The database is often presumed guilty when there is a performance issue. But if your database seems fine and showing all the signs of good performance, how do you prove your database's innocence? Scott Hayes shows you how to go forensic to assemble your defense.

2. Informix Update

* The Informix High Performance Loader, Part 2
* DBSPACE Structure in IDS
In the first of an occasional series of technical articles, the Oninit tech team investigates IDS's ultra-important reserved pages.

3. From the Wiki

* Joe Celko's SQL Puzzle
Can you match wits with the man who wrote the book (in fact, seven books) on SQL? Try your hand at his challenging puzzle, then talk about it on the discussion page. When you think you've got it, check your answer against this solution.

4. Tech Term of the Day

* The First Fat Finger?
Most of us have had personal experience with "fat fingering" something (in other words, typing the wrong key.) But the term goes back farther than you might think.

5. Viral Video

* The two most beautiful words in the English language?
A new video from IBM is a behind-the-scenes look at what happens when a "Hollywood" director takes on a corporate viral video pitch meeting. "The Office"-esque snippet, which reveals the "two" most beautiful words in the English language, is the first in a series of three.
* Enter your own video in this IDUG contest.