Two new Redbooks about SAP and DB2 9 for z/OS

Hi DB2 User,

IBM just published two new Redbooks about SAP and DB2 9 for z/OS:

- "Enhancing SAP solutions by using DB2 9 for z/OS, SG24-7239-00"
http://www.redbooks.ibm.com/redpieces/abstracts/sg247239.html

Abstract
This book presents the SAP features for DB2 for z/OS V9 and for DB2 Connect V9.1. It demonstrates the best ways to exploit these new features to achieve performance benefits.


Table of Contents
1. DB2 9 for z/OS new and improved functions overview
2. Facilitating DB2 subsystem cloning
3. New and enhanced data types
4. New and enhanced index capabilities
5. Reporting statistical data
6. Security
7. Optimized recovery
8. New functions for SAP high availability in DB2 9 for z/OS
9. DB2 Connect version 9.1
10. SAP with System z Integrated Information Processor (zIIP)
11. Performance topics
12. What's new in SQL
13. Administration
14. Enhancements to manage and administer SAP on DB2 9 for z/OS
15. Geographically dispersed parallel sysplex (GDPS)
16. Benefits of DB2 0 for z/OS to SAP BI
Appendix A. Migration Techniques
Appendix B. Project test environment
Appendix C. IBM System z9 zIIP Measurements
Appendix D. Workfile and temporary tablespace changes



- "Best Practices for SAP BI using DB2 9 for z/OS, SG24-6489-01"
http://www.redbooks.ibm.com/redpieces/abstracts/sg246489.html

Abstract
Clients will want to know how to exploit the new features of both DB2 9 for z/OS and SAP in their SAP BW environments.
This IBM Redbook will describe the benefits of DB2 V9 for SAP Business Information Warehouse. It will cover best practices, and provides performance and tuning recommendations.
SAP Business Information Warehouse is the central reporting tool for almost all SAP business solutions. It is based on building blocks called InfoObjects that contain data about customers, sales, and business information. InfoObjects include InfoSources, ODS objects, and InfoCubes. The business intelligence solution from IBM and SAP can help you aggregate and leverage this information, giving you a system-wide view of your business data and delivering it across your enterprise to support sound business decisions.
However, this structure can lead to slow performance if the system is not set up and managed according to good database principles. This redbook describes best practices for this product on a zSeries platform, and provides performance and tuning recommendations for loading and querying data. It also addresses general system administration and troubleshooting.
The audience for this redbook includes SAP and DB2 administrators. Knowledge of these products and of the z/OS environment is assumed.


Table of Contents
Chapter 1. Introduction
Chapter 2. Overview of SAP BI and related data
Chapter 3. Top ten SAP BW recommendations
Chapter 4. Benefits of DB2 9 for SAP BI
Chapter 5. Best practices for PSA
Chapter 6. Best practices for InfoCubes
Chapter 7. Best practices for DataStore
Chapter 8. Tips for SQL efficiency
Chapter 9. Query performance
Chapter 10. New features and functions of SAP BI
Chapter 11. Fast and easy system cloning
Chapter 12. Concepts, activities and terminology
Appendix A. Glossary for SAP BI
Appendix B. Sap BW installation and checks under DB2 and z/OS
Appendix C. SAP BW OSS Notes


Regards,

DB2usa.

Access Path Selection presentations

Hi DB2 user,

Here are several presentations about Access Path Selection with DB2 for z/OS, available on Tridex User Group Website:

- Why did The Optimizer choose that Path - Part 1
- Why did The Optimizer choose that Path - Part 2
by Terry Purcell

- EXPLAIN tables come out of the closet
- How an Access Path gets selected
by Gerald Hodge


Regards,

DB2usa.

Redbook DB2 9 for z/OS Technical Overview

Hi DB2 User,

IBM just published a new Redbook, "DB2 9 for z/OS Technical Overview, SG24-7330-00" :
http://www.redbooks.ibm.com/redpieces/abstracts/sg247330.html

Abstract
IBM® DATABASE 2 Version 9.1 for z/OS® (DB2® 9 for z/OS throughout this publication) is the thirteenth release of DB2 for MVS™. It brings improved synergy with the zSeries® hardware and more opportunities drive business value in the following areas:

- Business insight innovations
- Cost savings through optimized innovations
- Business resiliency innovations

This IBM Redbooks publication introduces the enhancements made available with DB2 9 for z/OS. Its scope is to help DB2 for z/OS users understand the functions offered by DB2 9, justify their investment in installing or migrating, and start plannig for prerequisites in exploiting the key new capabilities.

Table of Contents
Introduction
Chapter 1. DB2 9 for z/OS at a glance
Part 1. Subsystem functions
Chapter 2. zSynergy
Chapter 3. Scalability
Chapter 4. Availability
Chapter 5. Data sharing
Part 2. Application functions
Chapter 6. SQL
Chapter 7. Application enablement
Chapter 8. XML
Chapter 9. e-business and connectivity
Part 3. Operations and performance
Chapter 10. Security
Chapter 11. Utilities
Chapter 12. Installation and migration
Chapter 13. Performance
Appendix A. DB2 Tools for z/OS

More information
- Several IBM presentations about DB2 9 for z/OS are available on IBM's website


Regards,

DB2usa.

z/Journal (April - May 2007 issue)

Hi DB2 user,

Articles from April - May 2007 issues of z/Journal are available online: http://www.zjournal.com


- Myth-Busting DB2 Version 8 CPU Regression
by Willie Favero

- DB2 and CICS Are Moving On: Avoiding Potholes on the Yellow Brick Road to an LE Migration
by Carl Gehr Jr. and Nate Murphy

- Performance: Why I Want DB2 9 for z/OS
by David Beulke

- Using DB2 Generic Attach for Flexible Database Interfaces
by Susan Lawson and Daniel Luksetich

- If You Ain’t 8, You’re Late
by Craig Mullins

- The Beginning z/OS DB2 DBA
by Lockwood Lyon


Regards,

DB2usa.