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.

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.

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.

Redbooks 2004-2010 et plus encore

Bonjour,

Voici une liste de redbooks et de redpapers sur DB2 pour z/OS parus ou mis à jour entre 2004 et 2010, disponibles sur le site web d'IBM :

Les apports de la version 9
- DB2 9 for z/OS Technical Overview, SG24-7330-00
- DB2 9 for z/OS Performance Topics, SG24-7473-00

- DB2 9 for z/OS: Using the Utilities Suite, SG24-6289-01

- DB2 9 for z/OS: New Tools for Query Optimization, SG24-7421-00

- DB2 9 for z/OS: Packages Revisited, SG24-7688-00
- DB2 for z/OS: Considerations on Small and Large Packages, REDP-4424-00
- DB2 9 for z/OS: Resource Serialization and Concurrency Control, SG24-4725-01

- DB2 9 for z/OS: Buffer Pool Monitoring and Tuning, REDP-4604-00
- DB2 9 for z/OS: Backup and Recovery I/O Related Performance, REDP-4452-00

- Index Compression with DB2 9 for z/OS, REDP-4345-00
- How does the MIDAW facility improve the performance ... using DB2?, REDP-4201-00
- Disk storage access with DB2 for z/OS, REDP-4187-00

- Coupling Facility Performance: A Real World Perspective, REDP-4014-00
- DB2 9 for z/OS Data Sharing: Distributed Load Balancing, REDP-4449-00

- DB2 9 for z/OS Stored Procedures: Through the CALL and Beyond, SG24-7604-00
- DB2 9 for z/OS: Deploying SOA Solutions, SG24-7674-00

- DB2 9 for z/OS Distributed Architecture, SG24-6952-01
- DB2 9 for z/OS: Configuring SSL for Secure Communications, REDP-4630-00

- Enterprise Data Warehousing with DB2 9 for z/OS, SG24-7637-00
- 50 TB Data Warehouse Benchmark on IBM System z, SG24-7663-00

- LOBs with DB2 for z/OS: Stronger and Faster, SG24-7270-00
- Securing DB2 and Implementing MLS on z/OS, SG24-6480-01

- Enhancing SAP by Using DB2 9 for z/OS, SG24-7239-00
- Best Practices for SAP BI using DB2 9 for z/OS, SG24-6489-02


Les apports de la version 8
- Version 8: Everything You Ever Wanted to Know , ... and More, SG24-6079-00
- DB2 UDB for z/OS Version 8 Performance Topics, SG24-6465-00

- Design Guidelines for High Performance and Availability, SG24-7134-00

- DB2 V8: Through the Looking Glass and What SAP Found There, SG24-7088-00
- DB2 UDB V8 and WebSphere V5 Performance Tuning and Operations, SG24-7068-00

- The Business Value of DB2 UDB for z/OS, SG24-6763-00


Autres sujets
- DB2 for z/OS: Data Sharing in a Nutshell, SG24-7322-00
- Data Integrity with DB2 for z/OS, SG24-7111-00
- Disaster Recovery with DB2 UDB for z/OS, SG24-6370-00

- Powering SOA with IBM Data Servers, SG24-7259-00
- DB2 for z/OS and OS/390: Ready for Java, SG24-6435-00
- DB2 for z/OS and WebSphere: The Perfect Couple, SG24-6319-00

- DB2 for z/OS and OS/390 Version 7 Using the Utilities Suite, SG24-6289-00


Tips
- News on DB2 Optimization Expert and DB2 Optimization Service Center, TIPS0673
- Copying the DB2 UDB for z/OS Catalog Using the COPY Utility, TIPS0587
- SAP BW and DB2 for z/OS V8, TIPS0577


Information Center
- DB2, IMS and IBM Tools
- DB2 IFCIDs description (Tivoli OMEGAMON XE for DB2 Performance Expert on zOS)
- DB2 component (Tivoli Decision Support for z/OS : TDS)

- z/OS basic skills
- z/OS 1.11
- z/OS 1.11 (HTML and PDF)
- Enterprise COBOL and PL/I for z/OS Compilers
- DB2 for Linux, Unix and Windows

- z/OS Concepts (PDF)
- z/OS LookAt (HTML)


