Le traitement distribué avec DB2 pour z/OS

Bonjour,

Vous trouverez ci-dessous plusieurs présentations et articles sur le traitement distribué avec DB2 pour z/OS, disponibles sur différents sites web :

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

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

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

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

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

- Java application deployment considerations
par Connie Tsuia et Rahul Kitchlu

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


More information

- Redbook DB2 9 for z/OS: Distributed Functions


Amicalement,

DB2usa.

Présentations sur le diagnostic et le suivi d'activité DB2 pour z/OS

Bonjour,

Vous trouverez ci-dessous plusieurs présentations sur le diagnostic et le suivi d'activité DB2 pour z/OS, disponibles sur le site de l'IDUG :


- DB2 Systems Programming Tools of the Trade
par Linda Hagedorn

- The Diagnosis Manual Secrets and Intrigue
par Linda Hagedorn

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

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

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

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

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

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

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

- Troubleshooting Tuning for Dynamic SQL
par Thomas Baumann

- Memory Management for Dynamic SQL
par Thomas Baumann



Amicalement,

DB2usa.

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

Bonjour,

IBM vient de mettre à disposition un nouveau Redbook intitulé, "DB2 9 for z/OS: Resource Serialization and Concurrency Control, SG24-4725-01" :
http://www.redbooks.ibm.com/Redbooks.nsf/RedbookAbstracts/sg244725.html?Open

Résumé
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.

Sommaire
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


En savoir plus

La première édition de ce Redbook a été publiée en août 1996.


Amicalement,

DB2usa.

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

Bonjour,

IBM vient de mettre à disposition une version de travail d'un nouveau Redbook intitulé, "DB2 9 for z/OS: Using the Utilities Suite, SG24-6289-01" :
http://www.redbooks.ibm.com/Redbooks.nsf/RedpieceAbstracts/sg246289.html?Open

Résumé
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.

Sommaire
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


En savoir plus
La première édition de ce Redbook (août 2001) est toujours disponible :

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


Amicalement,

DB2usa.