Articles from IBM Techdocs Library

Hi DB2 user,

Here are several articles from IBM Techdocs Library, available on IBM Techdocs Website:


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

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

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

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

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

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

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

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

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

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

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


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.

Redbook DB2 9 for z/OS Distributed Architecture

Hi DB2 User,

IBM just published a draft version of a new Redbook, "DB2 9 for z/OS: Distributed Architecture, SG24-6952-01":
http://www.redbooks.ibm.com/Redbooks.nsf/RedpieceAbstracts/sg246952.html?Open

Abstract
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.

Table of Contents
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


More information

First edition of this Redbook, published in June 2003 is still available:

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


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.