Roger Miller's presentations about DB2 9 for z/OS

Hi DB2 user,

Here are several Roger Miller's presentations about DB2 for z/OS available on IBM website:

- DB2 9 for z/OS and Beyond
by Roger Miller

- DB2 for z/OS Selected Performance Topics
by Roger Miller

- Planning Your Migration to DB2 9 for z/OS
by Roger Miller

- Best Practices in DB2 for z/OS Security
by Roger Miller


More information

- DB2 9 for z/OS System Performance Topics
by Greg Dyck

- IBM DB2 for z/OS Utility Update: Best Practices
by Bryan Smith

- Maximizing the DB2 9 for z/OS Optimizer and SQL Performance Enhancements
by James Guo


Regards,

DB2usa.

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.

DB2 9 for z/OS Performance Features by Dave Beulke

Hi DB2 user,

Dave Beulke published several posts about DB2 9 for z/OS performance features on his Blog: http://davebeulke.com:

- DSNZPARM parameters
- ORDER BY and FETCH FIRST n ROWS in a Sub-Select
- Skip Uncommitted Inserts zParm
- Universal Tablespace
- FETCH WITH CONTINUE SQL
- DB2 Version 9 for z/OS Logging enhancement
- Performance improvement for IBM DB2 utilities
- Data Warehousing and Reporting features
- Minimizing the number of SQL call
- Too Many Performance Features in DB2 Version 9 for z/OS



More information

- Improving Performance with DB2 V9 for z/OS

- Java DB2 Performance with Data Studio and PureQuery

- pureQuery-JLINQ Examples to Improve Your Java Application Performance

- Data Warehouse Design and Performance

- How to do your own Performance Review

- Performance for SOA DB2 Java Applications



Regards,

DB2usa.

Robert Catterall's presentations

Hi DB2 user,

Here are several DB2 z/OS presentations of Robert Catterall, available on IDUG website and other websites:

- Get Up: DB2 High Availability & Disaster Recovery
by Robert Catterall

- What DB2 People Should Know About SOA
by Robert Catterall

- Ultra-Availability – How Far Can You Go?
by Robert Catterall

- DB2 for z/OS Data Warehouse Performance
by Robert Catterall

- DB2 Stored Procedures - Trends and Technology
by Robert Catterall


More information

- DB2 Data Warehouse Performance, Part 1
by Robert Catterall

- DB2 Data Warehouse Performance, Part 2
by Robert Catterall

- Robert's Blog
by Robert Catterall

Regards,

DB2usa.

CDUG 2009 Tech Forum's presentations (Shanghai, China)

Hi DB2 user,

Here are several presentations, from CDUG 2009 Tech Forum (Shanghai, China) available on DB2 China website:

- Partitioned Table Space Usage Experience Sharing
by Huang Hao

- DB2 Memory Management
by Jim Teng

- INSERT Performance Update
by Jim Teng

- DB2 for z/OS: Trend and Direction
by Fu Yu Qin and Gene Fuh


More information

- RTS Operation and Maintenance (in English/Chinese)
by Wu Ding

- RTS Operation and Maintenance : notes (Chinese)
by Wu Ding


Regards,

DB2usa.

Akira Shibamiya's presentations

Hi DB2 user,

Here are several DB2 z/OS Performance presentations of Akira Shibamiya, available on IDUG website:


- DB2 9 for z/OS Select, Insert, Update, Delete SQL Application Performance
by Akira Shibamiya

- DB2 9 for z/OS Performance Overview
by Akira Shibamiya

- DB2 for z/OS V7 and V8 System Performance Tuning
by Akira Shibamiya

- DB2 for z/OS V7 and V8 Application Performance
by Akira Shibamiya


More information

- DBM1 Virtual/Real Storage Change from DB2 for z/OS V7 to V8 to V9 and Ziip Offload
by Akira Shibamiya


Regards,

DB2usa.

z/Journal (June - July 2009 issue)

Hi DB2 user,

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


- Database Reorganization Strategies for DB2 z/OS
by Rick Weaver

- Approaches to DB2 Tuning: What's the Best Use of Your Time?
by Lockwood Lyon

- Are DBAs Really DBAs Today?
by Craig Mullins


More information

- Avoid Black Boxes to Improve Performance
by Craig Mullins

- Dynamic SQL On The Rise
by Craig Mullins

- An Overview of Mainframe Specialty Processors
by Craig Mullins



Regards,

DB2usa.