Série : ABCs of z/OS System Programming
- Vol 1, z/OS operating system and the hardware architecture, SG24-6981-01
- Vol 2, z/OS implementation and maintenance, defining subsystems, SG24-6982-01
- Vol 3, DFSMS, data set basics, storage management, VSAM, ... , SG24-6983-02
- Vol 4, Vol 4, SNA, TCP/IP, VTAM, UNIX System Services, LE, SG24-5654-01
- Vol 5, Sysplex, System Logger, RRS, GRS, ARM, GDPS, SG24-6985-01
- Vol 6, Introduction to security, RACF , Digital certificates, ... , SG24-6986-00
- Vol 7, Printing in a z/OS environment, Infoprint Server, ... , SG24-6987-01
- Vol 8, An introduction to z/OS problem diagnosis, SG24-6989-04
- Vol 9, z/OS UNIX System Services , SG24-6989-03
- Vol 10, z/Architecture, LPAR concepts, HCD, and DS8000, SG24-6990-03
- Vol 11, Capacity planning, performance, WLM, RMF, and SMF, SG24-6327-00
- Vol 12, Workload Manager, SG24-7621-00
- Vol 13, JES3, SG24-7717-00


Série : Introduction to the New Mainframe
- z/OS Basics, SG24-6366-00
- Large-Scale Commercial Computing, SG24-7175-00
- Networking, SG24-6772-00
- Security, SG24-6776-00


Bonne lecture.

Amicalement,

DB2usa.

Redbook DB2 9 for z/OS: Resource Serialization and Concurrency Control

Bonjour,

IBM vient de mettre à disposition un nouveau Redbook intitulé, "DB2 9 for z/OS: Resource Serialization and Concurrency Control, SG24-4725-01" :
http://www.redbooks.ibm.com/Redbooks.nsf/RedbookAbstracts/sg244725.html?Open

Résumé
Locking is the generic term used to refer to the database management system function that is required for managing interprocess concurrency and maintaining data integrity. However, locking is just one of the serialization mechanisms available in IBM DB2 for z/OS. DB2 uses different mechanisms for serialization to achieve its goal of maximizing concurrency without losing integrity with a minimum cost in CPU, I/O, and storage resources.
In this IBM Redbooks publication, we review and explore the different serialization mechanisms used in DB2, such as transaction (DML) locking, claims and drains, restrictive states, latching, and optimistic serialization.
This book was written for application developers in order to help them better understand serialization mechanisms and how they influence application design decisions.

Sommaire
Part 1. Concurrency and integrity
Chapter 1. Serialization
Chapter 2. Transaction locking
Chapter 3. Serialization techniques
Part 2. Application concurrency and lock optimization
Chapter 4. Database design considerations
Chapter 5. Application design
Chapter 6. Utilities, commands, and SQL
Chapter 7. System considerations
Part 3. Monitoring and problem determination
Chapter 8. Identifying locking and concurrency problems
Chapter 9. Analyzing concurrency problems
Part 4. Data sharing
Chapter 10. Global locking
Chapter 11. Monitoring data sharing locking activity
Chapter 12. Database and application design in data sharing
Appendix A. System topology and workload


En savoir plus

La première édition de ce Redbook a été publiée en août 1996.


Amicalement,

DB2usa.

Redbook DB2 9 for z/OS: Using the Utilities Suite

Bonjour,

IBM vient de mettre à disposition une version de travail d'un nouveau Redbook intitulé, "DB2 9 for z/OS: Using the Utilities Suite, SG24-6289-01" :
http://www.redbooks.ibm.com/Redbooks.nsf/RedpieceAbstracts/sg246289.html?Open

Résumé
IBM continues to enhance the functionality, performance, availability, and ease of use of DB2 utilities.
This IBM Redbooks publication is the result of a project dedicated to the current DB2 Version 9 Utilities Suite product. It provides information on introducing the functions which help in setting up and invoking the utilities in operational scenarios, it shows how to optimize concurrent execution of utilities, collect information for triggering utilities execution, and considerations on partitioning.
It also describes the new functions provided by several utilities for SHARE LEVEL CHANGE execution which maximize availability and the exploitation of DFSMS constructs by the BACKUP and RESTORE SYSTEM utilities.
This book concentrates on the enhancements provided by DB2 UDB for z/OS Version 8 and DB2 for z/OS Version 9. It impicitly assumes a basic level of familiarity with the utilities as provided by DB2 for z/OS and OS/390 Version 7.

