lundi 29 juin 2009

Articles d'IBM Techdocs Library

Bonjour,

Vous trouverez ci-dessous plusieurs articles sur DB2 pour z/OS, disponibles sur le site d'IBM Techdocs Website :

- Identifying the dynamic SQL statement which is causing a lock escalation
par Richard Corrihons

- Tape Authorization for DB2 RESTORE SYSTEM Utility
par Judy Ruby-Brown

- Using DB2 V8 for z/OS RESTORE SYSTEM utility and SET LOG SUSPEND
par Mary Siart

- Asynchronous DB2 data sharing locks not counted
par Judy Ruby-Brown

- IBM DB2 features explored running PeopleSoft Enterprise Applications
par Michael Curtis

- Tuning SAP on DB2 for z/OS on System z
par Mark Gordon

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

- DB2 9 and z/OS XML System Services synergy for distributed workloads
par Judy Ruby-Brown et Akiko Hoshikawa

- Connect WAS to DB2 using JDBC on z/OS
par Bee Fui Soo

- QSGDATA zPARM - Where to find the DB2 Information
par Carolyn Elkins

- DB2 for z/OS – What’s tape got to do with it?
par John Iczkovits


Amicalement,

DB2usa.

Libellés : ,


lundi 22 juin 2009

Présentations sur les utilitaires DB2 d'IBM

Bonjour,

Vous trouverez ci-dessous plusieurs présentations sur les utilitaires DB2 d'IBM, disponibles sur le web :

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

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

- DB2 Backup System and Restore System Enhancements
par Bryan Paulsen

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


More information

- What’s New in DB2 9 for z/OS for Backup and Recovery
par 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


Amicalement,

DB2usa.

Libellés : , ,


lundi 15 juin 2009

Redbook DB2 9 for z/OS : Distributed Architecture

Bonjour,

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

Résumé
Distributed Relational Database Architecture™ (DRDA® ) is a set of protocols that permits multiple local and remote database systems and application programs, to work together. Any combination of relational database management products that use DRDA can be connected to form a distributed relational database management system. DRDA coordinates communication between systems by defining what can be exchanged and how it must be exchanged.
DB2® for z/OS® Distributed Data Facility (DDF) is a built-in component which provides the connectivity to and from other servers or clients over the network. DDF is a full-function DRDA compliant transaction monitor which, equipped with thread pooling and connection management, can support very large networks. Different z/OS workload management priorities can be assigned to different, user-specified classes of DDF-routed application work.
In this IBM® Redbooks® publication we describe how to set up your DDF environment, and how to deploy the DDF capabilities in different configurations, including how to develop applications that access distributed databases.
We also describe a set of more advanced features, such as thread pooling and high availability distributed configurations, in a DB2 data sharing environment, as well as the traces available to you to do performance monitoring and problem determination.
In summary, we show how a high-volume, highly available transactional application can be successfully implemented with a DB2 for z/OS data server accessed by all types of application servers or clients running on the same or different platform.

Sommaire
Part 1. Distributed database architecture and configurations
Chapter 1. Architecture of DB2 distributed systems
Chapter 2. Distributed database configurations using DB2 for z/OS
Part 2. Setup and configuration
Chapter 3. Installation and configuration
Chapter 4. Security
Part 3. Distributed applications
Chapter 5. Application programming
Chapter 6. Data sharing
Part 4. Performance and problem determination
Chapter 7. Performance analysis
Chapter 8. Problem determination
Appendix A. DRDA related maintenance
Appendix B. The TRADE workload
Appendix C. Sample applications
Appendix D. Sample programs for performance analysis


En savoir plus
La première édition de ce Redbook (juin 2003) est toujours disponible :

- Distributed Functions of DB2 for z/OS and OS/390, SG24-5952-00



Amicalement,

DB2usa.

Libellés : ,


lundi 8 juin 2009

Présentations de SQL Adria

Bonjour,

Vous trouverez ci-dessous plusieurs présentations sur DB2 pour z/OS, disponibles sur le site de SQL Adria :

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

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

- Lock Out Your Locking Problems
par Peter Backlund

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

- Desperate Table Designs
par Susan Lawson

- Top 10 Ways to Waste CPU
par Susan Lawson

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

- Clone Table, Hot or not?
par Klaas Brant

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

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


Amicalement,

DB2usa.

Libellés : , , ,


mardi 2 juin 2009

Sondages sur DB2 pour z/OS (2009)









Libellés : , ,