DB2mag: Fall 2007 issue

Hi DB2 user,

Fall 2007 issue of DB2mag is available online: http://www.db2mag.com/db_area/archives/2007/3

- DB2 Makes Being Green Easy by David Beulke
Reusing DB2 resources makes good business--and performance--sense.
http://www.db2mag.com/story/showArticle.jhtml?articleID=202400498

- DB2 DBA: Ultra Availability by Robert Catterall
If you think "never down, don't lose anything" is an impossible goal for DB2, you should think again.
http://www.db2mag.com/story/showArticle.jhtml?articleID=202400154

- DB2 for z/OS Buffer Pools and CPU Time by Robert Catterall
What affect will tuning DB2 for z/OS buffer pools have on CPU time?
http://www.db2mag.com/story/showArticle.jhtml?articleID=202400447

- Optimistic Locking, Part 2 by Bonnie Baker
When it comes to DB2 for z/OS locks, a pessimistic approach rarely pays.
http://www.db2mag.com/story/showArticle.jhtml?articleID=202400443


Regards,

DB2usa.

Redbook DB2 9 for z/OS: New Tools for Query Optimization

Hi DB2 User,

IBM just published a new Redbook, "DB2 9 for z/OS: New Tools for Query Optimization, SG24-7421-00 " :
http://www.redbooks.ibm.com/redpieces/abstracts/sg247421.html

Abstract
The cost-based optimizer of DB2® for z/OS® has continually evolved since its initial inception. Support has included new optimization algorithms, join methods, complex relational data structures such as star schemas. DB2 for z/OS V8 has provided access path visualization and a Statistics Advisor function through a brand new Visual Explain.
DB2 9 for z/OS starts addressing the challenge of reducing cost of ownership by extending query optimization through expert based query and workload analysis, server enhancements and an Index Advisory function. These functions are delivered with two complementary products: DB2 Optimization Service Center and DB2 Optimization Expert.
This book will help you understand the installation, customization and usage aspects of the tools. You will be guided through scenarios of gradually increasing complexity where the functions of the tools will be exploited for query optimization

Table of Contents
Introduction
Chapter 1. DB2 9 for z/OS at a glance
Part 1. Introduction
Chapter 1. Query optimization
Chapter 2. Sample query optimization
Part 2. Installation and customization
Chapter 3. Installing Optimization Service Center
Chapter 4. Installing Optimization Expert
Chapter 5. Tools configuration and customization
Part 3. Critical query detection
Chapter 6. Profile monitoring
Chapter 7. Workloads
Part 4. Solution components
Chapter 8. Query tools
Chapter 9. Statistics Advisor
Chapter 10. Index Advisor
Chapter 11. Access Path Advisor and Query Advisor
Part 5. Tuning scenarios
Chapter 12. Analysis of a problem query
Chapter 13. Analysis of a problem workload
Chapter 14. Common practices
Appendix A. Tips for optimizing very large static workloads
Appendix B. Scheduler
Appendix C. Relevant DB2 objects


Regards,

DB2usa.

IDUG Solutions Journal (Summer 2007)

Hi DB2 user,

Summer 2007 issue of IDUG Solutions Journal is available on line:

IDUG Solutions Journal Summer 2007 (PDF format)


Current issue contains following articles:

- DB2 for z/OS Recovery Resources in Review
by Rick Weaver

- DB2 Stored Procedures or Inline SQL?
by Konstantin Tadenev

- Tips for Copying Catalog Statistics from Production to Test Subsystems
by Billy Sundarrajan

- Regulatory Compliance and Database Archiving
by Craig Mullins




Regards,

DB2usa.