John Campbell's DB2 for z/OS presentations

Hi DB2 user,

Here are several John Campbell's DB2 for z/OS presentations available on IBM and Tridex websites:

- Optimising DB2 for z/OS System Performance Using DB2 Statistics Trace
by John Campbell

- DB2 for z/OS Optimizing Insert Performance Part 1
by John Campbell

- DB2 for z/OS Optimizing Insert Performance Part 2
by John Campbell

- DB2 10 for z/OS Technical Overview
by John Campbell

- DB2 10 for z/OS Performance Preview
by John Campbell


More information

- Best Practices for DB2 Software Maintenance
by John Campbell and Michael Dewert

- DB2 9 for z/OS: Migration and Experiences
by Maja Kovac



Regards,

DB2usa.

Peter Vanroose's presentations about DB2 for z/OS

Hi DB2 user,

Here are several Peter Vanroose's presentations about DB2 for z/OS available on Abis website:

- DB2 9 New Datatypes and SQL Functions: Blessing or Curse?
by Peter Vanroose

- Experiences with stored procedures, triggers and XML on DB2 version 8 for z/OS
by Peter Vanroose

- Common Table Expressions in DB2 for z/OS: More powerful than you imagine
by Peter Vanroose


More information

- XML support in DB2 V9
by Ludo Van den dries



Regards,

DB2usa.

Redbook DB2 9 for z/OS and Storage Management

Hi DB2 User,

IBM just published a draft version of a new Redbook, "DB2 9 for z/OS and Storage Management, SG24-7823-00":
http://www.redbooks.ibm.com/Redbooks.nsf/RedpieceAbstracts/sg247823.html?Open

Abstract
This IBM Redbooks publication will help you tailor and configure DFSMS constructs to be used in a DB2 9 for z/OS environment. In addition, it provides a broad understanding of new disk architectures and their impact in DB2 data set management for large installations.
This book addresses both the storage administrator and the DB2 administrator. The DB2 administrator will find information on how to use DFSMS for managing DB2’s data sets. The storage administrator will find information on the characteristics of DB2 data sets and how DB2 uses the disks. We describe optimal use of disk storage functions in DB2 for z/OS environments which can best exploit the synergy with I/O subsystem on System z.

The addressed topics include the following:
- Using SMS to manage DB2 catalog, log, data, indexes, image copies, archives, workfiles.
- Taking advantage of FlashCopy for DB2 utilities, striping, copypools.
- Setting page sizes and using sliding allocation.
- PAV, MA, MIDAW, EF, EA, EAV. What they are and why they are good for you.
- Compressing data and indexes and the use disk and tape for very large data sets.
- Backup and Restore, and remote copy services recommendations.

Table of Contents
Chapter 1. Introduction
Chapter 2. Disk and tape environment overview
Chapter 3. DB2 storage objects
Chapter 4. System managed DB2 data
Chapter 5. Implementing SMS for a DB2 environment
Chapter 6. DB2 I/O performance and monitoring
Chapter 7. DB2 I/O operations
Appendix A. Frequently asked questions



Regards,

DB2usa.

Redbooks 2004-2010 and More

Hi DB2 user,

Here is a list of Redbooks and Redpapers about DB2 for z/OS published or updated between 2004 and 2010, available on IBM website:

Version 9
- DB2 9 for z/OS Technical Overview, SG24-7330-00
- DB2 9 for z/OS Performance Topics, SG24-7473-00

- DB2 9 for z/OS: Using the Utilities Suite, SG24-6289-01

- DB2 9 for z/OS: New Tools for Query Optimization, SG24-7421-00

- DB2 9 for z/OS: Packages Revisited, SG24-7688-00
- DB2 for z/OS: Considerations on Small and Large Packages, REDP-4424-00
- DB2 9 for z/OS: Resource Serialization and Concurrency Control, SG24-4725-01

- DB2 9 for z/OS: Buffer Pool Monitoring and Tuning, REDP-4604-00
- DB2 9 for z/OS: Backup and Recovery I/O Related Performance, REDP-4452-00

