Susan Lawson and Dan Luksetich's presentations

Hi DB2 user,

Here are several DB2 z/OS presentations of Susan Lawson and Dan Luksetich, available on IDUG website:


- Quit Calling DB2 So Much!
by Susan Lawson and Dan Luksetich

- DB2 9 for z/OS: A New Spin on a Classic Database
by Susan Lawson

- Desperate Table Designs
by Susan Lawson and Dan Luksetich

- Top 10 Ways to Waste CPU
by Susan Lawson and Dan Luksetich

- V8/V9 SQL Challenges and Solutions
by Susan Lawson and Dan Luksetich

- Effective Uses of DB2 Triggers
by Dan Luksetich

- Utilizing DB2 V8 Table Expressions
by Dan Luksetich

- DB2 Legacy Migrations: Experiences of The Industry
by Susan Lawson and Dan Luksetich

- DB2 Application Design for Performance
by Susan Lawson and Dan Luksetich

- DB2 for z/OS Design and Tuning Tips for Your Complex VLDB
by Dan Luksetich


Regards,

DB2usa.

z/Journal (August - September 2009 issue)

Hi DB2 user,

Articles from August - September 2009 issue of z/Journal are available online: http://www.zjournal.com


- Avoiding Application Bottlenecks in a Dynamic Environment
by Lockwood Lyon and Lisa Westcott-Dryer

- Initial Project Analysis: An IMS to DB2 Conversion Example
by Shirley Huhtanen

- DISPLAY Your Way Out of DB2 Problems
by Craig Mullins

More information

- Storage & Data Management: Solid State Drives (SSDs) for System z
by Ray Lucchesi


Regards,

DB2usa.

Redpaper DB2 9 for z/OS: Buffer Pool Monitoring and Tuning

Hi DB2 User,

IBM just published a draft version of a new Redpaper, "DB2 9 for z/OS: Buffer Pool Monitoring and Tuning, REDP-4604-00":
http://www.redbooks.ibm.com/redpieces/abstracts/redp4604.html

Abstract
DB2® buffer pools are a key resource for ensuring good performance.This is becoming increasingly important as the difference between processor speed and disk response time for a random access I/O widens in each new generation of processor.A System z® processor can be configured with large amounts of storage which, if used wisely, can help compensate by using storage to avoid synchronous I/O.
The paper is intended to be read by DB2 system administrators but may be of interest to any z/OS® performance specialist. It is assumed that the reader is familiar with DB2 and performance tuning.

Table of Contents
- Describe the functions of the DB2 buffer pools
- Introduce a number of metrics for read and write performance of a buffer pool
- Make recommendations on how to set up and monitor the DB2 buffer pools
- Provide results from using this approach at a number of customers



More information

- Tuning DB2 at CGU Life
by Mike Barnard

- DB2 for z/OS Bufferpool Management
by Mike Bracey

- Buffer Pool Tuning for the New Large Memory World
by Joel Goldstein

- Redbook DB2 for OS/390 Capacity Planning, SG24-2244-00



Regards,

DB2usa.

IDUG Solutions Journal (Summer 2009)

Hi DB2 user,

Summer 2009 issue of IDUG Solutions Journal is available on line:


Current issue contains following articles:

- Escaping the REBIND blues in DB2 9 for z/OS
by Adarsh Pannu and Terry Purcell

- Best practices- DB2 9 for z/OS migration
by Roger Miller

- An Overview of Mainframe Specialty Processors
by Craig Mullins


Regards,

DB2usa.