Asked and Answered (Robert Catterall)

Hi DB2 user,

Here is a first set of Robert Catterall's Asked and Answered about DB2 for z/OS, published in 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



Regards,

DB2usa.

DB2mag: Winter 2006 issue

Hi DB2 user,

Winter 2006 issue of DB2mag is available online: http://www.db2mag.com/db_area/archives/2006/q4


- DB2 9 for z/OS Roars to Life by 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 by 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 by 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 by 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


Regards,

DB2usa.

Redbook Data Sharing in a Nutshell

Hi DB2 user,

IBM just published a new Redbook, "DB2 for z/OS: Data Sharing in a Nutshell, SG24-7322-00" :
http://www.redbooks.ibm.com/redpieces/abstracts/sg247322.html?Open


Abstract
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.

Table of Contents
Introduction
Data sharing architecture
The coupling facility
Implementing data sharing
Dynamic workload balancing
Operations
Advanced topics
Best practices



More information

"DB2 UDB for z/OS Data Sharing Planning and Administration, Version 8" manual is available under three formats on IBM website:

- Information Center

- HTML (Bookmanager)

- PDF


Regards,

DB2usa.

More presentations about DB2 Version 8 migration

Hi DB2 user,

Here are several presentations about DB2 Version 8 migration:

User Experience

- DB2 V8 User Experiences - How To Get To V8
by 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?
by Bob Perih, Citigroup
http://ew.share.org/proceedingmod/abstract.cfm?abstract_id=13943

- DB2 UDB for z/OS V8 Migration: An Ironman event
by 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
by Mark Ediger (Acxiom)
http://ew.share.org/proceedingmod/abstract.cfm?abstract_id=13245

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


IBM speakers

- 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
by Roger Miller (IBM SVL)
http://www-1.ibm.com/support/docview.wss?uid=swg27007841

- Lessons Learned with DB2 for z/OS V8
by 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
by Akira Shibamiya (IBM SVL)
http://www-1.ibm.com/support/docview.wss?&uid=swg27006177

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

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

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


Regards,

DB2usa.