- Index Compression with DB2 9 for z/OS, REDP-4345-00
- How does the MIDAW facility improve the performance ... using DB2?, REDP-4201-00
- Disk storage access with DB2 for z/OS, REDP-4187-00

- Coupling Facility Performance: A Real World Perspective, REDP-4014-00
- DB2 9 for z/OS Data Sharing: Distributed Load Balancing, REDP-4449-00

- DB2 9 for z/OS Stored Procedures: Through the CALL and Beyond, SG24-7604-00
- DB2 9 for z/OS: Deploying SOA Solutions, SG24-7674-00

- DB2 9 for z/OS Distributed Architecture, SG24-6952-01
- DB2 9 for z/OS: Configuring SSL for Secure Communications, REDP-4630-00

- Enterprise Data Warehousing with DB2 9 for z/OS, SG24-7637-00
- 50 TB Data Warehouse Benchmark on IBM System z, SG24-7663-00

- LOBs with DB2 for z/OS: Stronger and Faster, SG24-7270-00
- Securing DB2 and Implementing MLS on z/OS, SG24-6480-01

- Enhancing SAP by Using DB2 9 for z/OS, SG24-7239-00
- Best Practices for SAP BI using DB2 9 for z/OS, SG24-6489-02


Version 8
- Version 8: Everything You Ever Wanted to Know , ... and More, SG24-6079-00
- DB2 UDB for z/OS Version 8 Performance Topics, SG24-6465-00

- Design Guidelines for High Performance and Availability, SG24-7134-00

- DB2 V8: Through the Looking Glass and What SAP Found There, SG24-7088-00
- DB2 UDB V8 and WebSphere V5 Performance Tuning and Operations, SG24-7068-00

- The Business Value of DB2 UDB for z/OS, SG24-6763-00


Other subjects
- DB2 for z/OS: Data Sharing in a Nutshell, SG24-7322-00
- Data Integrity with DB2 for z/OS, SG24-7111-00
- Disaster Recovery with DB2 UDB for z/OS, SG24-6370-00

- Powering SOA with IBM Data Servers, SG24-7259-00
- DB2 for z/OS and OS/390: Ready for Java, SG24-6435-00
- DB2 for z/OS and WebSphere: The Perfect Couple, SG24-6319-00

- DB2 for z/OS and OS/390 Version 7 Using the Utilities Suite, SG24-6289-00



Tips
- News on DB2 Optimization Expert and DB2 Optimization Service Center, TIPS0673
- Copying the DB2 UDB for z/OS Catalog Using the COPY Utility, TIPS0587
- SAP BW and DB2 for z/OS V8, TIPS0577


Information Center
- DB2, IMS and IBM Tools
- DB2 IFCIDs description (Tivoli OMEGAMON XE for DB2 Performance Expert on zOS)
- DB2 component (Tivoli Decision Support for z/OS: TDS)

- z/OS basic skills
- z/OS 1.11
- z/OS 1.11 (HTML and PDF)
- Enterprise COBOL and PL/I for z/OS Compilers
- DB2 for Linux, Unix and Windows

- z/OS Concepts (PDF)
- z/OS LookAt (HTML)


ABCs of z/OS System Programming
- Vol 1, z/OS operating system and the hardware architecture, SG24-6981-01
- Vol 2, z/OS implementation and maintenance, defining subsystems, SG24-6982-01
- Vol 3, DFSMS, data set basics, storage management, VSAM, ... , SG24-6983-02
- Vol 4, Vol 4, SNA, TCP/IP, VTAM, UNIX System Services, LE, SG24-5654-01
- Vol 5, Sysplex, System Logger, RRS, GRS, ARM, GDPS, SG24-6985-01
- Vol 6, Introduction to security, RACF , Digital certificates, ... , SG24-6986-00
- Vol 7, Printing in a z/OS environment, Infoprint Server, ... , SG24-6987-01
- Vol 8, An introduction to z/OS problem diagnosis, SG24-6989-04
- Vol 9, z/OS UNIX System Services , SG24-6989-03
- Vol 10, z/Architecture, LPAR concepts, HCD, and DS8000, SG24-6990-03
- Vol 11, Capacity planning, performance, WLM, RMF, and SMF, SG24-6327-00
- Vol 12, Workload Manager, SG24-7621-00
- Vol 13, JES3, SG24-7717-00


