Asked and Answered (Robert Catterall)

Bonjour,

Vous trouverez ci-dessous une première série de "Questions/Réponses" de Robert Catterall sur DB2 pour z/OS parues dans DB2mag :


- When a program contains a static SQL statement that references an unqualified table name, how can you know ...?
http://www.db2mag.com/story/showArticle.jhtml?articleID=191502413

- Where can I find a code snippet for accessing DB2 for z/OS stored procedures in Java using input parameters?
http://www.db2mag.com/story/showArticle.jhtml?articleID=175001334

- What's your recommendation for performing DB2 v.7 traces running under z/OS V1R4 in a production environment?
http://www.db2mag.com/story/showArticle.jhtml?articleID=173403206

- Could you provide some recommendations for conserving disk space on a mainframe?
http://www.db2mag.com/story/showArticle.jhtml?articleID=167100906

- What's the best way to implement stored procedures as the communication mechanism to a mainframe?
http://www.db2mag.com/qanda/050719.shtml

- Do you know of any products that use DRDA without a local DB2 in an MVS (OS/390, Z/OS) environment?
http://www.db2mag.com/qanda/050615.shtml

- How the DBA roles differ between Linux, Unix, and Windows (LUW) and the mainframe?
http://www.db2mag.com/qanda/050315.shtml

- Why does PROGRAM TYPE SUB minimize the number of moduel reloads in in the WLM-managed stored procedures address spaces, and are there any drawbacks to that approach?
http://www.db2mag.com/qanda/041117-2.shtml

- Would the DB2 Governor work as an interim solution that would let us assign higher priority for online requests and lower priority for batch?
http://www.db2mag.com/qanda/041117-3.shtml

- Do you have to use WLM-managed stored procedure execution environments if you want to use one DB2 for z/OS stored procedure program for multiple different schemas in a database — or are there other options?
http://www.db2mag.com/qanda/040817.shtml

- What steps can we take to achieve faster group restart for a four-member data sharing group?
http://www.db2mag.com/qanda/040622.shtml

- Do the DB2 v.7 for z/OS ZPARMS SRTPOOL and MAXRBLK refer to the global respective sort spaces or to the SORT and RID SORT pools for each individual user?
http://www.db2mag.com/qanda/040316.shtml



Amicalement,

DB2usa.

Numéro d'hiver de DB2mag

Bonjour,

Le numéro d'hiver 2006 de DB2mag est disponible en ligne : http://www.db2mag.com/db_area/archives/2006/q4


- DB2 9 for z/OS Roars to Life par Craig Mullins :
The mainframe DB2 data server revs up its new hybrid XML/relational engine. Security enhancements, SQL upgrades, and performance improvements complete the package.
http://www.db2mag.com/story/showArticle.jhtml?articleID=193105300

- REBIND Magic with V8 par Bonnie Baker :
It takes some time and some nerve, but it’s worth it.
http://www.db2mag.com/story/showArticle.jhtml?articleID=193105270

- Understanding XML par Robert Catterall :
Your company is probably already using it. It’s time to figure out how to manage it.
http://www.db2mag.com/story/showArticle.jhtml?articleID=193105313

- Asked & Answered par Uri Lifshitz :
In a DB2 for z/OS system that comprises tens of thousands of tables (and even more indexes), how can I find out which database tables require maintenance without running a lot of reports?
http://www.db2mag.com/story/showArticle.jhtml?articleID=193105316


Amicalement,

DB2usa.

Participez à la mise à jour d'un redbook DB2 SAP pour z/OS V9

Bonjour,

IBM vous propose de participer à la mise à jour de la version 9 du redbook DB2 intitulé :

- Best Practices for SAP Business Information Warehouse

dont le nouveau titre est :

- Update Best Practices for SAP BIW for DB2 V9, ZS-S230-R01


Description
Clients will want to know how to exploit the new features of both DB2 v9 and SAP in their SAP BW environments. This IBM Redbook will describe the benefits of DB2 V9 for SAP Business Information Warehouse. It will cover best practices, and provides performance and tuning recommendations.SAP Business Information Warehouse is the central reporting tool for almost all SAP business solutions. It is based on building blocks called InfoObjects that contain data about customers, sales, and business information. InfoObjects include InfoSources, ODS objects, and InfoCubes. The business intelligence solution from IBM and SAP can help you aggregate and leverage this information, giving you a system-wide view of your business data and delivering it across your enterprise to support sound business decisions.However, this structure can lead to slow performance if the system is not set up and managed according to good database principles. This redbook describes best practices for this product on a zSeries platform, and provides performance and tuning recommendations for loading and querying data. It also addresses general system administration and troubleshooting.The audience for this redbook includes SAP and DB2 administrators. Knowledge of these products and of the z/OS environment is assumed.