Sommaire
Part 1. Introduction
Chapter 1. Introduction
Chapter 2. Backup and Restore utilities
Part 2. Planning for DB2 utilities
Chapter 3. Managing partitions
Chapter 4. Simplifying utilities with Wildcarding and Templates
Chapter 5. Performance via parallelism of executions
Chapter 6. Invoking and controlling executions
Chapter 7. Sort processing
Part 3. Executing DB2 utilities
Chapter 8. Loading and unloading data
Chapter 9. Reorganizing data
Chapter 10. Copying data
Chapter 11. Recoverying data
Chapter 12. Gathering statistics
Chapter 13. Verifying data consistency
Part 4. Managing and optimizing DB2 utilities
Chapter 14. Operational considerations
Chapter 15. DB2 Tools
Appendix A. Utilities related maintenance
Appendix B. Sample
Appendix C. Additional material


En savoir plus
La première édition de ce Redbook (août 2001) est toujours disponible :

- DB2 for z/OS and OS/390 Version 7 Using the Utilities Suite, SG24-6289-00


Amicalement,

DB2usa.

Redpaper DB2 9 for z/OS : Configuring SSL for Secure Client-Server Communications

Bonjour,

IBM vient de mettre à disposition un nouveau Redpaper intitulé, "DB2 9 for z/OS: Configuring SSL for Secure Client-Server Communications, REDP-4630-00":
http://www.redbooks.ibm.com/Redbooks.nsf/RedbookAbstracts/redp4630.html

Résumé
This IBM Redpaper provides information about how to setup and configure DB2 9 for z/OS with Secure Sockets Layer (SSL) using the z/OS V1R10 Communications Server: IP Application Transparent -Transport Layer Security (AT-TLS) services. This paper also covers the basic configuration steps for configuring SSL support for non-Java DB2 clients and IBM Data Server Driver for JDBC and SQLJ type 4 connectivity clients to access a DB2 9 for z/OS server.
The intended audience for this paper includes network and security administrators and database administrators who want to setup and configure SSL support for DB2 9 for z/OS.

Sommaire
- Overview of SSL and IP AT-TLS
- Configuring DB2 9 for z/OS server with SSL support
- Configuring DB2 9 for z/OS requester with SSL support
- Configuring Java applications using IBM Data Server Driver for JDBC and SQLJ to use SSL
- Configuring non-Java DB2 clients for Linux, UNIX, and Windows to use SSL
- Configuring remote client applications to use SSL via a DB2 Connect server for Linux, UNIX, and Windows



Amicalement,

DB2usa.

Redpaper DB2 9 for z/OS: Buffer Pool Monitoring and Tuning

Bonjour,

IBM vient de mettre à disposition une version de travail d'un nouveau Redpaper intitulé, "DB2 9 for z/OS: Buffer Pool Monitoring and Tuning, REDP-4604-00":
http://www.redbooks.ibm.com/redpieces/abstracts/redp4604.html

Résumé
DB2® buffer pools are a key resource for ensuring good performance.This is becoming increasingly important as the difference between processor speed and disk response time for a random access I/O widens in each new generation of processor.A System z® processor can be configured with large amounts of storage which, if used wisely, can help compensate by using storage to avoid synchronous I/O.
The paper is intended to be read by DB2 system administrators but may be of interest to any z/OS® performance specialist. It is assumed that the reader is familiar with DB2 and performance tuning.

Sommaire
- Describe the functions of the DB2 buffer pools
- Introduce a number of metrics for read and write performance of a buffer pool
- Make recommendations on how to set up and monitor the DB2 buffer pools
- Provide results from using this approach at a number of customers


En savoir plus

- Tuning DB2 at CGU Life
par Mike Barnard

- DB2 for z/OS Bufferpool Management
par Mike Bracey

- Buffer Pool Tuning for the New Large Memory World
par Joel Goldstein

- Redbook DB2 for OS/390 Capacity Planning, SG24-2244-00


Amicalement,

DB2usa.

Redbook DB2 9 for z/OS : Distributed Architecture

Bonjour,

IBM vient de mettre à disposition une version de travail d'un nouveau Redbook intitulé, "DB2 9 for z/OS: Distributed Architecture, SG24-6952-01" :
http://www.redbooks.ibm.com/Redbooks.nsf/RedpieceAbstracts/sg246952.html?Open