Introduction to the New Mainframe
- z/OS Basics, SG24-6366-00
- Large-Scale Commercial Computing, SG24-7175-00
- Networking, SG24-6772-00
- Security, SG24-6776-00


Regards,

DB2usa.

Redbook DB2 9 for z/OS: Resource Serialization and Concurrency Control

Hi DB2 User,

IBM just published a new Redbook, "DB2 9 for z/OS: Resource Serialization and Concurrency Control, SG24-4725-01":
http://www.redbooks.ibm.com/Redbooks.nsf/RedbookAbstracts/sg244725.html?Open

Abstract
Locking is the generic term used to refer to the database management system function that is required for managing interprocess concurrency and maintaining data integrity. However, locking is just one of the serialization mechanisms available in IBM DB2 for z/OS. DB2 uses different mechanisms for serialization to achieve its goal of maximizing concurrency without losing integrity with a minimum cost in CPU, I/O, and storage resources.
In this IBM Redbooks publication, we review and explore the different serialization mechanisms used in DB2, such as transaction (DML) locking, claims and drains, restrictive states, latching, and optimistic serialization.
This book was written for application developers in order to help them better understand serialization mechanisms and how they influence application design decisions.

Table of Contents
Part 1. Concurrency and integrity
Chapter 1. Serialization
Chapter 2. Transaction locking
Chapter 3. Serialization techniques
Part 2. Application concurrency and lock optimization
Chapter 4. Database design considerations
Chapter 5. Application design
Chapter 6. Utilities, commands, and SQL
Chapter 7. System considerations
Part 3. Monitoring and problem determination
Chapter 8. Identifying locking and concurrency problems
Chapter 9. Analyzing concurrency problems
Part 4. Data sharing
Chapter 10. Global locking
Chapter 11. Monitoring data sharing locking activity
Chapter 12. Database and application design in data sharing
Appendix A. System topology and workload


More information

First edition of this Redbook was published in August 1996.


Regards,

DB2usa.

Redbook DB2 9 for z/OS: Using the Utilities Suite

Hi DB2 User,

IBM just published a draft version of a new Redbook, "DB2 9 for z/OS: Using the Utilities Suite, SG24-6289-01":
http://www.redbooks.ibm.com/Redbooks.nsf/RedpieceAbstracts/sg246289.html?Open

Abstract
IBM continues to enhance the functionality, performance, availability, and ease of use of DB2 utilities.
This IBM Redbooks publication is the result of a project dedicated to the current DB2 Version 9 Utilities Suite product. It provides information on introducing the functions which help in setting up and invoking the utilities in operational scenarios, it shows how to optimize concurrent execution of utilities, collect information for triggering utilities execution, and considerations on partitioning.
It also describes the new functions provided by several utilities for SHARE LEVEL CHANGE execution which maximize availability and the exploitation of DFSMS constructs by the BACKUP and RESTORE SYSTEM utilities.
This book concentrates on the enhancements provided by DB2 UDB for z/OS Version 8 and DB2 for z/OS Version 9. It impicitly assumes a basic level of familiarity with the utilities as provided by DB2 for z/OS and OS/390 Version 7.

Table of Contents
Part 1. Introduction
Chapter 1. Introduction
Chapter 2. Backup and Restore utilities
Part 2. Planning for DB2 utilities
Chapter 3. Managing partitions
Chapter 4. Simplifying utilities with Wildcarding and Templates
Chapter 5. Performance via parallelism of executions
Chapter 6. Invoking and controlling executions
Chapter 7. Sort processing
Part 3. Executing DB2 utilities
Chapter 8. Loading and unloading data
Chapter 9. Reorganizing data
Chapter 10. Copying data
Chapter 11. Recoverying data
Chapter 12. Gathering statistics
Chapter 13. Verifying data consistency
Part 4. Managing and optimizing DB2 utilities
Chapter 14. Operational considerations
Chapter 15. DB2 Tools
Appendix A. Utilities related maintenance
Appendix B. Sample
Appendix C. Additional material


