Redbook DB2 11 for z/OS Technical Overview

Bonjour,

IBM vient de mettre à disposition une version de travail d'un nouveau Redbook intitulé, "DB2 11 for z/OS Technical Overview, SG24-8180-00":
http://www.redbooks.ibm.com/redbooks.nsf/RedpieceAbstracts/sg248180.html?Open

Résumé
IBM DB2 11 for z/OS is the fifteenth release of DB2 for MVS. It brings performance and synergy with the new System z hardware and new opportunities to drive business value in the following areas:
Unmatched reliability, availability, and scalability

Improved data sharing performance and efficiency
Even less downtime by removing growth limitations
Simplified management, improved autonomics, and reduce planned outages
with more online schema changes and utilities improvements
Save money, save time

Aggressive CPU reduction goals
Additional utilities performance and CPU improvements
Save time and resources with new autonomic and application development capabilities
Simpler, faster migration
SQL compatibility, divorce system migration from application migration
Access path stability improvements
Better application performance with SQL and XML enhancements
Enhanced business analytics

Faster, more efficient performance for query workloads
Accelerator enhancements
More efficient inline database scoring enables predictive analytics
The DB2 11 environment is available either for brand new installations of DB2, or for migrations from DB2 10 for z/OS subsystems only.

This IBM Redbooks publication introduces the enhancements made available with DB2 11 for z/OS. The contents help database administrators understand the new functions and performance enhancements, start planning for exploiting the key new capabilities, and justify the investment in installing or migrating to DB2 11.

Sommaire
Chapter 1. DB2 11 for z/OS at a glance
Chapter 2. Synergy with System z
Chapter 3. Scalability
Chapter 4. Availability
Chapter 5. Data sharing
Chapter 6. SQL
Chapter 7. Application enablement
Chapter 8. XML
Chapter 9. Connectivity and administration routines
Chapter 10. Security
Chapter 11. Utilities
Chapter 12. Installation and migration
Chapter 13. Performance
Appendix A. Information on IFCID changes
Appendix B. Summary of relevant maintenance



Amicalement,

DB2usa.

Redpaper Data Studio and DB2 for z/OS Stored Procedures

Bonjour,

IBM vient de mettre à disposition une version de travail d'un nouveau Redbook intitulé, "Data Studio and DB2 for z/OS Stored Procedures, REDP-4717-00" :
http://www.redbooks.ibm.com/Redbooks.nsf/RedpieceAbstracts/redp4717.html?Open

Résumé
Stored procedures can provide major benefits in the areas of application performance, code re-use, security, and integrity. DB2® has offered ever-improving support for developing and operating stored procedures.
This IBM® Redpaper™ is devoted to tools that can be used for accelerating the development and debugging process and in particular to the stored procedure support provided by the latest and fastest evolving IBM product: Data Studio.
We discuss topics related to handling stored procedures. We concentrate on how to use tools for deployment of stored procedures on z/OS®, but most considerations apply to the other members of the DB2 family.
This Redpaper should be considered a major update of Part 6. "Cool tools for an easier life" of the IBM Redbook publication DB2 9 for z/OS Stored Procedures: Through the CALL and Beyond, SG24-7604.

Sommaire
Chapter 1. The IBM Data Studio V2.2.1
Chapter 2. Developing stored procedures with Data Studio
Chapter 3. Additional development features in the Data Studio products
Chapter 4. Debugging Java procedures with Data Studio
Appendix A. Reference material



En savoir plus

- Introducing SYSPROC.ADMIN_INFO_SQL
par Michael Schenker et Thomas Conrad


Amicalement,

DB2usa.

Redbook Extremely pureXML in DB2 10 for z/OS

Bonjour,

IBM vient de mettre à disposition une version de travail d'un nouveau Redbook intitulé, "Extremely pureXML in DB2 10 for z/OS, SG24-7915-00":
http://www.redbooks.ibm.com/Redbooks.nsf/RedpieceAbstracts/sg247915.html?Open