Sommaire prévu
Chapter 1. Introduction
Chapter 2. Top ten SAP BW recommendations
Chapter 3. Best practices for PSA
Chapter 4. Best practices for InfoCubes
Chapter 5. Best practices forODS
Chapter 6. Tips for SQL efficiency
Chapter 7. Troubleshooting poor performance
Chapter 8. SAP BW installation and checks under z/OS
Chapter 9. DB2
Chapter 10. Concepts and terminology
Chapter 11. Benefits of DB2 V9 and the zSeries platform
Appendix A. SAP BW OSS Notes


Objectifs
The objectives of this residency are:
- List reasons to run SAP business information warehouse on a zSeries environment
- Describe the best practices for this environment, such as DB2 hardware compression, SAP compression, and DB2 partitioning
- Describe and demonstrate the benefits of DB2 V9 for SAP BW, such as DPSI, table controlled partitioning, clustering , and improved statistics collection and MQTs
- Describe a process to analyze and optimize query performance
- Describe how to analyze partitioning requirements for an ODS
- Discuss index design for ODSs
- Identify statistics requirements for infocubes and ODS
- Compare parallelism of SAP multiprovider with DB2 partitioning
- Discuss how to exploit transaction-based DB2 accounting and WLM prioritization in SAP BW
- Demonstrate converting an unpartitioned infocube to partitioned format


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



Amicalement,

DB2usa

Redbook Data Sharing in a Nutshell

Bonjour,

IBM vient de mettre à disposition un nouveau Redbook intitulé, "DB2 for z/OS: Data Sharing in a Nutshell, SG24-7322-00" :
http://www.redbooks.ibm.com/redpieces/abstracts/sg247322.html?Open


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 many improvements to availability and capacity without impacting existing applications. The road to data sharing might seem arduous if you are 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. Our book does not have all the answers, since 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
Introduction
Data sharing architecture
The coupling facility
Implementing data sharing
Dynamic workload balancing
Operations
Advanced topics
Best practices



En savoir plus :

La documentation" DB2 UDB for z/OS Data Sharing Planning and Administration, Version 8" est disponible sous trois formats sur le site d'IBM :

- Information Center

- HTML (Bookmanager)

- PDF


Amicalement,

DB2usa.

Encore des présentations sur la migration DB2 V8

Bonjour,

Vous trouverez ci-dessous plusieurs présentations sur la migration vers DB2 pour z/OS V8 :

Retour d'expérience d'utilisateurs DB2

- DB2 V8 User Experiences - How To Get To V8
par Bob Perih, Citigroup
http://ew.share.org/proceedingmod/abstract.cfm?abstract_id=13736

- DB2 V8 User Experiences: Why Should You Go to V8 and What To Do When You Get There?
par Bob Perih, Citigroup
http://ew.share.org/proceedingmod/abstract.cfm?abstract_id=13943

- DB2 UDB for z/OS V8 Migration: An Ironman event
par Joan Keemle (John Deere)
http://www-1.ibm.com/support/docview.wss?&uid=swg27006236

- DB2 for z/OS V8 Enterprise Migration - One User's Experiences
par Mark Ediger (Acxiom)
http://ew.share.org/proceedingmod/abstract.cfm?abstract_id=13245

- V8 Migration Steps and Considerations
par David Owen (DOCE)
http://www-1.ibm.com/support/docview.wss?&uid=swg27005641


Conseils d'IBM

- Migrating to z/OS Enablement Version 8
par IBM SVL
http://www-1.ibm.com/support/docview.wss?&uid=swg27006136

- Planning Your Migration to DB2 for z/OS Version 8
par Roger Miller (IBM SVL)
http://www-1.ibm.com/support/docview.wss?uid=swg27007841

- Lessons Learned with DB2 for z/OS V8
par Haakon Roberts (IBM SVL)
http://www.gse-nordic.org/forum/wg/nrtc/2005/S35_LessonsLearnedwithDB2forzOSV8.pdf

- Performance issues in migrating to DB2 UDB for z/OS V8
par Akira Shibamiya (IBM SVL)
http://www-1.ibm.com/support/docview.wss?&uid=swg27006177

- Migration to DB2 for z/OS, Version 8
par Jay Yothers (IBM SVL)
http://www-1.ibm.com/support/docview.wss?&uid=swg27004345

- DB2 for z/OS Version 8, Major Migration Considerations
par Jay Yothers (IBM SVL)
http://www-1.ibm.com/support/docview.wss?&uid=swg27004031


et aussi
- DB2 for z/OS V8 Migration and Experiences
par John Campbell (IBM SVL)
Guide_DB2_France_DB2_for_zOS_V8_Migration_and_Experiences.pdf



Amicalement,

DB2usa.