Résumé
Distributed Relational Database Architecture™ (DRDA® ) is a set of protocols that permits multiple local and remote database systems and application programs, to work together. Any combination of relational database management products that use DRDA can be connected to form a distributed relational database management system. DRDA coordinates communication between systems by defining what can be exchanged and how it must be exchanged.
DB2® for z/OS® Distributed Data Facility (DDF) is a built-in component which provides the connectivity to and from other servers or clients over the network. DDF is a full-function DRDA compliant transaction monitor which, equipped with thread pooling and connection management, can support very large networks. Different z/OS workload management priorities can be assigned to different, user-specified classes of DDF-routed application work.
In this IBM® Redbooks® publication we describe how to set up your DDF environment, and how to deploy the DDF capabilities in different configurations, including how to develop applications that access distributed databases.
We also describe a set of more advanced features, such as thread pooling and high availability distributed configurations, in a DB2 data sharing environment, as well as the traces available to you to do performance monitoring and problem determination.
In summary, we show how a high-volume, highly available transactional application can be successfully implemented with a DB2 for z/OS data server accessed by all types of application servers or clients running on the same or different platform.

Sommaire
Part 1. Distributed database architecture and configurations
Chapter 1. Architecture of DB2 distributed systems
Chapter 2. Distributed database configurations using DB2 for z/OS
Part 2. Setup and configuration
Chapter 3. Installation and configuration
Chapter 4. Security
Part 3. Distributed applications
Chapter 5. Application programming
Chapter 6. Data sharing
Part 4. Performance and problem determination
Chapter 7. Performance analysis
Chapter 8. Problem determination
Appendix A. DRDA related maintenance
Appendix B. The TRADE workload
Appendix C. Sample applications
Appendix D. Sample programs for performance analysis


En savoir plus
La première édition de ce Redbook (juin 2003) est toujours disponible :

- Distributed Functions of DB2 for z/OS and OS/390, SG24-5952-00



Amicalement,

DB2usa.

Redbook 50 TB Data Warehouse Benchmark on IBM System z

Bonjour,

IBM vient de mettre à disposition une version de travail d'un nouveau Redbook intitulé, "50 TB Data Warehouse Benchmark on IBM System z, SG24-7674-00" :
http://www.redbooks.ibm.com/Redbooks.nsf/RedpieceAbstracts/sg247674.html?Open

Résumé
Customers have a strong interest in the scalability of data warehousing solutions on the IBM System z platform using DB2 for z/OS. Since business intelligence environments continue to grow, this book explores the scaling and management of data in sizes beyond 50 TB. We explore the architectural software components that enable us to manage a data warehouse of this magnitude, including the Cognos product set.
The objective of our 50TB study was to test System z scalability in a business intelligence environment and to develop the best practices of managing large data warehouses. The IBM System z was proven to scale to larger volumes, manage a mixed workload, lower the cost of a BI solution using zIIPs, and increase performance by using hardware compression.

Sommaire
Chapter 1. Introduction
Chapter 2. Data warehousing overview
Chapter 3. Why System z and IBM storage for Data Warehousing
Chapter 4. Configuration
Chapter 5. VLDB build tips and pointers
Chapter 6. Balancing a data warehouse
Chapter 7. Data and index compression
Chapter 8. Scalability
Chapter 9. Leveraging materialized query tables
Chapter 10. Reporting and analysis with Cognos
Chapter 11. Workload management
Chapter 12. Extract, transform, and load
Chapter 13. Summary: observations and conclusions



Participez à l'écriture des prochains Redbooks DB2 pour z/OS

- Data Studio - Using Integrated Data Management to Meet SLO, SD-9S04-R01

- DB2 9 for z/OS: Resource Serialization and Concurrency Control, SD-9Z03-R01
- DB2 9 for z/OS: The Utilities Suite, SD-9Z02-R01


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




Regards,

DB2usa.

Redbook DB2 9 for z/OS: Packages Revisited

Bonjour,

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

Résumé
DB2® packages were introduced with DB2 V2.3 in 1993. During the 15 years that have elapsed, a lot has changed. In particular, there is a more widespread use of distributed computing, Java™ language, new tools and upgrades in the platform software and hardware. The best practices back then just may not be optimal today. In this book, we take a fresh look to bringing packages into the 21st century.

