July 22, 2008
Volume 9, Issue 13

IN THIS ISSUE:

1. New Online
* Finding performance bottlenecks by analyzing SQL and XML statements
* New client optimization in IBM Data Studio pureQuery Runtime for z/OS
2.At the Bookstore
* Administering Informix Dynamic Server
3. Informix Update
* Andrew Ford wraps up his blog series on Informix's High Performance Loader
4. Skills Set
* News and information about IBM education
5. In the Zone
* The latest developerWorks articles on DB2, Informix, and more

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

1. New Online

* DB2 LUW Performance Blog: Finding Bottlenecks with SQL and XML Statement Analysis
A "search and destroy" mission for a single rogue statement that's sucking the life from a system is the most common form of statement analysis, according to performance expert Scott Hayes' latest post. But he argues that tackling smaller, peskier problems can help you avoid bigger trouble in the first place.

* New Online Article: IBM Data Studio pureQuery Runtime for z/OS Performance
pureQuery improves application throughput on DB2 for z/OS by making it easy to code and deploy static SQL for Java. The new client optimization feature in Version 1.2 extends the benefits of static SQL to any existing Java application without changing or recompiling Java applications.

2. At the Bookstore

* Administering Informix Dynamic Server: Building the Foundation
This new guide by IBM's Carlton Doe focuses on the basic skills required to administer and maintain Informix Dynamic Server (IDS). The book, available for pre-order in advance of its October 2008 release, reviews IDS installation, configuration, back up, and recovery, and offers an introduction to monitoring instance operations.

3. Informix Update

* The Informix High Performance Loader, Part 3
After going "old-school command line" with onpladm (and liking it), Andrew Ford takes on the somewhat more tedious (but necessary) HPL maps and format objects.

4. Skills Set

* IDUG 2008 – Europe Registration Open
Register for IDUG 2008 --- Europe (Oct. 13-17, 2008 in Warsaw, Poland) by August 29 to save EUR 275. The online Conference Schedule lists sessions and other details. New this year is the IDUG Management Forum for IT executives and managers, which takes place Monday, Oct. 13.

* New, Shorter ILO Sessions
New instructor-led online (ILO) courses from IBM are broken down into sessions shorter than standard ILO or classroom courses. Like other ILO offerings, they feature live interaction with an instructor over VOIP. The first course offered in this format is SQL Workshop (3N120), which provides an introduction to SQL and applies to the entire DB2 family and Informix. Sessions take place over multiple weeks in August.

* Redbook: Security and Compliance Solutions for IBM Informix Dynamic Server
A new, downloadable IBM Redbook covers the enriched security features available in Informix Dynamic Database Server (IDS).

* New Book Discount: Enterprise Master Data Management
Enterprise Data Management: An SOA Approach to Managing Core Information from IBM Press introduces key MDM concepts, explains the business case, and shows how MDM interrelates with service orientated architecture. Use promotion code IBM6250 to receive a 35 percent discount.

* IBM Certified Solutions Developer for DB2 9.5 SQL Procedure Developer Exam
IBM introduced the new Certified Solutions Developer for DB2 9.5 SQL Procedure Developer exam (#735) for candidates with significant experience and intermediate to advanced skills in developing DB2 stored procedures, user defined functions, and triggers.

* Information On Demand Global Conference 2008 Update
IBM is offering full-day education courses Sunday, October 26 at the Mandalay Bay Convention Center in Las Vegas. Attendees of the IBM Information On Demand Global Conference, which starts the next day, get preferred pricing for the session.

* U2 University Enrollment is Open
U2 University's two-and-a-half days of classes focus on in-depth technical U2 skills. Registration for events in Australia, England and two locations in the United States is now open.

5. In the Zone

* Easy Informix Dynamic Server performance analysis with OpenAdmin Tool
* How multithreaded architecture works in DB2 9.5
* Optimize the cursor in Informix Dynamic Server with ESQL/C
* Create a J2C application for an IMS phonebook transaction using IMS TM Resource Adapter
* IBM Data Studio software: The big picture
* Configuring and using the OpenAdmin Tool with IDS
* Migrate from Informix Server Administrator to the IDS OpenAdmin Tool