Résumé
The DB2 pureXML feature offers sophisticated capabilities to store, process and manage XML data in its native hierarchical format. By integrating XML data intact into a relational database structure, users can take full advantage of DB2’s relational data management features.
In this IBM Redbooks publication we document the steps for the implementation of a simple but meaningful XML application scenario. We have chosen to provide samples in COBOL and Java language. The purpose being to provide an easy path to follow to integrate the XML data type for the traditional DB2 user.
We have also added considerations for the data administrator and suggested best practices for ease of use and better performance.

Sommaire
Chapter 1. Introduction
Chapter 2. XML and DB2 for z/OS
Chapter 3. Application scenario
Chapter 4. Creating and adding XML data
Chapter 5. Validating XML data
Chapter 6. DB2 SQL/XML programming
Chapter 7. Using XML with Java
Chapter 8. Using XML with COBOL
Chapter 9. Utilities with XML
Chapter 10. XML-related tasks for the DBA
Chapter 11. Performance considerations
Appendix A. Application scenario documents
Appendix B. Additional material



Amicalement,

DB2usa.

Redbook DB2 10 for z/OS Technical Overview

Bonjour,

IBM vient de mettre à disposition une version de travail d'un nouveau Redbook intitulé, "DB2 10 for z/OS Technical Overview, SG24-7892-00":
http://www.redbooks.ibm.com/Redbooks.nsf/RedpieceAbstracts/sg247892.html?Open

Résumé
IBM continues to invest in new features of DB2 for z/OS to make businesses more efficient. DB2 10 delivers great value in this area by achieving up to 10% out-of-the-box CPU savings for traditional workloads and up to 20% out-of-the-box CPU savings for non-traditional workloads, depending on the environments. Synergy with other IBM System z platform components reduces CPU use by leveraging the latest processor improvements and z/OS enhancements. Productivity improvements are provided by new functions available for XML, data warehousing, and traditional on-line TP applications.
We document in this book what is important to prepare DB2 users for the acceptance and exploitation of the new functions. The goal is to highlight the major new functions, document installation requirements, and migration considerations.


Sommaire
Chapter 1. DB2 10 for z/OS at a glance
Chapter 2. Synergy with System z
Chapter 3. Scalability
Chapter 4. Availability
Chapter 5. Data sharing
Chapter 6. SQL
Chapter 7. Application enablement
Chapter 8. XML
Chapter 9. Connectivity and administration routines
Chapter 10. Utilities
Chapter 11. Security
Chapter 12. Installation and migration
Chapter 13. Performance
Appendix A. Information on IFCID changes



Amicalement,

DB2usa.

Présentations de John Campbell

Bonjour,

Vous trouverez ci-dessous plusieurs présentations de John Campbell sur DB2 pour z/OS, disponibles sur les sites d'IBM et Tridex :

- Optimising DB2 for z/OS System Performance Using DB2 Statistics Trace
par John Campbell

- DB2 for z/OS Optimizing Insert Performance Part 1
par John Campbell

- DB2 for z/OS Optimizing Insert Performance Part 2
par John Campbell

- DB2 10 for z/OS Technical Overview
par John Campbell

- DB2 10 for z/OS Performance Preview
par John Campbell


En savoir plus

- Best Practices for DB2 Software Maintenance
par John Campbell et Michael Dewert

- DB2 9 for z/OS: Migration and Experiences
par Maja Kovac



Amicalement,

DB2usa.

Numéro d'automne 2010 de DB2mag

Bonjour,

Le numéro d'automne 2010 de DB2mag est disponible en ligne :

- DB2mag automne 2010

- Archives de DB2mag (depuis printemps 2009)
- Archives de DB2mag (hiver 1996-printemps 2009)


DB2mag a changé de nom : IBMDatabasemag, puis IBM Data Management magazine.



- Is There Anything zEnterprise Can't Do?
IBM zEnterprise runs your business—any system, any application.
par Dave Beulke

- What's New: DB2 10 for z/OS
Dramatic CPU savings and data availability enhancements, check. But have you seen the new temporal data support?
par Terrie Jacopi

- DB2 Indexes and Query Performance: Part 1
Weigh costs and benefits when considering additional indexes.
par Robert Catterall

- Does the Order of SQL Predicates Matter?
Rearranging WHERE clause predicates may be an exercise in futility.
par Bonnie Baker



