April 29, 2008
Volume 9, Issue 8

IN THIS ISSUE:

1. DB2 for Linux, Unix, and Windows Performance
* More tips for optimizing write I/O
2. DB2 9 DBA Certification Study Questions
* Making configuration changes and executing the create table command
3. Informix Update
* How to test configurable page sizes
4. Tech Term of the Day
* Ohnosecond: Look it up if you want, but this one means exactly what you might guess
5. Also Online
* Don't miss these key articles from the latest issue

**** Sponsored by xkoto *****

Huge savings, continuous uptime, increased performance...these are just a few differences between high and continuous availability.

Backed by IBM support, xkoto's GRIDSCALE® Data Virtualization is the only continuous availability solution on the market today designed specifically for IBM DB2.

Learn more and download your free GRIDSCALE whitepaper today!

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

1. DB2 Performance: More tips for optimizing write I/O

There's more than one way to skin a cat, starts performance expert Scott Hayes' latest post, and, Hayes concedes, more than one way to optimize write I/O. Rest assured, in sketching out the alternatives to his previous write I/O advice, no cats were harmed.

2. DB2 9 DBA Study Questions: Making configuration changes and executing the create table command

Challenge yourself with the latest sample questions from Roger E. Sanders' certification study guide for the DB2 9 DBA administration exam.

3. Informix Update: Testing configurable page sizes

Informix Dynamic Server version 10.0 introduced the ability configure the page size of the data stored in a dbspace. But how do you know what size will be most efficient? Andrew Ford explains how to test whether you've gotten it right.

4. Tech Term of the Day: Ohnosecond

Oh yes it does mean pretty much what you'd probably guess. Have a look, then search for more tech terms.

5. Also Online

They don't have splashy artwork or fancy fonts, but these workhorse columns give you the straight story:

" Derived key indexes in DB2 for i5/OS

" IDS 11 Sysmaster database

" DB2 9.5 deep compression