We begin with an overview of packages and explain the advantages of using packages. Since DBRM-based plans have been deprecated in DB2 9, you need to convert to packages if you did not use packages already. We provide guidance on using a DB2 provided function to convert from DBRM-based plans to packages.

We re-examine the application development frameworks for packages: program preparation, package set up and execution. For distributed applications we include a discussion of a utility to identify and remove deprecated private protocol and converting to DRDA as well as an introduction to the new pureQuery function of Data Studio. We also discuss common problems and their resolutions.
We then explore administration and operational activities dealing with packages, including security, access path management (where we discuss the newly introduced package stability feature to allow for a seamless fallback) and management and performance aspects. The appendix part includes useful queries and mentions tools for managing packages effectively.


Sommaire
Part 1. What are packages?
Chapter 1. Packages overview - ready for review
Chapter 2. BIND options
Chapter 3. Packages execution flow
Chapter 4. Conversion to packages
Part 2. Using packages
Chapter 5. Developing applications
Chapter 6. Developing distributed applications
Chapter 7. Common problems and resolutions
Part 3. Managing packages
Chapter 8. Packages administration
Chapter 9. Security considerations
Chapter 10. Access path management
Chapter 11. Performance considerations
Appendix A. Catalog tables and EXPLAIN tables
Appendix B. Useful queries
Appendix C. DSNZPARMs, trigger packages, and tools
Appendix D. Sample database environment


Amicalement,

DB2usa.

Technotes (FAQ), annonce IBM et prochaines residencies

Bonjour,

Voici de nouvelles FAQs (Technotes) parues récemment sur le site web d'IBM :

- Troubleshooting access-path-related performance problems
- BIND ERROR SQLCODE109 TOKENS=INTO in Version 9 compatibilty mode
- What data should I collect first for DB2 performance analysis?
- CAST to DOUBLE is an approximation
- DSNL030I: How do I trace the TCP/IP address to catch an unauthorized user?


Annonce IBM 908-280 du 2 décembre 2008

- DB2 for z/OS Version 8 prévu d'être retiré du marketing le 8 septembre 2009
- IBM Software Support Lifecycle


Participez à l'écriture des prochains Redbooks DB2 pour z/OS

- DB2 9 for /OS: Distributed Architecture Functions and Scenarios, SD-9Z01-R01
- DB2 9 for z/OS: The Utilities Suite, SD-9Z02-R01
- DB2 9 for z/OS: Resource Serialization and Concurrency Control, SD-9Z03-R01


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



Regards,

DB2usa.

Redbook DB2 9 for z/OS: Deploying SOA Solutions

Bonjour,

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

Résumé
Flexibility in business has become equal in importance with operational efficiency. Service-oriented architecture (SOA) can help businesses respond more quickly and cost-effectively to the changing market conditions by promoting reuse and interconnection of existing IT assets rather than time-consuming and costly reinvention.
SOA has been the top fashionable topic in IT for a few years now. This is because there is a consensus of opinions among enterprise architects that SOA is the key to making the IT department a catalyst for growth and innovation.
DB2® for z/OS® integrates with Web services, acts as a service provider and lets SQL applications consume Web services. DB2 customers can make their legacy DB2 applications easily available in a SOA architecture and by supporting natively XML data type DB2 allows building new application exploiting the strategic characteristics XML provides.
This IBM® Redbooks® publication helps you get started with SOA by showing the implementation of the minimum requirements: The creation of Web services that allow access to data that is stored in data servers or applications and the realization of interaction services for business to consumer integration. We do that utilizing functions provided by DB2 for z/OS, like pureXML™ and SOAP UDFs, in conjunction with those provided by Data Studio, DataPower® , and WebSphere® Application Server.

Sommaire
Part 1. Introduction to SOA solutions with DB2
Chapter 1. Service-oriented architecture
Chapter 2. The role of DB2 for z/OS
Chapter 3. Deploying an SOA solution: The components
Chapter 4. Getting started with Web services
Part 2. SOA and DB2 deployment scenarios
Chapter 5. Business scenarios
Chapter 6. DB2 as Web service provider with XML and DataPower - Scenario 1
Chapter 7. DB2 as Web services provider with DataPower and WAS - Scenario 2
Chapter 8. DB2 as Web services consumer with SOAP UDFs - Scenario 3
Part 3. Operational scenarios
Chapter 9. Security scenario
Chapter 10. End to end monitoring scenario
Appendix A. The test environment
Appendix B. DB2 WebSphere MQ UDFs
Appendix C. XML Firewall
Appendix D. DataPower solutions
Appendix E. Monitoring scenario set-up
Appendix F. Additional material


