Distributed Processing with DB2 for z/OS

Hi DB2 user,

Here are several presentations and articles about Distributed Processing with DB2 for z/OS, available on different websites:

- An Introduction to Distributed Processing with DB2 for z/OS
by Hugh Smith

- Distributed Processing with DB2 for z/OS – Advanced Topics
by Hugh Smith

- Understanding Distributed Processing Inside DB2 for z/OS
by Judy Quenet

- DB2 and WLM: An Introduction to Enclaves
by Mark Rader

- Using WLM with DB2 for z/OS
by Hugh Smith

- Java application deployment considerations
by Connie Tsuia and Rahul Kitchlu

- XML application migration from DB2 for z/OS V8 to DB2 9
Understand the DB2 UDB JDBC Universal Driver
by Anson Kokkat


More information

- Redbook DB2 9 for z/OS: Distributed Functions


Regards,

DB2usa.

DB2 for z/OS Troubleshooting and Monitoring presentations

Hi DB2 user,

Here are several presentations about DB2 for z/OS Troubleshooting and Monitoring, available on IDUG website:


- DB2 Systems Programming Tools of the Trade
by Linda Hagedorn

- The Diagnosis Manual Secrets and Intrigue
by Linda Hagedorn

- RMF For a DB2 DBA and Systems Programmer
by Venkat Srinivasan

- What Happened? When? Who Did It?
by Bryce Krohn

- How to Monitor Your Data Sharing System, with Tips and Tools to Help! Part 1 of 2
by Bryce Krohn

- How to Monitor Your Data Sharing System, with Tips and Tools to Help! Part 2 of 2
by Bryce Krohn

- Lock Out Your Locking Problems – Part 1
by Peter Backlund

- Lock Out Your Locking Problems – Part 2
by Lennart Henäng

- DB2 Connect to DB2 z/OS – Problem Determination & Performance Tips & Tricks
by Melanie Stopfer

- Troubleshooting Tuning for Dynamic SQL
by Thomas Baumann

- Memory Management for Dynamic SQL
by Thomas Baumann



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.