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

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

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

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)

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

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

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

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

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 database administrator 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

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

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