Amicalement,

DB2usa.

Redpaper DB2 9 for z/OS: Backup and Recovery I/O Related Performance Considerations

Bonjour,

IBM vient de mettre à disposition un nouveau Redpaper intitulé, "DB2 9 for z/OS: Backup and Recovery I/O Related Performance Considerations, REDP-4452-00":
http://www.redbooks.ibm.com/abstracts/redp4452.html?Open

Résumé
This IBM® Redpaper provides best practices and I/O-related performance considerations for backup and recovery using DB2® 9 for z/OS®. It describes some guidelines for DB2 for z/OS backup and recovery, then it discusses performance considerations that may be used to predict recovery time, which can be used, in turn, to adjust backup frequencies or methods.

Sommaire
This Redpaper has the following sections:
“ Planning the backup strategy” on page 2
This section deals with the series of decisions which a backup strategy involves, beginning on the day that disk and tape hardware are purchased. Configuring the DASD hardware is also the subject of Part 1. At this time some fundamental decisions are made that affects both the probability of a hardware failure and the amount of time that it takes you to recover from that failure. The decisions made at this time also affect the performance of online transaction workloads. Part 1 also explains and contrasts the two major types of backups, image copies and system level backups.
“ Recovery strategies” on page 16
This section presents some recovery strategies for recovering the entire DB2 system to the current point in time after a hardware failure. This part explains the factors that affect the recovery time and how to predict the recovery time. Armed with the knowledge of how long recovery will take, it is easier to develop an effective backup strategy that enables you to achieve the recovery time objectives.
“ Backup strategies” on page 22
This section analyzes hypothetical workload and failure scenarios: we examine a scenario of hardware failure and two scenarios involving programming errors. We examine related recovery to the current point in time and to a prior point in time.
This paper references and builds upon the IBM Redbooks® publication Disaster Recovery with DB2 UDB for z/OS, SG24-6370, which focused on disaster recovery, but also introduced some concepts about FlashCopy® and system level backups. That book was written prior to DB2 9 for z/OS, which added some new features that use FlashCopy and system level backups, and prior to the availability of the DS8000™ . This paper contains a discussion of DB2 9 features and DS 8000 functions.


En savoir plus sur Disaster Recovery

- Redbook Disaster Recovery with DB2 UDB for z/OS, SG24-6370-00

Résumé
DB2 for z/OS is the database of choice for critical data for many enterprises. It is becoming more and more important to protect this data in case of disaster and to be able to restart with a consistent copy of the DB2 data as quick as possible and with minimal losses.
A broad range of functions can be used for the disaster recovery of DB2 subsystems. The traditional DB2 based solution consists of safe keeping and restoring image copies and logs. More general functions, applicable not only to DB2 data, but to the whole system, are hardware related, such as tape vaulting or disk volumes mirroring. Other functions are specific to DB2 such as the Tracker Site. There are also products providing replication capabilities which can be used for specific propagation requirements.
DB2 UDB for z/OS Version 8 has introduced two new subsystem wide utilities, BACKUP and RESTORE, which, by interfacing the copy pools functions of DFSMS 1.5, are able to provide Point-In-Time recovery capabilities.
The disaster recovery solution consists of the combination of coherent options that best fit in with the requirements, the current environment, and the investment.
In this IBM Redbook we first introduce the main concepts, and the primary components for possible solutions. We then describe the most common solutions, and implement several recovery scenarios. All our tests were implemented with DB2 UDB for z/OS Version 8. We also include criteria for choosing a solution, and recommendations based on recovery best practices.
We focus on requirements and functions available for a disaster recovery strategy for data stored and managed by DB2 for z/OS. It is worth remembering that the non-DB2 data, logically or physically related to the DB2 applications, should be treated with equivalent and congruent solutions.

