Deux nouveaux Redbooks sur SAP et DB2 9 pour z/OS

Bonjour,

IBM vient de mettre à disposition deux nouveaux Redbooks sur SAP et DB2 9 pour z/OS intitulés :

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

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

Sommaire
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

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

Sommaire
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


Amicalement,

DB2usa.

Présentations sur les chemins d'accès

Bonjour,

Vous trouverez ci-dessous plusieurs présentations sur les chemins d'accès avec DB2 pour z/OS, disponibles sur le site du Tridex User Group :

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

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

Amicalement,

DB2usa.

Redbook DB2 9 for z/OS Technical Overview

Bonjour,

IBM vient de mettre à disposition un nouveau Redbook intitulé, "DB2 9 for z/OS Technical Overview, SG24-7330-00" :
http://www.redbooks.ibm.com/redpieces/abstracts/sg247330.html

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


Sommaire
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


En savoir plus :

- Plusieurs présentations sur DB2 pour z/OS version 9, disponibles sur le site internet d'IBM


Amicalement,

DB2usa.

z/Journal (numéro d'avril-mai 2007)

Bonjour,

Les articles des numéros d'avril-mai 2007 de z/Journal sont disponibles en ligne : http://www.zjournal.com


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

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

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

- Using DB2 Generic Attach for Flexible Database Interfaces
par Susan Lawson et Daniel Luksetich

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

- The Beginning z/OS DB2 DBA
par Lockwood Lyon


Amicalement,

DB2usa.