More information

First edition of this Redbook, published in August 2001 is still available:

- DB2 for z/OS and OS/390 Version 7 Using the Utilities Suite, SG24-6289-00


Regards,

DB2usa.

Redpaper DB2 9 for z/OS: Configuring SSL for Secure Client-Server Communications

Hi DB2 User,

IBM just published a new Redpaper, "DB2 9 for z/OS: Configuring SSL for Secure Client-Server Communications, REDP-4630-00":
http://www.redbooks.ibm.com/Redbooks.nsf/RedbookAbstracts/redp4630.html

Abstract
This IBM Redpaper provides information about how to setup and configure DB2 9 for z/OS with Secure Sockets Layer (SSL) using the z/OS V1R10 Communications Server: IP Application Transparent -Transport Layer Security (AT-TLS) services. This paper also covers the basic configuration steps for configuring SSL support for non-Java DB2 clients and IBM Data Server Driver for JDBC and SQLJ type 4 connectivity clients to access a DB2 9 for z/OS server.
The intended audience for this paper includes network and security administrators and database administrators who want to setup and configure SSL support for DB2 9 for z/OS.

Table of Contents
- Overview of SSL and IP AT-TLS
- Configuring DB2 9 for z/OS server with SSL support
- Configuring DB2 9 for z/OS requester with SSL support
- Configuring Java applications using IBM Data Server Driver for JDBC and SQLJ to use SSL
- Configuring non-Java DB2 clients for Linux, UNIX, and Windows to use SSL
- Configuring remote client applications to use SSL via a DB2 Connect server for Linux, UNIX, and Windows


Regards,

DB2usa.

Presentations from Guide Share France

Hi DB2 user,

Here are several presentations from Guide Share France, available on GSE France website:

- DB2 9 for z/OS for Database Administrators
by Namik Hrle

- DB2 9 for z/OS for Application Programmers
by Namik Hrle

- Access Path Stability for Dynamic Queries
by Thomas Baumann

- Recursive SQL from a Performance Perspective
by Thomas Baumann


Regards,

DB2usa.

Presentations from Baltimore/Washington DB2 Users Group

Hi DB2 user,

Here are several presentations from Baltimore/Washington DB2 Users Group, available on BWDB2UG website:

- Improving Performance with DB2 V9 for z/OS
by David Beulke

- What's New in DB2 9 for Applications
by Patrick Bossman

- DB2 Performance Primer
by Michael Murray

- Index Design in a Busy System
by Larry Kintisch and Tapio Lahdenmäki

- ATS DB2 Health Check
by John Iczkovits

- A List of DB2 Top Ten Lists
by Craig Mullins

- Null & Void? Dealing with Nulls in DB2 for z/OS
by Craig Mullins


More information

- New to DB2 LUW but for experienced z/OS DBAs
by Chris Eaton

- Database Trends
by Craig Mullins


Regards,

DB2usa.

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.

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.

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.

IBM DB2 Utililies presentations

Hi DB2 user,

Here are several presentations about IBM DB2 Utililies, available on the web.

- DB2 for z/OS Utilities Topics (State of North Carolina)
by Craig Friske

- DB2 for z/OS Utilities: Best Practices
by Haakon Roberts

- DB2 Backup System and Restore System Enhancements
by Bryan Paulsen

- Real-Time Statistics - How to arm your DB2 for 24x7
by Ulf Heinrich


More information

- What’s New in DB2 9 for z/OS for Backup and Recovery
by Jim Teng

- Redbook LOBs with DB2 for z/OS: Stronger and Faster

- Redbook DB2 9 for z/OS Technical Overview

- Redbook DB2 UDB for z/OS Version 8: Everything You Ever Wanted ...

- Redbook DB2 for z/OS and OS/390 Version 7 Using the Utilities Suite


Regards,

DB2usa.

Presentations from SQL Adria

Hi DB2 user,

Here are several presentations from SQL Adria, available on SQL Adria website:


- DB2 9 for z/OS - Hints and Tips for DBAs
by Namik Hrle