Sommaire
Part 1. The whole picture
Chapter 1. Business continuity
Chapter 2. DB2 disaster recovery
Part 2. Disaster recovery major components
Chapter 3. Traditional recovery
Chapter 4. DB2 Tracker
Chapter 5. ESS FlashCopy
Chapter 6. SMS copy pools and DB2 point in time recovery
Chapter 7. Peer-to-Peer Remote Copy
Chapter 8. eXtended Remote Copy
Part 3. General solutions for disaster recovery
Chapter 9. Split Mirror
Chapter 10. FlashCopy Consistency Group
Chapter 11. Global Copy PPRC-XD
Chapter 12. Global Mirror PPRC
Chapter 13. XRC: Global Mirror for z/OS
Chapter 14. Geographically Dispersed Parallel Sysplex
Part 4. Implementing disaster recovery scenarios
Chapter 15. Set Log Suspend - FlashCopy - More Log - Restore System Log Only
Chapter 16. FlashCopy Consistency Group and restart
Chapter 17. PPRC - FlashCopy from secondary
Chapter 18. XRC and restart
Chapter 19. Local recovery: System PITR
Chapter 20. Restart using tape dump of copy pools
Part 5. Additional considerations
Chapter 21. Data sharing
Chapter 22. Validation and performance
Appendix A. REXX procedures
Appendix B. PITR definitions
Appendix C. Additional material



Regards,

DB2usa.

Redpaper DB2 9 for z/OS Data Sharing: Distributed Load Balancing and Fault Tolerant Configuration

Bonjour,

IBM vient de mettre à disposition un nouveau Redpaper intitulé, "DB2 9 for z/OS Data Sharing: Distributed Load Balancing and Fault Tolerant Configuration, REDP-4449-00" :
http://www.redbooks.ibm.com/redpapers/abstracts/redp4449.html?Open


Résumé
This IBM® Redpaper provides information about exploiting client load balancing and fail over capabilities across a DB2® data sharing group or a subset of the group members.
The information provided will help network specialists and data base administrators in appropriately configuring data sharing groups as TCP/IP servers.
We show how to use the functions of DB2 sysplex workload balancing functions, supported by DB2 Connect™ Server and the IBM DB2 Driver for JDBC and SQLJ, in conjunction with the functions of TCP/IP Sysplex Distributor, configured with Dynamic Virtual IP address (Dynamic VIPA or DVIPA) and automatic VIPA takeover, to provide superior load distribution and fail-over capability for transactions and connections across the members of a data sharing group. The two functions work together to ensure the highest availability possible for remote applications accessing a DB2 location in a sysplex.

Sommaire
Exploiting client load balancing across a DB2 group
Enabling sysplex workload balancing in DB2 client drivers
Configuring sysplex workload balancing for a subset of members


En savoir plus sur Data Sharing

- Redbook DB2 for z/OS: Data Sharing in a Nutshell, SG24-7322-00

Résumé
DB2 for z/OS takes advantage of data sharing technology in a z Parallel Sysplex to provide applications with full concurrent read and write access to shared DB2 data. Data sharing allows users on multiple DB2 subsystems, members of a data sharing group, to share a single copy of the DB2 catalog, directory, and user data sets.

Data sharing provides improvements to availability and capacity without impacting existing applications.
The road to data sharing might seem arduous to a novice user, but once you have started to learn terminology and gain basic understanding, things will become much easier.

This IBM Redbook is meant to facilitate your journey towards data sharing by providing a cookbook approach to the main tasks in enabling data sharing and workload balancing. It does not have all the answers, because it is a brief summary of a large field of knowledge, but it contains the key elements and it points you in the right direction to get more details. Throughout this document we assume that your sysplex environment is set up and a DB2 subsystem exists at a currently supported level.

Sommaire
Chapter 1. Introduction
Chapter 2. Data sharing architecture
Chapter 3. The coupling facility
Chapter 4. Implementing data sharing
Chapter 5. Dynamic workload balancing
Chapter 6. Operations
Chapter 7. Advanced topics
Chapter 8. Best practices



Amicalement,

DB2usa

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.

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

Le logging avec DB2 pour z/OS

Bonjour,

Vous trouverez ci-dessous plusieurs présentations sur le logging avec DB2 pour z/OS, disponibles sur les sites web d'IBM et des groupes d'utilisateurs DB2 :

- Harnessing the Power of DB2 Logs
par Gregory Parrish

- DB2 Logging: Past, Present, and Future
par Jeff Josten

- DB2 9 for z/OS Detailed RRF & Reading the DB2 Log
par Paul Fletcher

- DB2 9 for z/OS RRF Overview & Not Logged Table Spaces
par IBM

