Redbook Enterprise Data Warehousing with DB2 9 for z/OS

Bonjour,

IBM vient de mettre à disposition une version de travail d'un nouveau Redbook intitulé, "Enterprise Data Warehousing with DB2 9 for z/OS, SG24-7637-00" :
http://www.redbooks.ibm.com/redpieces/abstracts/sg247637.html?Open

Résumé
Enterprises look more and more to business intelligence to gain a competitive edge. Today’s business intelligence systems incorporate large data warehouses that are consolidated with near-real-time operational data stores (ODS) and continuously updated from multiple sources. An increasing number of users in the enterprise want to access the data warehouse with business intelligence applications with real-time needs.
Due to the inherent characteristics of security, availability, performance, mixed workload management, and the growing portfolio of data warehousing tools and functions provided by IBM, there is a renewed interest in the ability to implement a data warehouse solution on DB2 for z/OS and System z.
In this IBM Redbooks publication we focus on today’s software components on System z and show how they can be leveraged to realize the infrastructure for a full data warehouse solution.
Using a retail business scenario loosely based on the TPC-H benchmark, we guide you through the warehouse implementation steps highlighting the available methods, techniques, and technologies for the deployment of this solution.
This book can be used by business decision makers, architects, implementors, DBAs, and data acquisition specialists to gain a better understanding of how a data warehouse can be designed, implemented and used

Sommaire
Part 1. Data warehouse today
Chapter 1. Definitions
Chapter 2. Evolution of business intelligence
Chapter 3. Why data warehouse on z
Chapter 4. The architecture for the BI solution on System z
Part 2. Design and implementation of our warehouse scenario
Chapter 5. The business scenario and data models
Chapter 6. The system environment
Chapter 7. Functions in DB2 for z/OS for data warehouse
Chapter 8. QReplication and Event Publishing
Chapter 9. Setting up ETL components for data warehouse
Chapter 10. Full load using DataStage
Chapter 11. Incremental update with DataStage
Chapter 12. An Operational BI implementation
Chapter 13. Reporting and Analysis with Cognos BI
Chapter 14. Reporting with IBM DataQuant, QMF, and Alphablox
Part 3. Appendixes
Appendix A. Index compression jobs
Appendix B. Schema definitions
Appendix C. Additional material


Amicalement,

DB2usa.

IDUG Solutions Journal (Printemps 2008)

Bonjour,

Le numéro de printemps 2008 de l'IDUG Solutions Journal est disponible en ligne :

IDUG Solutions Journal Printemps 2008 (format PDF)


Il contient les articles suivants :

- DB2 9 Application-Related Enhancements
par Bill Arledge

- Enterprise Spatial Solution with DB2 9 for z/OS
par Frank Butt, Yu Dong et Gene Fuh

- Getting you out of a BIND
par Roger Miller

- On Recovery Service Levels
par Craig Mullins et Brenda Honeycutt


Amicalement,

DB2usa.

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

Bonjour,

Les articles du numéro d'avril - mai 2008 de z/Journal sont disponibles en ligne : http://www.zjournal.com

- Exploiting DB2 Version 8 and DB2 9 SQL Features for SQL Call Reduction
par Susan Lawson et Daniel Luksetich

- Database Administration Best Pratices
par Lockwood Lyon

- Use Real Time Statistics to automate your Database Maintenance
par Craig Mullins

- JDBC, JDBC Drivers and DB2 9.1
par Allen Jaques


Amicalement,

DB2usa.

Redpaper DB2 for z/OS: Considerations on Small and Large Packages

Bonjour,

IBM vient de mettre à disposition une version de travail d'un nouveau Redpaper intitulé, "DB2 for z/OS: Considerations on Small and Large Packages, REDP-4424-00":
http://www.redbooks.ibm.com/Redbooks.nsf/RedpieceAbstracts/redp4424.html?Open

Résumé
In this Redpaper, after some introductory background information on packages, we discuss the CPU utilization by packages related to two situations: when a small number of short-running SQL statements out of many SQL statements in a large package are executed and when a set of short-running SQL statements out of many different packages are executed. These two specific situations have become critical in some environments due to the performance difference after migration from DB2® V7 to V8. We show the measured CPU across V7, V8 and DB2 9 for z/OS, highlight the improvement provided by DB2 9, and provide some general tips on reducing CPU utilization by packages.


En savoir plus

- 1993 Redbook DB2 Packages: Implementation and Use, GG24-4001-00

Résumé
NOTE: This 1993 Redbook, even though at DB2 V2.3 level, has been requested several times in the last few years since it still contains a large percentage of valid information. It has been made available on the Web on an as is basis, rather than waiting for a future update. Please exercise caution in extrapolating to your current version of DB2 for z/OS.

This document is a comprehensive guide to the package function brought by DB2 V2.3. It considers both the distributed and nondistributed environments. It provides a detailed explanation of the BIND PACKAGE function, including the use of collections and versioning, recommendations on how to implement packages, and discussion of the related performance issues. The document also provides working examples on possible package management solutions.
This document is intended for customers and technical professionals who need to know how to take advantage of the new package function and to administer packages. A knowledge of DB2 V2.3, DB2 V3, and Distributed Relational Database Architecture (DRDA) connectivity is assumed.



- Prochaine Residency du Redbook, DB2 9 for z/OS: Packages Revisited, SD-8Z06

Objectif
It is time to replace DB2 Packages: Implementation and Use, GG24-4001 (1993) with something a bit more current. We review what a package is and why you should use it, then we concentrate on what is happening today with package stability and the demise of DBRMs. We provide guidance on package execution and selection performance. We consider Java and distributed environment.


Tous les renseignements sur les conditions d'une "Residency"
http://publib-b.boulder.ibm.com/Redbooks.nsf/pages/how?Open



Amicalement,

DB2usa