- DB2 9 for z/OS – Hints and Tips for Application Programmers
by Namik Hrle

- Lock Out Your Locking Problems
by Peter Backlund

- DB2 9 for z/OS XML Support
by Phil Grainger

- Desperate Table Designs
by Susan Lawson

- Top 10 Ways to Waste CPU
by Susan Lawson

- Universal Table Spaces, what are they?
by Klaas Brant

- Clone Table, Hot or not?
by Klaas Brant

- Bringing your DB2 to V9 (and V8)
by Jan Henderyckx

- Every Day’s Life of a DBA or How Do I Handle THAT Query?!
by Mirna Kos


Regards,

DB2usa.

DB2 for z/OS Version Polls (2009)

DB2 for z/OS Version
IBM currently supports two versions of DB2 for z/OS. On June 1st 2009,
which hightest version do you use in production?

DB2 for z/OS Version 8
Your production system is in DB2 for z/OS Version 8. Which Mode do you use
on June 1st 2009?

DB2 for z/OS Version 9
Your production system is in DB2 for z/OS Version 9. Which Mode do you use
on June 1st 2009?

Version 9 new functions
Feel free to rate a selection of new functions of DB2 for z/OS Version 9.

z/Journal (February - March and April - May 2009 issues)

Hi DB2 user,

Articles from February - March and April - May 2009 issues of z/Journal are available online: http://www.zjournal.com


- Canonical Database Architecture and DB2 Performance … Really?
by Susan Lawson and Dan Luksetich

- Not Sure Who You Are? Ask DB2
by Susan Lawson and Dan Luksetich

- How DB2 9 for z/OS Can Improve a Data Warehouse’s Performance
by Willie Favero

- Being a DBA in Hard Economic Times: Nine Notions for '09
by Lockwood Lyon

- DB2 System Configuration and Performance
by Craig Mullins


More information

- DBA Proverbs
by Craig Mullins

- Recovery Is a Compliance Issue
by Craig Mullins


Regards,

DB2usa.

Presentations from IBM DB2 for z/OS Performance Seminar (Japan)

Hi DB2 user,

Here are several presentations, from an IBM DB2 for z/OS Performance Seminar (Japan):

- The Best Performance Practices DB2 for z/OS
by Akiko Hoshikawa

- DB2 for z/OS PureXML Overview and Performance Practices
by Akiko Hoshikawa

- DB2 for z/OS Getting the Most From SQL Optimization Hints, Tips and Best Practices
by Yoichi Tsuji

- DB2 for z/OS Evolution of SQL Optimization V7, V8 and DB2 9
by Yoichi Tsuji



Regards,

DB2usa.

XML functionality in DB2 for z/OS

Hi DB2 user,

Here are several presentations and articles about XML in DB2 for z/OS, available on IBM websites:

- DB2 9 for z/OS pureXML - Survival Guide for DBAs
by Guogen Zhang

- Ten Essential DBA Tasks forDB2 9 for z/OS pureXML
by Guogen Zhang and Steve Chen

- Ten Common Usage Patterns of pureXML for DB2 for z/OS Applications IBM
by Guogen Zhang

- DB2 9 for z/OS pureXML FAQs
by IBM DB2 for z/OS XML development

- Leveraging DB2 9 for z/OS pureXML Technology (2nd Edition)
by Guogen Zhang

- DB2 9 and z/OS XML System Services Synergy Update
by Judy Ruby-Brown and Akiko Hoshikawa

- XML application migration from DB2 for z/OS V8 to DB2 9
Part 1: Partial updates to XML documents in DB2 9 for z/OS
Part 2: Comparing XML functionality in DB2 9 to DB2 V8
Part 3: Sample DB2 for z/OS XML application migration scenario
by John Shelton and Hardeep Singh


More information

- DB2 for zOS pureXML Wiki
Technical articles, webcasts, podcasts, presentations, samples and Downloads

- DB2 pureXML Blog
by Qi Jin, Guogen Zhang, Matthias Nicola, and other members of the DB2 for z/OS Development team

- XML DevelopperWorks
Articles, online tutorials, and other technical resources on XML standards and technologies


Regards,

DB2usa.