- DB2 Log Extract Tool for audit
par Michael Arlebrandt


En savoir plus


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

- Redbook Disaster Recovery with DB2 UDB for z/OS



Amicalement,

DB2usa.

Redbooks 2004-2008 et plus encore

Bonjour,

Voici une liste de redbooks sur DB2 pour z/OS parus ou mis à jour entre 2004 et 2008, disponibles sur le site web d'IBM :


Les apports de la version 9
- DB2 9 for z/OS Technical Overview, SG24-7330-00
- DB2 9 for z/OS Performance Topics, SG24-7473-00

- DB2 9 for z/OS: New Tools for Query Optimization, SG24-7421-00
- DB2 9 for z/OS Stored Procedures: Through the CALL and Beyond, SG24-7604-00
- LOBs with DB2 for z/OS: Stronger and Faster, SG24-7270-00
- Securing DB2 and Implementing MLS on z/OS, SG24-6480-01

- Enhancing SAP by Using DB2 9 for z/OS, SG24-7239-00
- Best Practices for SAP BI using DB2 9 for z/OS, SG24-6489-02


Les apports de la version 8
- Version 8: Everything You Ever Wanted to Know , ... and More, SG24-6079-00
- DB2 UDB for z/OS Version 8 Performance Topics, SG24-6465-00

- Design Guidelines for High Performance and Availability, SG24-7134-00

- DB2 V8: Through the Looking Glass and What SAP Found There, SG24-7088-00
- DB2 UDB V8 and WebSphere V5 Performance Tuning and Operations, SG24-7068-00

- The Business Value of DB2 UDB for z/OS, SG24-6763-00


Autres sujets
- DB2 for z/OS: Data Sharing in a Nutshell, SG24-7322-00
- Data Integrity with DB2 for z/OS, SG24-7111-00
- Disaster Recovery with DB2 UDB for z/OS, SG24-6370-00

- Powering SOA with IBM Data Servers, SG24-7259-00
- DB2 for z/OS and OS/390: Ready for Java, SG24-6435-00
- DB2 for z/OS and WebSphere: The Perfect Couple, SG24-6319-00

- DB2 for z/OS and OS/390 Version 7 Using the Utilities Suite, SG24-6289-00


Redpapers
- Index Compression with DB2 9 for z/OS, REDP-4345-00
- How does the MIDAW facility improve the performance ... using DB2?, REDP-4201-00
- Disk storage access with DB2 for z/OS, REDP-4187-00

- Coupling Facility Performance: A Real World Perspective, REDP-4014-00

Tips
- News on DB2 Optimization Expert and DB2 Optimization Service Center, TIPS0673
- Copying the DB2 UDB for z/OS Catalog Using the COPY Utility, TIPS0587
- SAP BW and DB2 for z/OS V8, TIPS0577


Information Center
- DB2 and IMS
- z/OS 1.7 basic skills
- z/OS 1.9 Beta
- Development Tools and Compilers
- DB2 for LUW

- z/OS Concepts, z/OS Basic Skills Information Center
- z/OS LookAt


ABCs of z/OS System Programming
- Vol 1, z/OS operating system and the hardware architecture, SG24-6981-01
- Vol 2, z/OS implementation and maintenance, defining subsystems, SG24-6982-01
- Vol 3, DFSMS, data set basics, storage management, VSAM, ... , SG24-6983-02
- Vol 4, Communication Server, TCP/IP, and VTAM (non publié), SG24-6984-00
- Vol 5, Sysplex, System Logger, RRS, GRS, ARM, GDPS, SG24-6985-01
- Vol 6, Introduction to security, RACF , Digital certificates, ... , SG24-6986-00
- Vol 7, Printing in a z/OS environment, Infoprint Server, ... , SG24-6987-00
- Vol 8, An introduction to z/OS problem diagnosis, SG24-6988-00
- Vol 9, z/OS UNIX System Services , SG24-6989-03
- Vol 10, z/Architecture, zSeries processor design, zSeries connectivity, SG24-6990-02
- Vol 11, Capacity planning, performance, WLM, RMF, and SMF, SG24-6327-00


Introduction to the New Mainframe
- z/OS Basics, SG24-6366-00
- Large-Scale Commercial Computing, SG24-7175-00
- Networking, SG24-6772-00
- Security, SG24-6776-00


Bonne lecture.

Amicalement,

DB2usa.