Amicalement,

DB2usa.

Présentations de Peter Vanroose sur DB2 pour z/OS

Bonjour,

Vous trouverez ci-dessous plusieurs présentations de Peter Vanroose sur DB2 pour z/OS, disponibles sur le site d'Abis :

- DB2 9 New Datatypes and SQL Functions: Blessing or Curse?
par Peter Vanroose

- Experiences with stored procedures, triggers and XML on DB2 version 8 for z/OS
par Peter Vanroose

- Common Table Expressions in DB2 for z/OS: More powerful than you imagine
par Peter Vanroose


En savoir plus

- XML support in DB2 V9
par Ludo Van den dries



Amicalement,

DB2usa.

Numéros de printemps et d'été 2010 de DB2mag

Bonjour,

Les numéro de printemps et d'été 2010 de DB2mag sont disponibles en ligne :

- DB2mag été 2010
- DB2mag printemps 2010

- Archives de DB2mag (depuis printemps 2009)
- Archives de DB2mag (hiver 1996-printemps 2009)


DB2mag a changé de nom : IBMDatabasemag, puis IBM Data Management magazine.

- DB2 10 for z/OS
More details emerge about new features that can slash CPU costs.
par Dave Beulke

- When Data Wears Out Its Welcome
Are cold data records gumming up the performance of your servers?
par Robert Catterall

- Reducing Conversations with DB2 for z/OS: Part 2
More tried-and-true basics and a few new bells and whistles.
par Bonnie Baker


- Maintenance Makes Money
Five ways to cut database costs - just by paying attention.
par Sheryl Larsen

- Real-Life DB2 Superheroes
IBM puts DB2 powers on display at the IDUG conference.
par David Beulke

- You Want to Govern What?
A database guy discovers data governance.
par Robert Catterall

- Reducing Conversations with DB2 for z/OS: Part 3
Different ways of thinking about ordinary things.
par Bonnie Baker


Amicalement,

DB2usa.

Redbook DB2 9 for z/OS and Storage Management

Bonjour,

IBM vient de mettre à disposition une version de travail d'un nouveau Redbook intitulé, "DB2 9 for z/OS and Storage Management, SG24-7823-00" :
http://www.redbooks.ibm.com/Redbooks.nsf/RedpieceAbstracts/sg247823.html?Open

Résumé
This book addresses both the storage administrator and the DB2 administrator. The DB2 administrator will find information on how to use DFSMS for managing DB2’s data sets. The storage administrator will find information on the characteristics of DB2 data sets and how DB2 uses the disks. We describe optimal use of disk storage functions in DB2 for z/OS environments which can best exploit the synergy with I/O subsystem on System z.

The addressed topics include the following:
- Using SMS to manage DB2 catalog, log, data, indexes, image copies, archives, workfiles.
- Taking advantage of FlashCopy for DB2 utilities, striping, copypools.
- Setting page sizes and using sliding allocation.
- PAV, MA, MIDAW, EF, EA, EAV. What they are and why they are good for you.
- Compressing data and indexes and the use disk and tape for very large data sets.
- Backup and Restore, and remote copy services recommendations.

Sommaire
Chapter 1. Introduction
Chapter 2. Disk and tape environment overview
Chapter 3. DB2 storage objects
Chapter 4. System managed DB2 data
Chapter 5. Implementing SMS for a DB2 environment
Chapter 6. DB2 I/O performance and monitoring
Chapter 7. DB2 I/O operations
Appendix A. Frequently asked questions



Amicalement,

DB2usa.

z/Journal (numéro de juin à juillet 2010)

Bonjour,

Les articles du numéro de juin à juillet 2010 de z/Journal sont disponibles en ligne : http://www.mainframezone.com/z-journal

Note: z/Journal est désormais présent à l'adresse suivante : www.mainframezone.com .

- DB2 for z/OS SQL Performance Choices
par Dan Luksetich

- Reorganize DB2 on z/OS Objects to Save Time and Money
par Peter Plevka

- Top-10 Features of DB2 10 for z/OS: A Preview
par Willie Favero

- The 10 Database Commandments
par Craig Mullins


Amicalement,

DB2usa.