Forum DB2 : le blog en français sur DB2 pour z/OS

Redpaper Data Studio and DB2 for z/OS Stored Procedures

2011-02-14T01:00:00.002+01:00

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

2011-01-03T01:00:00.002+01:00

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

2010-12-13T01:00:00.000+01:00

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

2010-11-29T01:00:00.003+01:00

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

2010-11-01T01:00:00.000+01:00

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

2010-09-06T01:10:00.001+02:00

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

2010-08-30T01:00:00.002+02:00

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

2010-08-23T01:00:00.000+02:00

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)

2010-07-16T01:00:00.002+02:00

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.

z/Journal (numéro d'avril à mai 2010)

2010-05-17T01:00:00.002+02:00

Bonjour,

Les articles du numéro d'avril à mai 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 Buffer Pools: Diving Into the Deep End
par Bill Arledge et Lynn Gros

- Radical Changes Can Modernize and Streamline DBA Resources
par Troy Coleman et Stefan Kochishan

- The Magic of Keeping DB2 in Order
par Willie Favero

- Choices for Caching Data in the Enterprise
par Susan Lawson et Dan Luksetich

En savoir plus

- Using In-Memory Tables to Optimize Your Mainframe Environment
par William Olders

- Storage Performance Management: Strategies for Solid State Drives
par Gilbert Houtekamer et Wim Oudshoorn

Amicalement,

DB2usa.

Présentations du Heart of America DB2 Users Group

2010-05-10T01:00:00.000+02:00

Bonjour,

Vous trouverez ci-dessous plusieurs présentations sur DB2 pour z/OS, disponibles sur le site du Heart of America DB2 Users Group :

- Real-world strategies for managing undesirable access paths
par Suresh Sane

- Stabilizing Access Paths Across Rebind
par Terry Purcell

- DB2 for z/OS Data and Index Compression
par Willie Favero

- A Peek into the 24x7 VLDB DBA's Toolsbox
par David Simpson

- Workloads, Monitors, Advisors: V9 OSC Experiences
par Terry Berman

- SQL Queries on Speed
par Dan Anderson

- Application Buffering of DB2 Data
par Michael Todd

- V9 SQL for the Application Developer and DBA – Richer and Faster
par Suresh Sane

Amicalement,

DB2usa.

z/Journal (numéros d'octobre 2009 à mars 2010)

2010-03-29T01:00:00.000+02:00

Bonjour,

Les articles des numéros d'octobre 2009-mars 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 .

- Collecting Histogram Statistics With RUNSTATS
par Craig Mullins

- 11 Rules of the Road for DBAs
par Craig Mullins

- Using SMF for Cost-Effective DB2 Security, Auditing & Compliance Monitoring
par Jerry Harding, Stephen Rubin et William Buriak

- SQL Performance Tuning for Application Developers
par Peter Plevka

- Snapping the DB2 for z/OS Dynamic Statement Cache
par Susan Lawson and Dan Luksetich

- Simplify and Improve Database Administration par Leveraging Your Storage System
par Ron Haupert

Amicalement,

DB2usa.

Plus d'informations sur DB2 10 pour z/OS

2010-03-08T01:00:00.002+01:00

Bonjour,

Vous trouverez ci-dessous plusieurs présentations et documents techniques sur DB2 10 pour z/OS (précédemment sous le nom de DB2 X), disponibles sur différents sites web d'IBM :

- DB2 10 for z/OS: How can it help you? (70 pages avec commentaires)
par Roger Miller

- Planning Your Migration to DB2 9 for z/OS (mise à jour sur DB2 10)
par Roger Miller

- Technote (FAQ): When should I migrate to DB2 for z/OS Version 8? DB2 9? DB2 10?

En savoir plus

- II14477: DB2 V9 Migration/Fallback Infoapar to/from DB2 10

- II14474: DB2 V8 Migration/Fallback Infoapar to/from DB2 10

- SPE Migration and Fallback from DB2 9 (R910) or from DB2 V8 (R810)

- PM04968: New function for premigration checkout (DSNTIJPM)

Amicalement,

DB2usa.

Présentations d'Andy Ward sur DB2 pour z/OS

2010-03-01T01:00:00.000+01:00

Bonjour,

Vous trouverez ci-dessous plusieurs présentations d'Andy Ward sur DB2 pour z/OS, disponibles sur différents sites :

- By the Pool with the (IF)cids
par Andy Ward

- Lies, Damned Lies & Statistics
par Andy Ward

- Independence Day DB2 V8 Partitioning
par Andy Ward

Amicalement,

DB2usa.

Documentation DB2 pour z/OS de la version 2.3 à la version 9

2010-02-15T01:00:00.009+01:00

Bonjour,

Voici plusieurs manuels DB2 pour z/OS de la version 2.3 à la version 9, disponibles sur le site web IBM Library Server Library :

Tous les manuels sont disponibles au format HMTL et pour le téléchargement au format BookManager (fichiers .boo). Les fichiers PDF sont disponibles à partir de la version 5.

Vous pouvez lire les fichiers BookManager avec le logiciel gratuit IBM Softcopy Reader pour Windows et Linux.

- IBM DATABASE 2 Version 2 Release 3 (mars 1992)
Application Programming and SQL Guide
Command and Utility Reference
Master Index and Glossary
Messages and Codes
Reference Summary
SQL Reference
Usage of DDM Commands

- DB2 Version 3 First Edition (décembre 1994)
Administration Guide
Application Programming and SQL Guide
Command and Utility Reference
General Information
Messages and Codes
SQL Reference
Usage of DDM Commands

- DB2 for MVS/ESA Version 4 (novembre 1995)
Administration Guide
Application Programming and SQL Guide
Command Reference
Data Sharing: Planning and Administration
Installation Guide
Messages and Codes
Reference for Remote DRDA Requesters and Servers
SQL Reference
Utility Guide and Reference
What's New?

- DB2 for OS/390 Version 5 (juin 1997)
Administration Guide
Application Programming and SQL Guide
Application Programming Guide and Reference for Java
Call Level Interface Guide and Reference
Command Reference
Data Sharing: Planning and Administration
Installation Guide
Messages and Codes
Reference for Remote DRDA Requesters and Servers
SQL Reference
Utility Guide and Reference

- DB2 UDB for OS/390 Version 6 First Edition (juin 1999)
Administration Guide
Application Programming and SQL Guide
Application Programming Guide and Reference for Java
Command Reference
Data Sharing: Planning and Administration
Image, Audio, and Video Extenders
Installation Guide
Messages and Codes
ODBC Guide and Reference
Reference for Remote DRDA Requesters and Servers
Release Planning Guide
SQL Reference
Text Extender
Utility Guide and Reference

- DB2 UDB for OS/390 Version 6 Third edition (mai 2001) uniquement en format PDF

- DB2 UDB for OS/390 and z/OS Version 6 First Edition (mars 2001)
Administration Guide
Application Programming and SQL Guide
Application Programming Guide and Reference for Java
Command Reference
Data Sharing: Planning and Administration
Installation Guide
Messages and Codes
ODBC Guide and Reference
Reference for Remote DRDA Requesters and Servers
Release Planning Guide
SQL Reference
Utility Guide and Reference
What's New?

An Introduction to DB2 for OS/390
XML Extender Administration and Programming
Net Search Extender Administration and Programming
DB2 Image, Audio, and Video Extenders
Text Extender Administration and Programming

- DB2 UDB for OS/390 and z/OS V7 Bookshelf Last Edition (août 2008)

- DB2 UDB for z/OS Version 8 First Edition (mars 2004)
Administration Guide
Application Programming and SQL Guide
Application Programming Guide and Reference for Java
Command Reference
Data Sharing: Planning and Administration
Installation Guide
Messages and Codes
ODBC Guide and Reference
RACF Access Control Module Guide
Reference for Remote DRDA Requesters and Servers
Release Planning Guide
SQL Reference
Utility Guide and Reference
What's New?

XML Extender Administration and Programming
Net Search Extender Administration and Programming
Image, Audio, and Video Extenders Administration and Programming
Text Extender Administration and Programming

- DB2 UDB for z/OS Version 8 Current Edition (juin 2009)

- DB2 Version 9.1 for z/OS First Edition (mars 2007)
Administration Guide
Application Programming and SQL Guide
Application Programming Guide and Reference for Java
Codes
Command Reference
Data Sharing: Planning and Administration
Installation Guide
Messages
ODBC Guide and Reference
Performance Monitoring and Tuning Guide
RACF Access Control Module Guide
Reference for Remote DRDA Requesters and Servers
SQL Reference
Utility Guide and Reference
XML Extender Administration and Programming

- DB2 Version 9.1 for z/OS Current Edition (octobre 2009)

Note : le manuel "Diagnosis Guide and Reference" n'est pas disponible sur Internet.

Support for BookManager format being discontinued (IBM)
As part of IBM's ongoing effort to deliver the best possible information experience to our customers, we are optimizing the information that is delivered with our products for viewing in the information center and phasing out the BookManager format.

You might have noticed that the information for new products and features, such as the DB2 Accessories Suite for z/OS information, is not offered in BookManager format in the Version 9.1 library for DB2 for z/OS. The BookManager books will continue to be provided for the life cycle of our versions through Version 9.1; however, we do not intend to deliver BookManager books for new releases in the future.

En savoir plus

- DB2 for z/OS APAR database

- IBM Information Center : DB2 for z/OS Versions 8 and 9

- DB2 for z/OS - Technical Resources

- DB2 Diagnostics: They're in There
par Troy Coleman

- BookManager Index Utility for Windows

Amicalement,

DB2usa.

Présentations sur DB2 10 pour z/OS et programme Beta

2010-02-11T01:00:00.008+01:00

Bonjour,

Vous trouverez ci-dessous plusieurs présentations et articles sur DB2 10 pour z/OS (précédemment sous le nom de DB2 X), disponibles sur différents sites web :

- DB2 10 for z/OS technical preview (65 pages avec commentaires)
par Roger Miller

- DB2 Trends and Directions (Version X)
par Gareth Jones

- What's Ahead?
DB2 X leads the industry to minimize complexity and maximize productivity
par Terrie Jacopi et Jeff Josten

- DB2 9 for z/OS and Beyond (pages 29-52 avec commentaires)
par Roger Miller

- The next DB2 for z/OS: First glimpse into the future
par David Beulke

- Deprecated Features Planned for DB2 X for z/OS
par Craig Mullins

En savoir plus

- IBM DB2 10 for z/OS launches beta program
Beta Program: 12 mars 2010
General Availability (GA): non annoncé

- IBM DB2 V9.1 for z/OS launches beta program
Beta Program (QPP): 9 juin 2006
General Availability (GA): 16 mars 2007

- IBM DB2 Universal Database for z/OS, V8 — Reengineered for e-business Leadership
Beta Program (ESP): 31 janvier 2003
General Availability (GA): 26 mars 2004

- DB2 z/OS Product Lifecycle
(General availability, End of Marketing, End of Support)

- DB2 Distributed End of Support (EOS) dates
(including DB2 Connect)

Amicalement,

DB2usa.

Numéro d'hiver 2009 de DB2mag

2010-02-08T01:00:00.000+01:00

Bonjour,

Le numéro d'hiver 2009 de DB2mag est disponible en ligne :

- DB2mag hiver 2009 (version digitale : format PDF interactif)
- DB2mag automne 2009 (version digitale : format PDF interactif)
- DB2mag été 2009 (version digitale : format PDF interactif)

- Archives de DB2mag (hiver 1996-printemps 2009)

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

- Making Humongous Doable
Need to manage a gigantic database? Let DB2 do the heavy lifting.
par Robert Catterall

- The next DB2 for z/OS
First glimpse into the future.
par David Beulke

Amicalement,

DB2usa.

Redbooks 2004-2010 et plus encore

2010-02-01T01:00:00.004+01:00

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.

Le traitement distribué avec DB2 pour z/OS

2010-01-25T01:00:00.000+01:00

Bonjour,

Vous trouverez ci-dessous plusieurs présentations et articles sur le traitement distribué avec DB2 pour z/OS, disponibles sur différents sites web :

- An Introduction to Distributed Processing with DB2 for z/OS
par Hugh Smith

- Distributed Processing with DB2 for z/OS – Advanced Topics
par Hugh Smith

- Understanding Distributed Processing Inside DB2 for z/OS
par Judy Quenet

- DB2 and WLM: An Introduction to Enclaves
par Mark Rader

- Using WLM with DB2 for z/OS
par Hugh Smith

- Java application deployment considerations
par Connie Tsuia et Rahul Kitchlu

- XML application migration from DB2 for z/OS V8 to DB2 9
Understand the DB2 UDB JDBC Universal Driver
par Anson Kokkat

More information

- Redbook DB2 9 for z/OS: Distributed Functions

Amicalement,

DB2usa.

Présentations sur le diagnostic et le suivi d'activité DB2 pour z/OS

2010-01-18T01:00:00.002+01:00

Bonjour,

Vous trouverez ci-dessous plusieurs présentations sur le diagnostic et le suivi d'activité DB2 pour z/OS, disponibles sur le site de l'IDUG :

- DB2 Systems Programming Tools of the Trade
par Linda Hagedorn

- The Diagnosis Manual Secrets and Intrigue
par Linda Hagedorn

- RMF For a DB2 DBA and Systems Programmer
par Venkat Srinivasan

- What Happened? When? Who Did It?
par Bryce Krohn

- How to Monitor Your Data Sharing System, with Tips and Tools to Help! Part 1 of 2
par Bryce Krohn

- How to Monitor Your Data Sharing System, with Tips and Tools to Help! Part 2 of 2
par Bryce Krohn

- Lock Out Your Locking Problems – Part 1
par Peter Backlund

- Lock Out Your Locking Problems – Part 2
par Lennart Henäng

- DB2 Connect to DB2 z/OS – Problem Determination & Performance Tips & Tricks
par Melanie Stopfer

- Troubleshooting Tuning for Dynamic SQL
par Thomas Baumann

- Memory Management for Dynamic SQL
par Thomas Baumann

Amicalement,

DB2usa.

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

2010-01-11T01:00:00.002+01:00

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

2010-01-04T01:00:00.000+01:00

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.

Retour sur DB2 pour z/OS au cours de l'année 2009

2009-12-28T01:00:00.002+01:00

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

2009-12-21T01:00:00.001+01:00

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.

Numéro d'automne 2009 de DB2mag

2009-12-14T01:00:00.000+01:00

Bonjour,

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

- DB2mag automne 2009 (version digitale : format PDF interactif)
- DB2mag été 2009 (version digitale : format PDF interactif)

- Archives de DB2mag (hiver 1996-printemps 2009)

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

- System z Rocks (Again)
Indexing, compression make your applications work faster.
par Robert Catterall

- Top Performance Features in DB2 9 for z/OS
The mainframe isn't dead-in fact, it's turning heads as a data warehouse platform.
par David Beulke

- Reducing Conversations with DB2 for z/OS: Part 1
As Prem Mehra said, "There is no better-performing SQL than the SQL that is not executed.
par Bonnie Baker

- Customizing XML storage in DB2Tailor XML storage to the needs of your application
With DB2 pureXML, DBAs can apply existing skills to manage XML growth and pursue opportunities to learn new XML skills if they choose.
par Matthias Nicola

En savoir plus

- DB2 Data Warehouse Performance, Part 2
Find problem SQL queries and tune them for quicker response.
par Robert Catterall

- DB2 Data Warehouse Performance, Part 1
Translate OLTP-tuning skills into effective performance management for DB2-based business intelligence systems.
par Robert Catterall

Amicalement,

DB2usa.

Présentations du Guide Share France

2009-11-30T01:00:00.000+01:00

Bonjour,

Vous trouverez ci-dessous plusieurs présentations sur DB2 pour z/OS, disponibles sur le site du Guide Share France :

- DB2 9 for z/OS for Database Administrators
par Namik Hrle

- DB2 9 for z/OS for Application Programmers
par Namik Hrle

- Access Path Stability for Dynamic Queries
par Thomas Baumann

- Recursive SQL from a Performance Perspective
par Thomas Baumann

Amicalement,

DB2usa.

Présentations du Baltimore/Washington DB2 Users Group

2009-11-23T01:00:00.000+01:00

Bonjour,

Vous trouverez ci-dessous plusieurs présentations sur DB2 pour z/OS, disponibles sur le site du Baltimore/Washington DB2 Users Group :

- Improving Performance with DB2 V9 for z/OS
par David Beulke

- What's New in DB2 9 for Applications
par Patrick Bossman

- DB2 Performance Primer
par Michael Murray

- Index Design in a Busy System
par Larry Kintisch et Tapio Lahdenmäki

- ATS DB2 Health Check
par John Iczkovits

- A List of DB2 Top Ten Lists
par Craig Mullins

- Null & Void? Dealing with Nulls in DB2 for z/OS
par Craig Mullins

En savoir plus

- New to DB2 LUW but for experienced z/OS DBAs
par Chris Eaton

- Database Trends
par Craig Mullins

Amicalement,

DB2usa.

Technotes 2009 (FAQ) d'IBM sur DB2 pour z/OS

2009-11-16T01:00:00.000+01:00

Bonjour,

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

- What is DB2 Accounting Class 2 Not Accounted Time?
- Keywords for searching APAR text
- BIND ERROR SQLCODE109 TOKENS=INTO in Version 9 CM
- Converting an external SQL procedure to a native SQL procedure
- Preallocate EDITUTL1 and EDITUL2 datasets before you run DB2 V9 DSNTINST CLIST

- Partition error 00C90099 during REORG
- Explicit SECQTY for DB2 work file table space generator program (DSNTWFG)
- Misleading SQLCODE -104
- DIAGNOSE DISPLAY MEPL: report seems to be built from SDSNLOAD or memory
- DSNU007I when running job DSNTITC to install a new Version 8 or 9

- Loading output from a SELECT statement
- What is DB2 Estimator and what can it do for me?
- Authorizations required for OSC (Optimization Service Center)
- DB2 supplied stored procedures required for OSC tasks
- Enabling multiple OSC users to work with a DB2 subsystem

- Enabling a DB2 for z/OS subsystem for OSC
- Setting up OSC with the same configuration on multiple workstations
- DSNL030I: How do I trace the TCP/IP address to catch an unauthorized user?
- Should I use the traditional DB2 security or RACF access control?
- How to collect frequency and cardinality statistics used for access path selection

Amicalement,

DB2usa.

Présentations de Roger Miller sur DB2 9 pour z/OS

2009-11-02T01:00:00.001+01:00

Bonjour,

Vous trouverez ci-dessous plusieurs présentations de Roger Miller, disponibles sur le site d'IBM :

- DB2 9 for z/OS and Beyond
par Roger Miller

- DB2 for z/OS Selected Performance Topics
par Roger Miller

- Planning Your Migration to DB2 9 for z/OS
par Roger Miller

- Best Practices in DB2 for z/OS Security
par Roger Miller

En savoir plus

- DB2 9 for z/OS System Performance Topics
par Greg Dyck

- IBM DB2 for z/OS Utility Update: Best Practices
par Bryan Smith

- Maximizing the DB2 9 for z/OS Optimizer and SQL Performance Enhancements
par James Guo

Amicalement,

DB2usa.

Présentations de Susan Lawson et Dan Luksetich

2009-10-26T01:00:00.000+01:00

Bonjour,

Vous trouverez ci-dessous plusieurs présentations de Susan Lawson et Dan Luksetich, disponibles sur le site d l'IDUG :

- Quit Calling DB2 So Much!
par Susan Lawson et Dan Luksetich

- DB2 9 for z/OS: A New Spin on a Classic Database
par Susan Lawson

- Desperate Table Designs
par Susan Lawson et Dan Luksetich

- Top 10 Ways to Waste CPU
par Susan Lawson et Dan Luksetich

- V8/V9 SQL Challenges and Solutions
par Susan Lawson et Dan Luksetich

- Effective Uses of DB2 Triggers
par Dan Luksetich

- Utilizing DB2 V8 Table Expressions
par Dan Luksetich

- DB2 Legacy Migrations: Experiences of The Industry
par Susan Lawson et Dan Luksetich

- DB2 Application Design for Performance
par Susan Lawson et Dan Luksetich

- DB2 for z/OS Design and Tuning Tips for Your Complex VLDB
par Dan Luksetich

Amicalement,

DB2usa.

z/Journal (numéro d'août - septembre 2009)

2009-10-19T01:00:00.000+02:00

Bonjour,

Les articles du numéro d'août - septembre 2009 de z/Journal sont disponibles en ligne : http://www.zjournal.com

- Avoiding Application Bottlenecks in a Dynamic Environment
par Lockwood Lyon et Lisa Westcott-Dryer

- Initial Project Analysis: An IMS to DB2 Conversion Example
par Shirley Huhtanen

- DISPLAY Your Way Out of DB2 Problems
par Craig Mullins

En savoir plus

- Storage & Data Management: Solid State Drives (SSDs) for System z
par Ray Lucchesi

Amicalement,

DB2usa.

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

2009-10-12T01:00:00.004+02:00

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.

IDUG Solutions Journal (Eté 2009)

2009-10-05T01:00:00.000+02:00

Bonjour,

Le numéro d'été 2009 de l'IDUG Solutions Journal est disponible en ligne :

Il contient les articles suivants :

- Escaping the REBIND blues in DB2 9 for z/OS
par Adarsh Pannu et Terry Purcell

- Best practices- DB2 9 for z/OS migration
par Roger Miller

- An Overview of Mainframe Specialty Processors
par Craig Mullins

Amicalement,

DB2usa.

La performance avec DB2 9 for z/OS par Dave Beulke

2009-09-28T01:00:00.000+02:00

Bonjour,

Dave Beulke a publié plusieurs articles sur la performance avec DB2 9 pour z/OS sur son blog : http://davebeulke.com

- DSNZPARM parameters
- ORDER BY and FETCH FIRST n ROWS in a Sub-Select
- Skip Uncommitted Inserts zParm
- Universal Tablespace
- FETCH WITH CONTINUE SQL
- DB2 Version 9 for z/OS Logging enhancement
- Performance improvement for IBM DB2 utilities
- Data Warehousing and Reporting features
- Minimizing the number of SQL call
- Too Many Performance Features in DB2 Version 9 for z/OS

En savoir plus

- Improving Performance with DB2 V9 for z/OS

- Java DB2 Performance with Data Studio and pureQuery

- pureQuery-JLINQ Examples to Improve Your Java Application Performance

- Data Warehouse Design and Performance

- How to do your own Performance Review

- Performance for SOA DB2 Java Applications

Amicalement,

DB2usa.

Présentations de Robert Catterall

2009-09-07T01:00:00.002+02:00

Bonjour,

Vous trouverez ci-dessous plusieurs présentations de Robert Catterall sur DB2 pour z/OS, disponibles sur le site d l'IDUG et d'autres sites :

- Get Up: DB2 High Availability & Disaster Recovery
par Robert Catterall

- What DB2 People Should Know About SOA
par Robert Catterall

- Ultra-Availability – How Far Can You Go?
par Robert Catterall

- DB2 for z/OS Data Warehouse Performance
par Robert Catterall

- DB2 Stored Procedures - Trends and Technology
par Robert Catterall

En savoir plus

- DB2 Data Warehouse Performance, Part 1
par Robert Catterall

- DB2 Data Warehouse Performance, Part 2
par Robert Catterall

- Le blog de Robert Catterall
par Robert Catterall

Amicalement,

DB2usa.

Présentations du Forum CDUG 2009 (Shanghai, Chine)

2009-08-31T01:00:00.004+02:00

Bonjour,

Vous trouverez ci-dessous plusieurs présentations sur DB2 pour z/OS, issues du Forum CDUG 2009 (Shanghai, Chine) disponibles sur le site de DB2 China :

- Partitioned Table Space Usage Experience Sharing
par Huang Hao

- DB2 Memory Management
par Jim Teng

- INSERT Performance Update
par Jim Teng

- DB2 for z/OS: Trend and Direction
par Fu Yu Qin et Gene Fuh

En savoir plus

- RTS Operation and Maintenance (in English/Chinese)
par Wu Ding

- RTS Operation and Maintenance : notes (Chinese)
par Wu DIng

Amicalement,

DB2usa.

Présentations d'Akira Shibamiya

2009-08-24T01:00:00.001+02:00

Bonjour,

Vous trouverez ci-dessous plusieurs présentations sur la performance de DB2 pour z/OS, disponibles sur le site d l'IDUG :

- DB2 9 for z/OS Select, Insert, Update, Delete SQL Application Performance
par Akira Shibamiya

- DB2 9 for z/OS Performance Overview
par Akira Shibamiya

- DB2 for z/OS V7 and V8 System Performance Tuning
par Akira Shibamiya

- DB2 for z/OS V7 and V8 Application Performance
par Akira Shibamiya

En savoir plus

- DBM1 Virtual/Real Storage Change from DB2 for z/OS V7 to V8 to V9 and Ziip Offload
par Akira Shibamiya

Amicalement,

DB2usa.

z/Journal (numéro de juin - juillet 2009)

2009-08-17T01:00:00.000+02:00

Bonjour,

Les articles du numéro de juin - juillet 2009 de z/Journal sont disponibles en ligne : http://www.zjournal.com

- Database Reorganization Strategies for DB2 z/OS
par Rick Weaver

- Approaches to DB2 Tuning: What's the Best Use of Your Time?
par Lockwood Lyon

- Are DBAs Really DBAs Today?
par Craig Mullins

En savoir plus

- Avoid Black Boxes to Improve Performance
par Craig Mullins

- Dynamic SQL On The Rise
par Craig Mullins

- An Overview of Mainframe Specialty Processors
par Craig Mullins

Amicalement,

DB2usa.

Articles d'IBM Techdocs Library

2009-06-29T01:00:00.003+02:00

Bonjour,

Vous trouverez ci-dessous plusieurs articles sur DB2 pour z/OS, disponibles sur le site d'IBM Techdocs Website :

- Identifying the dynamic SQL statement which is causing a lock escalation
par Richard Corrihons

- Tape Authorization for DB2 RESTORE SYSTEM Utility
par Judy Ruby-Brown

- Using DB2 V8 for z/OS RESTORE SYSTEM utility and SET LOG SUSPEND
par Mary Siart

- Asynchronous DB2 data sharing locks not counted
par Judy Ruby-Brown

- IBM DB2 features explored running PeopleSoft Enterprise Applications
par Michael Curtis

- Tuning SAP on DB2 for z/OS on System z
par Mark Gordon

- DB2 9 and z/OS XML System Services Synergy
par Judy Ruby-Brown et Akiko Hoshikawa

- DB2 9 and z/OS XML System Services synergy for distributed workloads
par Judy Ruby-Brown et Akiko Hoshikawa

- Connect WAS to DB2 using JDBC on z/OS
par Bee Fui Soo

- QSGDATA zPARM - Where to find the DB2 Information
par Carolyn Elkins

- DB2 for z/OS – What’s tape got to do with it?
par John Iczkovits

Amicalement,

DB2usa.

Présentations sur les utilitaires DB2 d'IBM

2009-06-22T01:00:00.000+02:00

Bonjour,

Vous trouverez ci-dessous plusieurs présentations sur les utilitaires DB2 d'IBM, disponibles sur le web :

- DB2 for z/OS Utilities Topics (State of North Carolina)
par Craig Friske

- DB2 for z/OS Utilities: Best Practices
par Haakon Roberts

- DB2 Backup System and Restore System Enhancements
par Bryan Paulsen

- Real-Time Statistics - How to arm your DB2 for 24x7
par Ulf Heinrich

More information

- What’s New in DB2 9 for z/OS for Backup and Recovery
par Jim Teng

- Redbook LOBs with DB2 for z/OS: Stronger and Faster

- Redbook DB2 9 for z/OS Technical Overview

- Redbook DB2 UDB for z/OS Version 8: Everything You Ever Wanted ...

- Redbook DB2 for z/OS and OS/390 Version 7 Using the Utilities Suite

Amicalement,

DB2usa.

Redbook DB2 9 for z/OS : Distributed Architecture

2009-06-15T01:00:00.004+02:00

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.

Présentations de SQL Adria

2009-06-08T01:00:00.000+02:00

Bonjour,

Vous trouverez ci-dessous plusieurs présentations sur DB2 pour z/OS, disponibles sur le site de SQL Adria :

- DB2 9 for z/OS - Hints and Tips for DBAs
par Namik Hrle

- DB2 9 for z/OS – Hints and Tips for Application Programmers
par Namik Hrle

- Lock Out Your Locking Problems
par Peter Backlund

- DB2 9 for z/OS XML Support
par Phil Grainger

- Desperate Table Designs
par Susan Lawson

- Top 10 Ways to Waste CPU
par Susan Lawson

- Universal Table Spaces, what are they?
par Klaas Brant

- Clone Table, Hot or not?
par Klaas Brant

- Bringing your DB2 to V9 (and V8)
par Jan Henderyckx

- Every Day’s Life of a DBA or How Do I Handle THAT Query?!
par Mirna Kos

Amicalement,

DB2usa.

Sondages sur DB2 pour z/OS (2009)

2009-06-02T01:00:00.000+02:00

z/Journal (numéros de février - mars et avril - mai 2009)

2009-05-25T01:00:00.000+02:00

Bonjour,

Les articles du numéro de février - mars et de avril - mai 2009 de z/Journal sont disponibles en ligne : http://www.zjournal.com

- Canonical Database Architecture and DB2 Performance … Really?
par Susan Lawson et Dan Luksetich

- Not Sure Who You Are? Ask DB2
par Susan Lawson et Dan Luksetich

- How DB2 9 for z/OS Can Improve a Data Warehouse’s Performance
par Willie Favero

- Being a DBA in Hard Economic Times: Nine Notions for '09
par Lockwood Lyon

- DB2 System Configuration and Performance
par Craig Mullins

En savoir plus

- DBA Proverbs
par Craig Mullins

- Recovery Is a Compliance Issue
par Craig Mullins

Amicalement,

DB2usa.

Plus de présentations du UK DB2 User Group

2009-05-18T01:00:00.002+02:00

Bonjour,

Vous trouverez ci-dessous plusieurs présentations sur DB2 pour z/OS, disponibles sur le site du UK DB2 User Group :

- DSN1LOGP - It could save your job one day (z/OS)
par Raymond Bell

- Position Power! DB2 for z/OS Spatial Features
par Julian Stuhler

- Surviving The Curse of the Scrolls
par Aurora Dell'Anno

- New Technology Directions for Java Database Access
par Gareth Jones

- Getting the Most out of your DB2 Storage Pools
par Steve Thomas

Amicalement,

DB2usa.

Présentations du Midwest Database Users Group

2009-05-11T01:00:00.002+02:00

Bonjour,

Vous trouverez ci-dessous plusieurs présentations sur DB2 pour z/OS, disponibles sur le site du Midwest Database Users Group :

- Recursive SQL – Unleash the Power!
par Suresh Sane

- More Batch, Less Time
par Troy Coleman

- Performance Topics for DB2 Application Tuners
par Sheryl Larsen

- DB2 for z/OS Stored Procedure Performance – Language / API Comparison
par Gopal Krishnan et Todd Munk

- Leveraging zIIP, zAAP Specialty Engines with DB2 for z/OS
par Gopal Krishnan

Amicalement,

DB2usa.

Présentations du séminaire DB2 for z/OS Performance (Japon) d'IBM

2009-05-04T01:00:00.001+02:00

Bonjour,

Vous trouverez ci-dessous plusieurs présentations du séminaire DB2 for z/OS Performance (Japon) d'IBM :

- The Best Performance Practices DB2 for z/OS
par Akiko Hoshikawa

- DB2 for z/OS PureXML Overview and Performance Practices
par Akiko Hoshikawa

- DB2 for z/OS Getting the Most From SQL Optimization Hints, Tips and Best Practices
par Yoichi Tsuji

- DB2 for z/OS Evolution of SQL Optimization V7, V8 and DB2 9
par Yoichi Tsuji

Amicalement,

DB2usa.

XML avec DB2 pour z/OS

2009-04-27T01:00:00.000+02:00

Bonjour,

Vous trouverez ci-dessous plusieurs présentations et articles sur XML avec DB2 pour z/OS, disponibles sur les sites web d'IBM :

- DB2 9 for z/OS pureXML - Survival Guide for DBAs
par Guogen Zhang

- Ten Essential DBA Tasks forDB2 9 for z/OS pureXML
par Guogen Zhang and Steve Chen

- Ten Common Usage Patterns of pureXML for DB2 for z/OS Applications IBM
par Guogen Zhang

- DB2 9 for z/OS pureXML FAQs
par IBM DB2 for z/OS XML development

- Leveraging DB2 9 for z/OS pureXML Technology (2nd Edition)
par Guogen Zhang

- DB2 9 and z/OS XML System Services Synergy Update
par Judy Ruby-Brown et Akiko Hoshikawa

- XML application migration from DB2 for z/OS V8 to DB2 9
Part 1: Partial updates to XML documents in DB2 9 for z/OS
Part 2: Comparing XML functionality in DB2 9 to DB2 V8
Part 3: Sample DB2 for z/OS XML application migration scenario
par John Shelton et Hardeep Singh

En savoir plus

- DB2 for zOS pureXML Wiki
Articles, webcasts, podcasts, présentations, exemples et téléchargements

- DB2 pureXML Blog
par Qi Jin, Guogen Zhang, Matthias Nicola et d'autres membres de DB2 for z/OS Development

- XML DevelopperWorks
Articles, tutoriels et d'autres documents technqiues sur XML

Amicalement,

DB2usa.

Numéro d'hiver 2008 de DB2mag

2009-04-20T01:00:00.005+02:00

Bonjour,

Le numéro d'hiver 2008 de DB2mag est disponible en ligne : http://ibmdatabasemag.com/db_area/archives/2009/1

Note: DB2mag est devenu IBMDatabasemag.

- DB2 Data Warehouse Performance, Part 1 par Robert Catterall
Translate OLTP-tuning skills into effective performance management for DB2-based business intelligence systems.
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=216300344

- Three Tips for DB2 Java Apps par David Beulke
Keep DB2 performance high by avoiding these common Java oversights.
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=216300333

- DB2 Answers par Bonnie Baker
Compression questions and a sticky DB2 for z/OS SORT mystery are put to rest.
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=216300355

- Now with .NET applications accessing DB2 for z/OS
par Rajesh Sambandhan, Simon Harris et Todd Munk
Compression questions and a sticky DB2 for z/OS SORT mystery are put to rest.
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=216401198

- XML and the Database: A Perspective for the DBA
par Bryan Patterson et Dexiong Terry Zhang
With DB2 pureXML, DBAs can apply existing skills to manage XML growth and pursue opportunities to learn new XML skills if they choose.
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=216402743

- XML Storage Options in DB2 par Conor O'Mahony
How to decide which XML storage option best suits a particular application.
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=216403288

Amicalement,

DB2usa.

Présentations du séminaire IBM DB2 9 for z/OS Migration (France)

2009-04-13T01:00:00.001+02:00

Bonjour,

Vous trouverez ci-dessous plusieurs présentations du séminaire DB2 9 for z/OS Migration (France) d'IBM :

- DB2 for z/OS : Version 9 and Beyond (avec 25 pages sur DB2 X)
par Gareth Jones

- DB2 9 for z/OS Performance Update
par Gareth Jones

- DB2 9 for z/OS Migration Planning and Experiences
par Michael Dewert

Amicalement,

DB2usa.

Retour sur DB2 pour z/OS au cours de l'année 2008

2009-04-06T01:00:00.000+02:00

Bonjour,

Voici la liste des messages du blog Forum DB2 au cours de l'année 2008 :

- Présentations du Heart of Texas DB2 Users Group
- Technotes (FAQ) d'IBM sur DB2 pour z/OS
- IDUG Solutions Journal (Hiver 2007)
- z/Journal (numéro de décembre 2007 - janvier 2008 )
- Plus de Technotes (FAQ) d'IBM sur DB2 pour z/OS
- Redbook DB2 9 for z/OS Stored Procedures: Through the CALL and Beyond
- Le partitionnement avec DB2 pour z/OS
- Numéro d'hiver 2007 de DB2mag
- Présentations de Roger Miller
- Présentations du Dutch DB2 User Group

- Redbooks 2004-2008 et plus encore
- z/Journal (numéro de février - mars 2008)
- Présentations du Northeast Ohio Database Users Group
- Le logging avec DB2 pour z/OS
- Nouvelles Technotes (FAQ) d'IBM sur DB2 pour z/OS
- Numéro de printemps 2008 de DB2mag
- Redpaper DB2 for z/OS: Considerations on Small and Large Packages
- z/Journal (numéro d'avril - mai 2008)
- IDUG Solutions Journal (Printemps 2008)
- Redbook Enterprise Data Warehousing with DB2 9 for z/OS

- Redpaper DB2 9 for z/OS Data Sharing: Distributed Load Balancing
- z/Journal (numéro de juin - juillet 2008)
- Numéro d'été 2008 de DB2mag
- Encore plus de Technotes (FAQ) d'IBM sur DB2 pour z/OS
- Retour sur DB2 pour z/OS au cours de l'année 2007
- Sondages sur DB2 pour z/OS (2008)
- Nouvelles Technotes (FAQ) d'IBM sur DB2 pour z/OS
- Redpaper DB2 9 for z/OS: Backup and Recovery I/O Related Performance
- IBM DB2 for z/OS Road Show (printemps 2008)
- Numéro d'automne 2008 de DB2mag

- Redbook DB2 9 for z/OS: Deploying SOA Solutions
- IDUG Solutions Journal (Eté 2008)
- z/Journal (numéro d'août - septembre 2008)
- Présentations d'Isaac Yassin

Amicalement,

DB2usa.

Présentations du Colorado DB2 Users Group

2009-03-30T09:08:00.001+02:00

Bonjour,

Vous trouverez ci-dessous plusieurs présentations sur DB2 pour z/OS, disponibles sur le site du Colorado DB2 Users Group :

- DB2 9 for z/OS Migration Planning and Experiences
par John Campbell

- Optimizing System Performance Using DB2 Statistics Trace
par John Campbell

- Structure and Format Enhancements in DB2 9 : UTS & RRF
par Willie Favero

- Upgrade from DB2 for z/OS V7 to DB2 for z/OS V8 (NFM) In Less Than 90 days
par Marc Costa

- I love packages and SQLJ
par Rob Crane

- Creating customized tools for DB2 for z/OS
par Matt Ramsey et Bob Vargo

Amicalement,

DB2usa.

Redbook 50 TB Data Warehouse Benchmark on IBM System z

2009-03-16T01:59:00.002+01:00

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.

Présentations du New England DB2 Users Group

2009-03-09T01:01:00.000+01:00

Bonjour,

Vous trouverez ci-dessous plusieurs présentations sur DB2 pour z/OS, disponibles sur le site du New England DB2 Users Group :

- DB2 9 for z/OS: For Developers only!
par Craig Mullins

- Not Logged Table Spaces
par Jay Yothers

- SQL Optimization & Access Paths: What’s Old & New - Part 1
par David Simpson

- SQL Optimization & Access Paths: What’s Old & New - Part 2
par David Simpson

- Native XML support in DB2 9 for z/OS
par Phil Grainger

- DB2 9 for DBAs & Future Direction
par Roger Miller

Amicalement,

DB2usa.

Articles DB2 de la newsletter z/OS Hot Topics

2009-03-02T10:28:00.001+01:00

Bonjour,

Voici plusieurs articles sur DB2 tirés de la newsletter z/OS Hot Topics :

- The latest thrilling celebrity hook-up DB2 and DFSORT!
par R. David Boenig II

- How to use role-based security with z/OS
par Mark Nelson, Randy Love et Adrian Lobo

- Safety first zCDP for DB2
par Glenn Wilcok et Laura Kunioka-Weis

- Can you hear us now? High availability for DB2 on z/OS
par Jery Buczak

- Tales from de-crypt How secure is your DB2 data?
par Jeffrey Berger et Jeff Novak

- DB2 phone home: IMS/TM is on the line
par Blake Bauman et Jack Yuan

- DB2 RELOADED: DB2 V8 meets zSeries and z/OS
par Roger Miller

- Database on demand
par Jim Porell

- DB2: Easier to use, easier to manage
par Bryan Smith, Jim Ruddy et Dave Schwartz

En savoir plus sur les fonctionnalités z/OS

- Would you like to hear about our specials?
Prelude to the zIIP and zAAP specialty processors
par Bob Rogers

- The zIIP is a chip that’s hip!
The System z9 Integrated Information Processor
par Gita Berg

- z/OS and XML—a different approach
par Joe Bostian

- History of the mainframe poster

Amicalement,

DB2usa.

IDUG Solutions Journal (hiver 2008)

2009-02-09T02:42:00.002+01:00

Bonjour,

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

IDUG Solutions Journal Hiver 2008 (format PDF)

Il contient les articles suivants :

- Star Gazing from atop your DB2 z/OS Database Server
par Terry Purcell et Gene Fuh

- Selected Performance Features of DB2 9 for z/OS, tested in a PeopleSoft Enterprise Applications Environment - Part 2

par Brian Holroyd

- Recent DB2 for z/OS Performance Measurements
par Roger Miller

- Database Fundamentals
par Craig Mullins

Amicalement,

DB2usa.

Redbook DB2 9 for z/OS: Packages Revisited

2009-02-02T01:41:00.001+01:00

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

2009-01-26T11:39:00.002+01:00

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.

z/Journal (numéro d'octobre - novembre 2008)

2009-01-19T11:46:00.000+01:00

Bonjour,

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

- The Magic of DB2’s Prefetch
par Willie Favero

- DB2 Database Maintenance and Recovery: Getting Past the Common Misconceptions
par Brenda Honeycutt et Craig Mullins

- Reoptimizing SQL
par Craig Mullins

Amicalement,

DB2usa.

Présentations de la conférence Guide Share UK 2008

2009-01-12T01:43:00.001+01:00

Bonjour,

Vous trouverez ci-dessous plusieurs présentations issues de la conférence Guide Share UK, disponibles sur le site du UK DB2 User Group :

- To REORG or not to REORG, That is the Question
par Kevin Baker

- Reordered Row Format in DB2 9 for z/OS
par Paul Fletcher

- Memory Matters in 2009
par Martin Packer

- Lies, Damned Lies & Statistics
par Andy Ward

- DB2 for z/OS: What's all the fuss about Version 8 and Version 9?
par Gareth Jones

- DB2 9 for z/OS - Table Changes
par Phil Granger

- A Row's Life
par Raymond Bell

- Are you sure this is DB2?
par Aurora Dell'Anno

- Introduction to DB2 on the Mainframe
par Gareth Jones

Amicalement,

DB2usa.

Présentations d'Isaac Yassin

2008-12-22T09:47:00.000+01:00

Bonjour,

Vous trouverez ci-dessous plusieurs présentations d'Isaac Yassin sur DB2 pour z/OS :

- Where did I loose my memory?
par Isaac Yassin

- My Memory's not what it used to be
par Isaac Yassin

- Existence Checking: Good vs Bad
par Isaac Yassin

Amicalement,

DB2usa.

Présentations de la journée "La performance de DB2 pour z/OS" du Guide DB2

2008-11-28T17:05:00.000+01:00

Bonjour,

Voici un nouveau message du Guide DB2 z/OS France :

===================================================================
Bonjour,

Voici les trois présentations de la journée du vendredi 21 novembre 2008 (format PDF) :

- DB2 z/OS Insert Performance
par John Campbell (IBM)

- Optimizing DB2 System Performance Using DB2 Statistics Trace
par John Campbell et Florence Dubois (IBM)

- Do Extent Numbers Really Matter Any More
par Steve Thomas (BMC)

IBM vous communique le lien internet pour retrouver la procédure Rexx MEMU2
sur l'utilisation de la mémoire DB2 z/OS :
http://www.ibm.com/developerworks/exchange/dw_entryView.jspa?externalID=571&categoryID=33

Nous remercions notre sponsor BMC ainsi que les 96 personnes qui ont assisté à notre événement sur la performance de DB2 pour z/OS.

Note : Notre intervenant belge Jan Henderyckx (Brainware) n'ayant pas pu être parmi nous. En remplacement, John Campbell (IBM) a effectué une présentation supplémentaire en début de matinée sur la performance des ordres SQL Insert.

Cordialement,

Marcel Lévy marcel_guide_db2@yahoo.fr
Guide DB2 France groupe DB2A
http://www.gsefr.org/db2a
et
Laurent Kuperberg laurent.kuperberg@halcom.fr
Guide DB2 France groupe DB2B
http://www.gsefr.org/db2b

===================================================================

Amicalement,

DB2usa.

z/Journal (numéro d'août - septembre 2008)

2008-11-24T01:39:00.000+01:00

Bonjour,

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

- Want to Know What DB2 Is Doing? Take a Closer Look at DB2’s TRACE
par Willie Favero

- Aligning IT & Business: Automation Is the Key to DB2 Success
par Rick Weaver

- Going Back in Time: How to Leverage Data Imaging for DB2 Tables
par Susan Lawson et Daniel Luksetich

- DB2 9 Data Format "Stuff"
par Craig Mullins

Amicalement,

DB2usa.

IDUG Solutions Journal (Eté 2008)

2008-11-17T01:14:00.000+01:00

Bonjour,

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

IDUG Solutions Journal Eté 2008 (format PDF)

Il contient les articles suivants :

- DB2 9 - XML and the Unprepared DBA
par Mike Sniezek

- Selected Performance Features of DB2 9 for z/OS
, tested in a PeopleSoft Enterprise Applications Environment (Part 1)
par Brian Holroyd

- The Changing Priorities of Database Administration
par Lockwood Lyon

- Time to Plan for Migration Again
par Roger Miller

- Things You’ve Probably Neglected
par Craig Mullins

Amicalement,

DB2usa.

Redbook DB2 9 for z/OS: Deploying SOA Solutions

2008-11-10T19:22:00.000+01:00

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.

Numéro d'automne 2008 de DB2mag

2008-11-03T01:33:00.001+01:00

Bonjour,

Le numéro d'automne 2008 de DB2mag est disponible en ligne : http://ibmdatabasemag.com/db_area/archives/2008/4

Note: DB2mag est devenu IBMDatabasemag.

- DB2 Programmers Do Exist par Robert Catterall
And the things they do with DB2 SQL might surprise you.
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=211300260

- DB2 XML and LOB Design par David Beulke
Guidelines for DB2 for z/OS applications.
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=211300322

- The Mystery of DB2 Sorts par Bonnie Baker
Can adding SORT syntax really improve DB2 for z/OS performance?
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=211300275

Amicalement,

DB2usa.

IBM DB2 for z/OS Road Show (printemps 2008)

2008-10-27T11:56:00.001+01:00

Bonjour,

Vous trouverez ci-dessous plusieurs présentations du séminaire DB2 for z/OS américain d'IBM qui s'est déroulé au printemps 2008 :

- DB2 9 for z/OS: Latest News and a peek into the future

- DB2 for z/OS Performance

- Planning your DB2 migration

- DB2 9 for z/OS Utilities

- Delivering Business Value System z™ and DB2 for z/OS

Amicalement,

DB2usa.

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

2008-10-20T15:21:00.000+02:00

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.

Nouvelles Technotes (FAQ) d'IBM sur DB2 pour z/OS

2008-10-06T19:13:00.000+02:00

Bonjour,

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

- Does DB2 normally recover a unit of recovery without using an archive log?
- Where can I find additional information about DB2 for z/OS?
- Attempting to load more data than fits into the data set
- What Systen z features does DB2 for z/OS use?
- DESCSTAT subsystem parameter

- Reducing accounting records
- Negative buffer pool hit ratios
- How do I trace DB2 deadlocks ?
- Declaring temporary tables: Where do I put the DECLARE statement?
- DIAGNOSE DISPLAY MEPL issue

- In SAP applications for DB2, how often should you monitor the problem log?
- DSNE345I warning message from SPUFI
- How are duplicates in an IN-list handled, and, are duplicate entries a problem?
- How do I trace DB2 timeouts?
- How do I trace DB2 lock suspension problems ?

Amicalement,

DB2usa.

Report de la journée Guide "la performance de DB2 pour z/OS" au vendredi 21 novembre 2008

2008-09-10T10:32:00.001+02:00

Bonjour,

Voici un nouveau message du Guide DB2 z/OS France :

===================================================================
Bonjour,

Suite à une grève nationale à l'appel de plusieurs syndicats, le mardi 7 octobre 2008, nous préférons reporter notre événement DB2 au vendredi 21 novembre 2008 :
http://afp.google.com/article/ALeqM5hbKm4jwr0RfYK0nRUzSnx0r9VldA

Merci de vous réinscrire sur le site du Guide :
http://gsefr.org/db2b/DB2AetB-21-11-2008

Sur le site, cliquez en bas de page sur "S'inscrire à cet événement".
Nous vous enverrons une confirmation par email un peu plus tard

A bientôt.

Marcel Lévy marcel_guide_db2@yahoo.fr
Guide DB2 France groupe DB2A
http://www.gsefr.org/db2a
et

Laurent Kuperberg laurent.kuperberg@halcom.fr
Guide DB2 France groupe DB2B
http://www.gsefr.org/db2b

Réservez votre journée du vendredi 21 novembre 2008 pour un Guide DB2 pour z/OS ouvert à tous.

Les deux groupes Guide DB2 sur z/OS organisent le vendredi 21 novembre 2008 une réunion commune qui aura pour thème : "La performance de DB2 pour z/OS". Elle se déroulera chez les locaux de notre sponsor BMC à Paris-La Défense :

BMC France
Tour Manhattan
5-6 place de I'Iris
92095 Paris la Défense Cedex
Tel: 01 57 00 61 00
Métro, station Esplanade de la Défense, ligne 1
ou RER, station Grande Arche de la Défense, ligne A

Plan d'accès (Google Maps) :
http://tinyurl.com/bmcfrance

Agenda :
09h00-09h30 : Accueil (petit déjeûner)
09h30-09h55 : Mot des présidents Guide
09h55-10h15 : BMC (sponsor)
10h15-11h15 : Optimizing DB2...Through Statistics Trace 1ère partie par John Campbell et Florence Dubois (IBM)
11h15-11h30 : Pause café
11h30-12h30 : Optimizing DB2...Through Statistics Trace 2ème partie par John Campbell et Florence Dubois (IBM)
12h30-12h45 : Requirements DB2 proposés par les membres du Guide DB2 z/OS
Déjeûner
14h15-15h30 : DB2 for z/OS Application Design for Performance and Availability par Jan Henderyckx (Brainware)
15h30-15h45 : Pause café
15h45-17h00 : Do Extent Numbers Really Matter Any More? par Steve Thomas (BMC)

Un résumé des présentations se trouve en annexe.

Si vous désirez proposer des Requirements DB2 pour z/OS, merci de nous envoyer un email avec la description du problème ainsi que la solution proposée. Lors de la réunion, nous expliquerons les différentes propositions et nous voterons pour choisir les plus pertinentes. Le Guide Share France communiquera nos choix à IBM.

Vu l'intérêt du sujet, cette réunion est ouverte à tout le monde, n'hésitez pas à en parler autour de vous. Attention, cette année, nous sommes limités à 80 places.Les inscriptions sont ouvertes à l'adresse internet suivante :
http://gsefr.org/db2b/DB2AetB-21-11-2008

Sur le site, cliquez en bas de page sur "S'inscrire à cet événement".
Nous vous enverrons une confirmation par email un peu plus tard

A bientôt.

Marcel Lévy marcel_guide_db2@yahoo.fr
Guide DB2 France groupe DB2A
http://www.gsefr.org/db2a
et
Laurent Kuperberg laurent.kuperberg@halcom.fr
Guide DB2 France groupe DB2B
http://www.gsefr.org/db2b

Annexe :

Optimizing DB2...Through Statistics Trace par John Campbell (IBM) et Florence Dubois (IBM)
This presentation will go into some detail about how to use the DB2 Statistics Trace, introducing and discussing some thirty rules used by the presenter over many years to: evaluate DB2 system performance, filter for bad coniditions and recommend actions (CPU, Bufferpool, EDM pool, active logging , tuning sort).

DB2 9 Application Design for Performance and Availability par Jan Henderyckx (Brainware)
As with every version of DB2 new features are introduced that introduce better and faster ways to get things done. In the area of high availability and performance DB2 9 introduces a whole set of options that make life easier and faster. But as usual not all problems are gone, what else would we get in version next. This presentation goes into the V9 new functions and covers how this can help you and where you still need to pay attention.

Do Extent Numbers Really Matter Any More? par Steve Thomas (BMC)
Over recent years there have been some huge advances in Disk Storage Technology. Despite this many DB2 sites I visit are still using rules of thumb related based more on 3380 and 3390 disks from the 1980's rather than on the modern RAID based arrays such as the IBM DS8300 series they are actually using. A typical example is the thorny question of how many extents an object should use before it is subjected to a Reorg. This presentation explains some of the recent and not so recent technical advances in disk related technology and related changes to the z/OS Operating system. Topics covered include PAV, HyperPAV and MIDAW, along with Software based solutions that exploit these new capabilities such as Flashcopy and GDPS. The aim is to get the audience to review some of their out of date thinking on all aspects of storage technology.

===================================================================

Amicalement,

DB2usa.

Journée Guide "la performance de DB2 pour z/OS" le mardi 7 octobre 2008

2008-08-29T15:10:00.009+02:00

Bonjour,

Voici un message du Guide DB2 z/OS France :

===================================================================

Réservez votre journée du mardi 7 octobre 2008 pour un Guide DB2 pour z/OS ouvert à tous.
Les deux groupes Guide DB2 sur z/OS organisent le mardi 7 octobre 2008 une réunion commune qui aura pour thème : "La performance de DB2 pour z/OS".

Elle se déroulera chez les locaux de notre sponsor BMC à Paris-La Défense :

Tour Manhattan
5-6 place de I'Iris
92095 Paris la Défense Cedex
Tel: 01 57 00 61 00
Métro, station Esplanade de la Défense, ligne 1
ou RER, station Grande Arche de la Défense, ligne A

Plan d'accès (Google Maps) :
http://tinyurl.com/bmcfrance

Agenda :
09h00-09h30 : Accueil (petit déjeûner)
09h30-09h55 : Mot des présidents Guide
09h55-10h15 : BMC (sponsor)
10h15-11h15 : Optimizing DB2...Through Statistics Trace 1ère partie par John Campbell et Florence Dubois (IBM)
11h15-11h30 : Pause café
11h30-12h30 : Optimizing DB2...Through Statistics Trace 2ème partie par John Campbell et Florence Dubois (IBM)
12h30-12h45 : Requirements DB2 proposés par les membres du Guide DB2 z/OS
Déjeûner
14h15-15h30 : DB2 for z/OS Application Design for Performance and Availability par Jan Henderyckx (Brainware)
15h30-15h45 : Pause café
15h45-17h00 : Do Extent Numbers Really Matter Any More? par Steve Thomas (BMC)

Un résumé des présentations se trouve en annexe.

Si vous désirez proposer des Requirements DB2 pour z/OS, merci de nous envoyer un email avec la description du problème ainsi que la solution proposée.
Lors de la réunion, nous expliquerons les différentes propositions et nous voterons pour choisir les plus pertinentes.
Le Guide Share France communiquera nos choix à IBM.

Vu l'intérêt du sujet, cette réunion est ouverte à tout le monde, n'hésitez pas à en parler autour de vous. Attention, cette année, nous sommes limités à 80 places.

Les inscriptions sont ouvertes à l'adresse internet suivante :

http://www.gsefr.org/db2b/DB2AetB-7-10-2008%20/DB2AetB-guide-commun-2008

Sur le site, cliquez en bas de page sur "S'inscrire à cet événement".
Nous vous enverrons une confirmation par email un peu plus tard

A bientôt.

Marcel Lévy marcel_guide_db2@yahoo.fr
Guide DB2 France groupe DB2A
http://www.gsefr.org/db2a

et

Laurent Kuperberg laurent.kuperberg@halcom.fr
Guide DB2 France groupe DB2B
http://www.gsefr.org/db2b

Annexe :

Optimizing DB2...Through Statistics Trace par John Campbell (IBM) et Florence Dubois (IBM)
This presentation will go into some detail about how to use the DB2 Statistics Trace, introducing and discussing some thirty rules used by the presenter over many years to: evaluate DB2 system performance, filter for bad coniditions and recommend actions (CPU, Bufferpool, EDM pool, active logging , tuning sort).

DB2 9 Application Design for Performance and Availability par Jan Henderyckx (Brainware)
As with every version of DB2 new features are introduced that introduce better and faster ways to get things done. In the area of high availability and performance DB2 9 introduces a whole set of options that make life easier and faster. But as usual not all problems are gone, what else would we get in version next. This presentation goes into the V9 new functions and covers how this can help you and where you still need to pay attention.

Do Extent Numbers Really Matter Any More? par Steve Thomas (BMC)
Over recent years there have been some huge advances in Disk Storage Technology. Despite this many DB2 sites I visit are still using rules of thumb related based more on 3380 and 3390 disks from the 1980's rather than on the modern RAID based arrays such as the IBM DS8300 series they are actually using. A typical example is the thorny question of how many extents an object should use before it is subjected to a Reorg. This presentation explains some of the recent and not so recent technical advances in disk related technology and related changes to the z/OS Operating system. Topics covered include PAV, HyperPAV and MIDAW, along with Software based solutions that exploit these new capabilities such as Flashcopy and GDPS. The aim is to get the audience to review some of their out of date thinking on all aspects of storage technology.
===================================================================

Amicalement,

DB2usa.

Sondages sur DB2 pour z/OS (2008)

2008-08-20T14:37:00.000+02:00

Retour sur DB2 pour z/OS au cours de l'année 2007

2008-08-18T21:53:00.000+02:00

Bonjour,

Voici la liste des messages du blog Forum DB2 au cours de l'année 2007 :

- z/Journal (numéro d'octobre-novembre 2006)
- Technotes IBM DB2 z/OS
- Asked and Answered : la suite (Robert Catterall)
- Optimisation avec la version 8 DB2 de DB2 z/OS
- IDUG Solution Journal (Hiver 2006)
- Les versions de DB2 pour z/OS
- Expert Answer Center (Craig Mullins)
- Procédures stockées sur DB2 pour z/OS
- Le 16 mars 2007 : disponibilité de la version 9 de DB2 pour z/OS
- Présentations DB2 pour z/OS Version 9

- Présentations de l'IDUG en version multimédia
- Sondages sur DB2 pour z/OS Version 8
- z/Journal (numéro de février-mars 2007)
- Asked and Answered : encore (Robert Catterall)
- Sécurité avec DB2 pour z/OS Versions 8 et 9
- Présentations SQL
- IDUG Solutions Journal (Printemps 2007)
- Présentations sur le Catalogue DB2
- Numéro de printemps 2007 de DB2mag
- Plus de présentations SQL sur DB2 pour z/OS Version 8

- Expert Answer Center (Craig Mullins) 2ème partie
- z/Journal (numéro d'avril-mai 2007)
- Redbook DB2 9 for z/OS Technical Overview
- Présentations sur les chemins d'accès
- Deux nouveaux Redbooks sur SAP et DB2 9 pour z/OS
- Migration vers la version 8 de DB2 pour z/OS (podcasts)
- DB2 9 pour z/OS par Craig Mullins
- DB2 9 pour z/OS par Willie Favero
- Numéro d'été 2007 de DB2mag
- Redbook DB2 9 for z/OS Performance Topics

- z/Journal (numéros de juin-juillet et d'août-septembre 2007)
- Articles DB2 d'IBM Systems Magazine
- Présentations SQL du Tampa Bay Relational Users Group
- IDUG Solutions Journal (Eté 2007)
- Journée Guide "DB2 Version 8" le 22 Novembre 2007
- Redbook DB2 9 for z/OS: New Tools for Query Optimization
- Inscription à la journée DB2 pour z/OS Version 8
- Numéro d'automne de DB2Mag
- Présentations du DB2 for z/OS Technical Forum (Chine)
- Blog de Robert Catterall
- z/Journal (numéro d'octobre-novembre 2007)
- Blog de Troy Coleman
- Présentations de Craig Mullins et de Sheryl Larsen
- Présentations de Bryan Smith
- Présentations du DB2 for z/OS Technical Forum (Taiwan)

Amicalement,

DB2usa.

Encore plus de Technotes (FAQ) d'IBM sur DB2 pour z/OS

2008-08-11T19:30:00.003+02:00

Bonjour,

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

- Functions available in conversion mode vs. new-function mode
- DSNE345I warning message from SPUFI
- How are duplicates in an IN-list handled? Is it a performance problem?
- SQLCODE189 returned on SELECT with a CAST function specifying a numeric CCSID
- How will my stored procedures be impacted by migration to Version 9.1?

- DB2 coprocessor/precompiler: Generated structures for LOB and XML host variables
- Improving the performance of incremental image copies
- Future direction for the BookManager format
- DSSIZE and number of partitions
- CLOB columns are not always indexed

- How do I get a copy of DB2 Estimator?
- Results of Querying Catalog are in Unicode
- IBM-supplied stored procedure package versions
- Parser changes the logical not sign character to the circumflex accent character
- Keywords for searching APAR text

Amicalement,

DB2usa.

Numéro d'été 2008 de DB2mag

2008-08-04T22:46:00.002+02:00

Bonjour,

Le numéro d'été 2008 de DB2mag est disponible en ligne : http://ibmdatabasemag.com/db_area/archives/2008/3

Note: DB2mag est devenu IBMDatabasemag.

- IBM Data Studio pureQuery Runtime for z/OS Performance par Rajesh Sambandhan et Simon Harris
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=208802229

- Get On the Enterprise Service Bus par Robert Catterall
It's no magic bullet, but enterprise service bus technology hits the mark for certain transactions.
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=209900050

- DB2 Leads with Innovation par David Beulke
DB2 for z/OS financial incentive programs open new horizons for data warehousing and other applications.
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=209900069

- The Mystery of DB2 for z/OS Index-only Updates and Deletes par Bonnie Baker
Can a DB2 for z/OS index-only UPDATE or DELETE really be index only?
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=209900061

Amicalement,

DB2usa.

z/Journal (numéro de juin - juillet 2008)

2008-07-28T00:51:00.000+02:00

Bonjour,

Les articles du numéro de Juin - juillet 2008 de z/Journal sont disponibles en ligne : http://www.zjournal.com

- Data Warehousing With DB2 for z/OS … Again!!!
par Willie Favero

- The Rise of Dynamic SQL
par Craig Mullins

Amicalement,

DB2usa.

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

2008-07-21T10:40:00.001+02:00

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

2008-06-30T17:55:00.001+02:00

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)

2008-06-16T19:17:00.000+02:00

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)

2008-06-09T02:29:00.000+02:00

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

2008-06-02T00:41:00.002+02:00

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

Numéro de printemps 2008 de DB2mag

2008-05-26T09:41:00.000+02:00

Bonjour,

Le numéro de printemps 2008 de DB2mag est disponible en ligne : http://ibmdatabasemag.com/db_area/archives/2008/2

Note: DB2mag est devenu IBMDatabasemag.

- Exploring pureXML in DB2 9 for z/OS par Kirsten Larsen et Michael Schwartzbach
http://ibmdatabasemag.com/story/showArticle.jhtml?articleID=207801115

- Can SOA Perform? par Robert Catterall
The answer is yes, but only if you leave old-school application ideas behind.
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=207801123

- Common DB2 Performance Pitfalls par David Beulke
Build your applications right from the start by avoiding these typical missteps.
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=207801294

- The Mystery of the DB2 SIX Lock par Bonnie Baker
The truth behind this enigmatic lock and other DB2 for z/OS stumpers.
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=207801138

Amicalement,

DB2usa.

Nouvelles Technotes (FAQ) d'IBM sur DB2 pour z/OS

2008-05-12T00:03:00.000+02:00

Bonjour,

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

- SQLCODE -104 on a CREATE TRIGGER statement
- How does Oracle's Real Application Clusters (RAC) compare with Data Sharing?
- Checklist for ABEND04E RC00E30099 on -START DB2 or ABEND=S04F
- Can encryption be turned on in SYSIBM.USERNAMES for the password column?

- BIND PLAN ... ACTION(ADD), why do I receive message DSNT220I?
- What is the scope of the RETRY parameter for the REORG utility?
- ALTER table space to TRACKMOD NO
- What are DB2 SQL Procedures?

- Why can't I order REXX in Version 8?
- Keywords for searching APAR text
- How do I find the code page that a specific DB2 table is using?
- EDM POOL FULL condition after migrating to V8 NFM

- Finding DECLARE CURSOR statements in the DB2 catalog in DB2 Version 8
- Running the RACF access control exit routine for one DB2 version ...
- DESCSTAT=YES
- User catalog is out of space

- Does MODIFY RECOVERY always gets an exclusive DBD lock to update a DBD?
- Comma as decimal point
- Packages versus plans
- Can I use the cross-loader function with LOB columns?

Amicalement,

DB2usa.

Le logging avec DB2 pour z/OS

2008-04-21T12:29:00.000+02:00

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.

Présentations du Northeast Ohio Database Users Group

2008-04-14T10:06:00.001+02:00

Bonjour,

Vous trouverez ci-dessous plusieurs présentations sur DB2 pour z/OS, disponibles sur le site du Northeast Ohio Database Users Group :

- Tablespace Partitioning for DB2 V8: Maintenance,Performance and more
par Troy Coleman

- The Perfect Combination: System z, z/OS, and DB2
par Willie Favero

- The Best Defense is a Good Offense (DB2 for z/OS Version 8 Migration Planning)
par Willie Favero

- DB2 Connections to DB2 for z/OS (Distributed Functions of DB2 for z/OS)
par Paul Wirth

- Managing Distributed, Dynamic Workloads on DB2
par Progressive

- Progressive’s DB2 Tools and Utilities
par Progressive

Amicalement,

DB2usa.

z/Journal (numéro de février - mars 2008)

2008-04-07T11:19:00.003+02:00

Bonjour,

Les articles du numéro de février - mars 2008 de z/Journal sont disponibles en ligne : http://www.zjournal.com

- The Big Deal About Making Things Smaller: DB2 Compression
par Willie Favero

- Much Ado About DB2 9 Locking
par Craig Mullins

En savoir plus

Voici une présentation sur Universal table spaces et Reordered Row Format de Willie Favero :

- Structure and Format Enhancements in DB2 9 for z/OS

Amicalement,

DB2usa.

Redbooks 2004-2008 et plus encore

2008-03-31T11:26:00.002+02:00

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.

Présentations du Dutch DB2 User Group

2008-03-17T09:03:00.000+01:00

Bonjour,

Vous trouverez ci-dessous plusieurs présentations sur DB2 pour z/OS, disponibles sur le site du Dutch DB2 User Group (DDUG) :

- DB2 for z/OS An A-Z of Performance
par Phil Grainger

- DB2 for z/ OS: Utilities and Application Development
par Eric Venmans

- DB2 and WebSphere - Capita Selecta
par Kris Van Thillo

- How healthy are our DB2 for z/ OS Environments in 2005?
par Andre Goetschy

Amicalement,

DB2usa.

Présentations de Roger Miller

2008-03-10T12:25:00.001+01:00

Bonjour,

Vous trouverez ci-dessous plusieurs présentations de Roger Miller, disponibles sur le site d'IBM :

- Migration to DB2 9 for z/OS
par Roger Miller

- zIIP, zAAP, and DB2
par Roger Miller

- DB2 for z/OS Security: Protect Your Assets An overview of DB2 security
par Roger Miller

- Best Practices in DB2 for z/OS Security
par Roger Miller

- Why z/OS for your Data Warehouse?
par Roger Miller

En savoir plus

- DB2 History: from DB2 for MVS V1R1 to DB2 9 for z/OS
par Roger Miller

- DB2 for z/OS Trends and Directions
par Gregory Lotko

Amicalement,

DB2usa.

Numéro d'hiver 2007 de DB2mag

2008-03-03T14:34:00.005+01:00

Bonjour,

Le numéro d'hiver 2007 de DB2mag est disponible en ligne :
http://ibmdatabasemag.com/db_area/archives/2008/1

DB2mag devient IBMDatabasemag comme expliqué dans l'article ci-dessous :

- DB2 Magazine is now IBM Database Magazine par Kim Moutsos
http://ibmdatabasemag.com/story/showArticle.jhtml?articleID=206800435

- pureQuery and DB2 9 Shine par David Beulke
pureQuery and DB2 for z/OS provide better performance and developer coding flexibility.
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=206800608

- DB2 DBA: Elevating the DBA Role par Robert Catterall
Is it time to retire the DBA title for one that represents the real work DB2 DBAs do?
http://www.db2mag.com/story/showArticle.jhtml?articleID=202400154

En savoir plus

- Asked and Answered: DB2 for z/OS Buffer Pools and CPU Time
par Robert Catterall

Amicalement,

DB2usa.

Le partitionnement avec DB2 pour z/OS

2008-02-25T19:17:00.002+01:00

Bonjour,

Vous trouverez ci-dessous deux présentations sur le partitionnement avec DB2 pour z/OS Version 8, disponibles sur le site web du Guide Share France :

- Partitioning Scary Stories
par Phil Grainger

- Table Controlled Partitioning - The rules of the game
par Kurt Struyf

En savoir plus

- Partitioning in DB2 8 for z/OS - The Good, The Bad and The Ugly
par Steen Rasmussen

- Not Your Father's Partitioned Table!
par Craig Friske

- DB2 Managing Large Partitioned Tables in V8
par Craig Friske

- Major Index Changes in DB2 Version 8
par Jim Teng

Amicalement,

DB2usa.

Redbook DB2 9 for z/OS Stored Procedures: Through the CALL and Beyond

2008-02-18T19:40:00.001+01:00

Bonjour,

IBM vient de mettre à disposition une version de travail d'un nouveau Redbook intitulé, "DB2 9 for z/OS Stored Procedures: Through the CALL and Beyond, SG24-7604-00" :
http://www.redbooks.ibm.com/redpieces/abstracts/sg247604.html

Résumé
This IBM Redbooks publication helps you design, install, manage, and tune stored procedures with DB2 9 for z/OS. Stored procedures can provide major benefits in the areas of application performance, code re-use, security, and integrity. DB2 has offered an ever improving support for developing and operating stored procedures.
In these days, three years is a generation in the software business; if you have DB2 9 for z/OS, this book replaces the previous DB2 for z/OS Stored Procedures: Through the CALL and Beyond, SG24-7083-00, and it reflects the changes that have happened to DB2 stored procedures and related tools from V8 to V9.
We show how to develop stored procedures in several languages, including Java; we explore the functions available for the z/OS platform deployment; and provide recommendations on setting up and tuning the appropriate stored procedure environment.
We talk about the external and native SQL procedures, the debugging options, the special registers, the deployment, and diagnostics.
A chapter is devoted to the increasing number of DB2-supplied stored procedures. They can be used for almost all of a DBA’s tasks.
We also devote a part to tools which can be used for accelerating the development process and go in some detail about the stored procedure support provided by the latest IBM product: Data Studio.

Sommaire
Part 1. Introduction
Chapter 1. Importance of stored procedures
Chapter 2. Stored procedures overview
Chapter 3. Our case study
Part 2. Operating environment
Chapter 4. Setting up and managing Workload Manager
Chapter 5. Language Environment setup
Chapter 6. RRSAF
Chapter 7. Security and authorization
Chapter 8. Operational issues
Part 3. Developing stored procedures
Chapter 9. Defining stored procedures
Chapter 10. COBOL programming
Chapter 11. C programming
Chapter 12. REXX programming
Chapter 13. Java stored procedures
Chapter 14. External SQL procedures
Chapter 15. Native SQL procedures
Chapter 16. Debugging
Chapter 17. Remote stored procedure calls
Chapter 18. Code level management
Part 4. Performance
Chapter 19. General performance considerations
Chapter 20. Server address space management
Chapter 21. I/O performance management
Part 5. Extending the functions
Chapter 22. Multi-threaded stored procedures in C language
Chapter 23. Accessing CICS and IMS
Chapter 24. DB2-supplied stored procedures
Chapter 25. Using LOBs and XML
Chapter 26. Using triggers and UDFs
Part 6. Cool tools for an easier life
Chapter 27. The IBM Data Studio
Chapter 28. Tools for debugging DB2 stored procedures
Chapter 29. Debugging DB2 V8 Java procedures with Data Studio
Appendix A. Samples for using DB2-supplied stored procedures
Appendix B. Additional material

Amicalement,

DB2usa

Plus de Technotes (FAQ) d'IBM sur DB2 pour z/OS

2008-02-11T10:25:00.001+01:00

Bonjour,

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

- Is it necessary to increase the size of DB2 group buffer pools?
- Attempting to load more data than fits into the data set
- Unicode data is converted to hex strings

- Nested Stored Procedures
- Enabling trusted connections requires support for distributed identity mapping
- How to access an alias in a distributed environment?

- How do I determine the number of rows in the result table of a cursor?
- Grant insert authority on view fails with SQLCODE -551
- MAX and MIN built-in functions

- Resetting REORP and RECP after REORG fails and SYSUT1 is no longer available
- What is DB2 Accounting Class 2 Not Accounted Time?
- What are the dispositions for data sets that are dynamically allocated by utilities?

- Does DB2 normally recover a unit of recovery without calling for an archive log?
- Reducing accounting records
- How do I reallocate DSNDB07 work files that are used for sort processing?

Amicalement,

DB2usa.

z/Journal (numéro de décembre 2007 - janvier 2008 )

2008-02-04T17:06:00.000+01:00

Bonjour,

Les articles des numéros de décembre 2007 - janvier 2008 de z/Journal sont disponibles en ligne : http://www.zjournal.com

- The Mathematics of Bad Luck: Risk Management in a DB2 Environment
par Karl Henn

- The Evolution of Database Security
par Craig Mullins

Voici un nouveau blog sur DB2 pour z/OS de Peggy Zagelow (IBM SVL) disponible sur le site web d'IBM :

- Hot Topics around DB2 for z/OS

Amicalement,

DB2usa.

IDUG Solutions Journal (Hiver 2007)

2008-01-21T16:25:00.000+01:00

Bonjour,

Le numéro d'hiver 2007 de l'IDUG Solutions Journal est disponible en ligne :

IDUG Solutions Journal Hiver 2007 (format PDF)

Il contient les articles suivants :

- DB2/Java Myths Debunked
par Julian Stuhler

- SQL Performance Tuning for Application Developers
par Peter Plevka

- Compliance Needs Drive Data Acess Auditing Requirements
par Craig Mullins

Amicalement,

DB2usa.

Technotes (FAQ) d'IBM sur DB2 pour z/OS

2008-01-14T18:21:00.000+01:00

Bonjour,

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

- Installation Verification Procedures (IVP) Problems
- Finding DECLARE CURSOR statements in the DB2 catalog in DB2 Version 8
- Where can I find the service-end dates for all versions of DB2?

- Running the RACF access control exit routine for one DB2 version ....
- User catalog is out of space
- Does the MODIFY RECOVERY utility always gets an exclusive DBD lock ...

- Comma as decimal point
- Packages versus plans
- Can I use the cross-loader function with LOB columns?

- DB2 coprocessor/precompiler: Generated structures for LOB and XML host variables
- What settings control the DDF enclave portion of CPU usage?
- How do I find the service level of a specific DB2 module?

- How can I find the secondary IDS for a given primary ID
- Can I load ROWID columns that are defined as GENERATED ALWAYS?
- Automating COLGROUP and RUNSTATS

- Can I use large object data types (LOBs) in DB2 for z/OS?
- DESCSTAT subsystem parameter
- Where can I find books about DB2 for z/OS?

- SQLCODE -104 on a CREATE TRIGGER statement using syntax supported by DB2 LUW
- Version 8 BIND when JCL points to Version 7 libraries
- Receiving SQLCODE -301 when running the REXX application program

Amicalement,

DB2usa.

Presentations du Heart of Texas DB2 Users Group

2008-01-07T15:47:00.000+01:00

Bonjour,

Vous trouverez ci-dessous plusieurs présentations sur DB2 pour z/OS, disponibles sur le site du Heart of Texas DB2 Users Group :

- What’s New with the Optimizer in DB2 for z/OS V8?
par Terry Purcell et Brian Baggett

- More Ways to Challenge the DB2 z/OS Optimizer
par Terry Purcell

- Parlez-Vous Klingon? Recursion SQL for Generating Test Data
par Alexander Kopac

- Demystifying the DB2 Dynamic Statement Cache
par Bill Arledge

Amicalement,

DB2usa.

Présentations du DB2 for z/OS Technical Forum (Taiwan)

2007-12-17T14:40:00.000+01:00

Bonjour,

Vous trouverez ci-dessous plusieurs présentations du DB2 for z/OS Technical Forum (Taiwan) d'IBM :

- DB2 Data Sharing Overview
par Jim Teng

- Utilities Enhancements in DB2 V8 and V9
par Sam Wang

- What’s New in DB2 for z/OS V8 for Adminstrators
par Jim Teng

- SQL Optimization Concept
par Fen-Ling Lin et Gene Fuh

- Performance Tuning Recommendations When Migrating to DB2 for z/OS V8
par Jim Teng

- Native SQL Procedures in DB2 9 for z/OS
par Yumi Tsuji etnd Steve Chen

- New SQL Features for DB2 z/OS V8 and V9
par Fen-Ling Lin

- zIIP Introduction
par Fen-Ling Lin

- Automating SQL Performance Tuning in DB2 for z/OS
par Gene Fuh

- Introduction to pureXML in DB2 9 for z/OS
par Guogen Zhang et Steve Chen

- Universal Table Space and LOB Enhancements DB2 9 for z/OS
par Frances Villafuerte

Amicalement,

DB2usa.

Présentations de Bryan Smith

2007-12-10T10:34:00.001+01:00

Bonjour,

Vous trouverez ci-dessous plusieurs présentations de Bryan Smith, disponibles sur le site du Southwest DB2 User Group :

- IBM DB2 RUNSTATS Utility and Real-Time Statistics
par Bryan Smith

- IBM DB2 Utility Update - Best Practices
par Bryan Smith

- DB2 9 for z/OS and Beyond
par Bryan Smith

Amicalement,

DB2usa.

Présentations de Craig Mullins et de Sheryl Larsen

2007-12-03T16:59:00.000+01:00

Bonjour,

Vous trouverez ci-dessous deux présentations de Craig Mullins, disponibles sur le site du Houston Area DB2 User Group :

- Null and Void? Dealing with Nulls in DB2
par Craig Mullins

- Managing Data for Long Term Retention
par Craig Mullins

Voici un tutoriel sur les chemins d'accès DB2, disponible sur le site de Sheryl Larsen :

- Access Paths Tutorial
par Sheryl Larsen

Amicalement,

DB2usa.