DB2usa: Blog about DB2 for z/OS

Redbook Security Functions with DB2 10 for z/OS

2011-08-15T01:00:00.000+01:00

Hi User,

IBM just published a draft version of a new Redbook "Security Functions with DB2 10 for z/OS, SG24-7959-00":
http://www.redbooks.ibm.com/Redbooks.nsf/RedpieceAbstracts/sg247959.html?Open

Abstract
DB2 9 and 10 for z/OS have added functions in the areas of security, regulatory compliance, and audit capability which provide solutions for the most compelling requirements.
DB2 10 enhances the DB2 9 role-based security with additional administrative and other finer-grained authorities and privileges. This authority granularity helps separate administration and data access that provide only the minimum appropriate authority.
The authority profiles provide better separation of duties while limiting or eliminating blanket authority over all aspects of a table and its data. In addition, DB2 10 provides a set of criteria for auditing for the possible abuse and overlapping of authorities within a system.
In DB2 10, improvements to security and regulatory compliance focus on data retention and protecting sensitive data from privileged users and administrators. Improvements also help to separate security administration from database administration.
DB2 10 also lets administrators enable security on a particular column or particular row in the database complementing the privilege model.
This IBM® Redbooks® publication provides a detailed description of DB2 10 security functions from the implementation and usage point of view.
.
Table of Contents
Chapter 1. Regulations
Chapter 2. Introduction to security for DB2 for z/OS
Chapter 3. RACF and DB2
Chapter 4. Administrative authorities and security-related objects
Chapter 5. Roles and trusted context
Chapter 6. Data access control
Chapter 7. Cryptography
Chapter 8. End user authentication
Chapter 9. Audit policies
Chapter 10. Implementing data access control
Chapter 11. Remote client applications access
Chapter 12. Database monitoring and the audit application
Chapter 13. Auditing and IBM InfoSphere Guardium
Chapter 14. DB2 temporal support
Appendix A. Spiffy Computer company security setup

Regards,

DB2usa.

DB2mag Summer 2011

2011-08-08T01:00:00.001+01:00

Hi DB2 user,

Summer 2011 issue of DB2mag is available on line:

- DB2mag Summer 2011

- DB2mag Archives (since Spring 2009)
- DB2mag Archives (Winter 1996-Spring 2009)

Note: DB2mag became IBMDatabasemag and then IBM Data Management magazine.

- Solid-state drives: Changing the data world
Say hello to your new friend.
by Paul Pendle

- Go back in time
Get started with temporal data, a timely new DB2 feature
by Sasirekha Rameshkumar

- The rise of the developer DBA
Let the database take care of itself. The DBA of the future has more important things to do.
by Robert Catterall

- PLANs + COLLECTIONs + VERSIONs + PACKAGEs + DBRMs = Confusion
Revisiting program preparation on DB2.
by Bonnie Baker

Regards,

DB2usa.

z/Journal (June - July 2011 issue)

2011-07-04T01:00:00.000+01:00

Hi DB2 user,

Articles from June - July 2011 issue of z/Journal are available online: http://www.mainframezone.com/z-journal

Note: z/Journal moved to mainframezone.com .

- DB2 for z/OS Search and Scroll Techniques
by Dan Luksetich

- A First Look: DB2 10 DSNZPARM Changes
by Willie Favero

- Partitioning Pros and Cons
by Craig Mullins

Regards,

DB2usa.

Redbook DB2 10 for z/OS Performance Topics

2011-06-27T01:00:00.002+01:00

Hi User,

IBM just published a draft version of a new Redbook "DB2 10 for z/OS Performance Topics, SG24-7942-00":
http://www.redbooks.ibm.com/abstracts/sg247942.html?Open

Abstract

DB2 10 can reduce the total DB2 CPU demand from 5-20% when you take advantage of all the enhancements. Many CPU reductions are built in directly to DB2, requiring no application changes. Some enhancements are implemented through normal DB2 activities through rebinding, restructuring database definitions, improving applications, and utility processing. The CPU demand reduction features have the potential to provide significant total cost of ownership savings based on the application mix and transaction types.
Improvements in optimization reduce costs by processing SQL automatically with more efficient data access paths. Improvements through a range-list index scan access method, list prefetch for IN-list, more parallelism for select and index insert processing, better work file usage, better record identifier (RID) pool overflow management, improved sequential detection, faster log I/O, access path certainty evaluation for static SQL, and improved distributed data facility (DDF) transaction flow all provide more efficiency without changes to applications. These enhancements can reduce total CPU enterprise costs because of improved efficiency in the DB2 10 for z/OS.
DB2 10 includes numerous performance enhancements for Large Objects (LOBs) that save disk space for small LOBs and that provide dramatically better performance for LOB retrieval, inserts, load, and import/export using DB2 utilities. DB210 can also more effectively REORG partitions that contain LOBs.
This IBM Redbooks publication® provides an overview of the performance impact of DB2 10 for z/OS discussing the overall performance and possible impacts when moving from version to version. We include performance measurements that were made in the laboratory and provide some estimates.
Keep in mind that your results are likely to vary, as the conditions and work will differ.
In this book, we assume that you are somewhat familiar with DB2 10 for z/OS.
See DB2 10 for z/OS Technical Overview, SG24-7892-00, for an introduction to the new functions.

Table of Contents
Chapter 1. Introduction
Chapter 2. Subsystem
Chapter 3. Synergy with z platform
Chapter 4. Table space design options
Chapter 5. Sample workloads
Chapter 6. SQL
Chapter 7. Application enablement
Chapter 8. Distributed environment
Chapter 9. Utilities
Chapter 10. Security
Chapter 11. Installation and migration
Chapter 12. Monitoring and Extended Insight
Appendix A. Recent maintenance

Regards,

DB2usa.

DB2mag Spring 2011

2011-05-16T01:00:00.003+01:00

Hi DB2 user,

Spring 2011 issue of DB2mag is available on line:

- DB2mag Spring 2011

- DB2mag Archives (since Spring 2009)
- DB2mag Archives (Winter 1996-Spring 2009)

Note: DB2mag became IBMDatabasemag and then IBM Data Management magazine.

- Tuning SQL at the Senate
E pluribus unum
by Ives Brant

- Securing DB2 data
Grant privileges to a what, not a who.
by Robert Catterall

- New ORDER BY information, Part 2
The impact of using the RANDOM index option on ORDER BY sort avoidance.
by Bonnie Baker

Regards,

DB2usa.

z/Journal (April - May 2011 issue)

2011-05-09T01:00:00.001+01:00

Hi DB2 user,

Articles from April - May 2011 issue of z/Journal are available online: http://www.mainframezone.com/z-journal

Note: z/Journal moved to mainframezone.com .

- Save MIPS With Effective DB2 for z/OS Indexes
by Rick Weaver

- DB2 for z/OS and REBIND
by Jim Kurtz

- Empowering Technicians for the Changing World
by Troy Coleman

- Best Practices in DB2 Storage Management
by Craig Mullins

Regards,

DB2usa.

z/Journal (February - March 2011 issue)

2011-04-04T01:00:00.001+01:00

Hi DB2 user,

Articles from February - March 2011 issue of z/Journal are available online: http://www.mainframezone.com/z-journal

Note: z/Journal moved to mainframezone.com .

- The Forensics of DB2 Network Traffic
by Wendy Wong

- Top-10 Reasons to Move to DB2 10
by Michael Jones

- DB2 10 for z/OS: The Most Secure DB2 Yet
by Willie Favero

- Dynamic SQL vs. Static SQL
by Craig Mullins

Regards,

DB2usa.

DB2mag Winter 2010

2011-03-07T01:00:00.001+01:00

Hi DB2 user,

Spring 2011 issue of DB2mag is available on line:

- DB2mag Winter 2010

- DB2mag Archives (since Spring 2009)
- DB2mag Archives (Winter 1996-Spring 2009)

Note: DB2mag became IBMDatabasemag and then IBM Data Management magazine.

- The Database Revolution
Today they're indispensable. Sixty years ago they didn't even exist as an idea. How did we get here?
by Carl Olofson

- DB2 Indexes and Query Performance: Part 2
2No new indexes? No problem.
by Robert Catterall

- New ORDER BY Information
Avoiding sorts with data-partitioned secondary indexes.
by Bonnie Baker

Regards,

DB2usa.

z/Journal (October 2010 - January 2011 issues)

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

Hi DB2 user,

Articles from October 2010 - January 2011 issues of z/Journal are available online: http://www.mainframezone.com/z-journal

Note: z/Journal moved to mainframezone.com .

- How DB2 for z/OS Application Requirements Affect Database Design
by Lockwood Lyon

- The DB2 Catalog Gets a Makeover
by Willie Favero

- Skip-Level Migration
by Willie Favero

- Revolutionary Technology for Data Warehouse and BI Workloads
by Patric Becker and Cuneyt Goksu

- Consider Capping to Control Costs
by Craig Mullins

- Rebinding for Optimal DB2 Access Paths
by Craig Mullins

Regards,

DB2usa.

Redpaper Data Studio and DB2 for z/OS Stored Procedures

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

Hi DB2 User,

IBM just published a draft version of a new Redpaper, "Data Studio and DB2 for z/OS Stored Procedures, REDP-4717-00":
http://www.redbooks.ibm.com/Redbooks.nsf/RedpieceAbstracts/redp4717.html?Open

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

Table of Contents
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

More information

- Introducing SYSPROC.ADMIN_INFO_SQL
by Michael Schenker and Thomas Conrad

Regards,

DB2usa.

z/Journal (August - September 2010 issue)

2011-01-17T01:00:00.000+01:00

Hi DB2 user,

Articles from August - September 2010 issues of z/Journal are available online: http://www.mainframezone.com/z-journal

Note: z/Journal moved to mainframezone.com .

- How Database Design Affects DB2 for z/OS System Performance
by Lockwood Lyon

- Performance Management Essentials to IT Success
by Mano Mathai

- DB2 for z/OS Parallelism
by Willie Favero

- Performance Strategies for Batch Applications on z/OS
by Srinivas Potharaju and Arka Nandi

- More DBA Proverbs
by Craig Mullins

Regards,

DB2usa.

Redbook Extremely pureXML in DB2 10 for z/OS

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

Hi DB2 User,

IBM just published a draft version of a new Redbook, "Extremely pureXML in DB2 10 for z/OS, SG24-7915-00":
http://www.redbooks.ibm.com/Redbooks.nsf/RedpieceAbstracts/sg247915.html?Open

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

Table of Contents
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

Regards,

DB2usa.

Redbook DB2 10 for z/OS Technical Overview

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

Hi DB2 User,

IBM just published a draft version of a new Redbook, "DB2 10 for z/OS Technical Overview, SG24-7892-00":
http://www.redbooks.ibm.com/Redbooks.nsf/RedpieceAbstracts/sg247892.html?Open

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

Table of Contents
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

Regards,

DB2usa.

John Campbell's DB2 for z/OS presentations

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

Hi DB2 user,

Here are several John Campbell's DB2 for z/OS presentations available on IBM and Tridex websites:

- Optimising DB2 for z/OS System Performance Using DB2 Statistics Trace
by John Campbell

- DB2 for z/OS Optimizing Insert Performance Part 1
by John Campbell

- DB2 for z/OS Optimizing Insert Performance Part 2
by John Campbell

- DB2 10 for z/OS Technical Overview
by John Campbell

- DB2 10 for z/OS Performance Preview
by John Campbell

More information

- Best Practices for DB2 Software Maintenance
by John Campbell and Michael Dewert

- DB2 9 for z/OS: Migration and Experiences
by Maja Kovac

Regards,

DB2usa.

DB2mag Fall 2010

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

Hi DB2 user,

Fall 2010 issue of DB2mag is available on line:

- DB2mag Fall 2010

- DB2mag Archives (since Spring 2009)
- DB2mag Archives (Winter 1996-Spring 2009)

Note: DB2mag became IBMDatabasemag and then IBM Data Management magazine.

- Is There Anything zEnterprise Can't Do?
IBM zEnterprise runs your business—any system, any application.
by 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?
by Terrie Jacopi

- DB2 Indexes and Query Performance: Part 1
Weigh costs and benefits when considering additional indexes.
by Robert Catterall

- Does the Order of SQL Predicates Matter?
Rearranging WHERE clause predicates may be an exercise in futility.
by Bonnie Baker

Regards,

DB2usa.

Peter Vanroose's presentations about DB2 for z/OS

2010-09-06T01:00:00.002+01:00

Hi DB2 user,

Here are several Peter Vanroose's presentations about DB2 for z/OS available on Abis website:

- DB2 9 New Datatypes and SQL Functions: Blessing or Curse?
by Peter Vanroose

- Experiences with stored procedures, triggers and XML on DB2 version 8 for z/OS
by Peter Vanroose

- Common Table Expressions in DB2 for z/OS: More powerful than you imagine
by Peter Vanroose

More information

- XML support in DB2 V9
by Ludo Van den dries

Regards,

DB2usa.

DB2mag Spring and Summer 2010

2010-08-30T01:00:00.003+01:00

Hi DB2 user,

Spring and Summer 2010 issues of DB2mag are available on line:

- DB2mag Summer 2010
- DB2mag Spring 2010

- DB2mag Archives (since Spring 2009)
- DB2mag Archives (Winter 1996-Spring 2009)

Note: DB2mag became IBMDatabasemag and then IBM Data Management magazine.

- DB2 10 for z/OS
More details emerge about new features that can slash CPU costs.
by Dave Beulke

- When Data Wears Out Its Welcome
Are cold data records gumming up the performance of your servers?
by Robert Catterall

- Reducing Conversations with DB2 for z/OS: Part 2
More tried-and-true basics and a few new bells and whistles.
by Bonnie Baker

- Maintenance Makes Money
Five ways to cut database costs - just by paying attention.
by Sheryl Larsen

- Real-Life DB2 Superheroes
IBM puts DB2 powers on display at the IDUG conference.
by David Beulke

- You Want to Govern What?
A database guy discovers data governance.
by Robert Catterall

- Reducing Conversations with DB2 for z/OS: Part 3
Different ways of thinking about ordinary things.
by Bonnie Baker

Regards,

DB2usa.

Redbook DB2 9 for z/OS and Storage Management

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

Hi DB2 User,

IBM just published a draft version of a new Redbook, "DB2 9 for z/OS and Storage Management, SG24-7823-00":
http://www.redbooks.ibm.com/Redbooks.nsf/RedpieceAbstracts/sg247823.html?Open

Abstract
This IBM Redbooks publication will help you tailor and configure DFSMS constructs to be used in a DB2 9 for z/OS environment. In addition, it provides a broad understanding of new disk architectures and their impact in DB2 data set management for large installations.
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.

Table of Contents
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

Regards,

DB2usa.

z/Journal (June - July 2010 issue)

2010-07-19T01:00:00.003+01:00

Hi DB2 user,

Articles from June - July 2010 issues of z/Journal are available online: http://www.mainframezone.com/z-journal

Note: z/Journal moved to mainframezone.com .

- DB2 for z/OS SQL Performance Choices
by Dan Luksetich

- Reorganize DB2 on z/OS Objects to Save Time and Money
by Peter Plevka

- Top-10 Features of DB2 10 for z/OS: A Preview
by Willie Favero

- The 10 Database Commandments
by Craig Mullins

Regards,

DB2usa.

z/Journal (April - May 2010 issue)

2010-05-17T01:00:00.000+01:00

Hi DB2 user,

Articles from April - May 2010 issues of z/Journal are available online: http://www.mainframezone.com/z-journal

Note: z/Journal moved to mainframezone.com .

- DB2 for z/OS Buffer Pools: Diving Into the Deep End
by Bill Arledge and Lynn Gros

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

- The Magic of Keeping DB2 in Order
by Willie Favero

- Choices for Caching Data in the Enterprise
by Susan Lawson and Dan Luksetich

More information

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

- Storage Performance Management: Strategies for Solid State Drives
by Gilbert Houtekamer and Wim Oudshoorn

Regards,

DB2usa.

Presentations from Heart of America DB2 Users Group

2010-05-10T01:00:00.002+01:00

Hi DB2 user,

Here are several presentations from Heart of America DB2 Users Group, available on HOADB2UG website:

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

- Stabilizing Access Paths Across Rebind
by Terry Purcell

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

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

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

- SQL Queries on Speed
by Dan Anderson

- Application Buffering of DB2 Data
by Michael Todd

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

Regards,

DB2usa.

z/Journal (October 2009 - March 2010 issues)

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

Hi DB2 user,

Articles from October 2009 - March 2010 issues of z/Journal are available online: http://www.mainframezone.com/z-journal

Note: z/Journal moved to mainframezone.com .

- Collecting Histogram Statistics With RUNSTATS
by Craig Mullins

- 11 Rules of the Road for DBAs
by Craig Mullins

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

- SQL Performance Tuning for Application Developers
by Peter Plevka

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

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

Regards,

DB2usa.

More information about DB2 10 for z/OS

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

Hi DB2 user,

Here are several presentations and technical documents about DB2 10 for z/OS (formally known as DB2 X) available on several IBM websites:

- DB2 10 for z/OS: How can it help you? (70 pages with notes)
by Roger Miller

- Planning Your Migration to DB2 9 for z/OS (updated version with DB2 10 information)
by Roger Miller

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

More information

- 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)

Regards,

DB2usa.

Andy Ward's presentations about DB2 for z/OS

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

Hi DB2 user,

Here are several Andy Ward's presentations about DB2 for z/OS available on different websites:

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

- Lies, Damned Lies & Statistics
by Andy Ward

- Independence Day DB2 V8 Partitioning
by Andy Ward

Regards,

DB2usa.

DB2 for z/OS Library History

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

Hi DB2 user,

Here are several DB2 for z/OS manuals from Version 2.3 to Version 9, available on IBM Library Server Library website:

All manuals are available in HTML format and for downloading in BookManager format. PDF files are available starting with Version 5.

You can browse BookManager files with free IBM Sofcopy Reader tool available for Windows and Linux.

- IBM DATABASE 2 Version 2 Release 3 (March 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 (December 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 (November 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 (June 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 (June 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 (May 2001) in PDF format only

- DB2 UDB for OS/390 and z/OS Version 7 First Edition (March 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 Version 7 Last Edition (August 2008)

- DB2 UDB for z/OS Version 8 First Edition (March 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 (June 2009)

- DB2 Version 9.1 for z/OS First Edition (March 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 (October 2009)

Note : Licensed publications are not available for downloading on the Web.

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.

More information

- 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
by Troy Coleman

- BookManager Index Utility for Windows

Regards,

DB2usa.

DB2 10 for z/OS Presentations and Beta Program

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

Hi DB2 user,

Here are several articles and presentations about DB2 10 for z/OS (formally known as DB2 X) available on several websites:

- DB2 10 for z/OS technical preview (65 pages with notes)
by Roger Miller

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

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

- DB2 9 for z/OS and Beyond (pages 29-52 with notes)
by Roger Miller

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

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

More information

- IBM DB2 10 for z/OS launches beta program
Beta Program: March 12, 2010
General Availability (GA): not announced

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

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

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

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

Regards,

DB2usa.

DB2mag Winter 2009

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

Hi DB2 user,

Winter 2009 issue of DB2mag is available on line:

- DB2mag Winter 2009 (digital version: interactive PDF)
- DB2mag Fall 2009 (digital version: interactive PDF)
- DB2mag Summer 2009 (digital version: interactive PDF)

- DB2mag Archives (Winter 1996-Spring 2009)

Note: DB2mag became IBMDatabasemag and then IBM Data Management magazine.

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

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

Regards,

DB2usa.

Redbooks 2004-2010 and More

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

Hi DB2 user,

Here is a list of Redbooks and Redpapers about DB2 for z/OS published or updated between 2004 and 2010, available on IBM website:

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

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

Other subjects
- 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)

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

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

Regards,

DB2usa.

Distributed Processing with DB2 for z/OS

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

Hi DB2 user,

Here are several presentations and articles about Distributed Processing with DB2 for z/OS, available on different websites:

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

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

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

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

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

- Java application deployment considerations
by Connie Tsuia and Rahul Kitchlu

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

More information

- Redbook DB2 9 for z/OS: Distributed Functions

Regards,

DB2usa.

DB2 for z/OS Troubleshooting and Monitoring presentations

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

Hi DB2 user,

Here are several presentations about DB2 for z/OS Troubleshooting and Monitoring, available on IDUG website:

- DB2 Systems Programming Tools of the Trade
by Linda Hagedorn

- The Diagnosis Manual Secrets and Intrigue
by Linda Hagedorn

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

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

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

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

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

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

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

- Troubleshooting Tuning for Dynamic SQL
by Thomas Baumann

- Memory Management for Dynamic SQL
by Thomas Baumann

Regards,

DB2usa.

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

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

Hi DB2 User,

IBM just published a new Redbook, "DB2 9 for z/OS: Resource Serialization and Concurrency Control, SG24-4725-01":
http://www.redbooks.ibm.com/Redbooks.nsf/RedbookAbstracts/sg244725.html?Open

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

Table of Contents
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

More information

First edition of this Redbook was published in August 1996.

Regards,

DB2usa.

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

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

Hi DB2 User,

IBM just published a draft version of a new Redbook, "DB2 9 for z/OS: Using the Utilities Suite, SG24-6289-01":
http://www.redbooks.ibm.com/Redbooks.nsf/RedpieceAbstracts/sg246289.html?Open

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

Table of Contents
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

More information

First edition of this Redbook, published in August 2001 is still available:

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

Regards,

DB2usa.

DB2 for z/OS Year in Review 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.003+01:00

Hi DB2 User,

IBM just published a new Redpaper, "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

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

Table of Contents
- 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

Regards,

DB2usa.

DB2mag Fall 2009

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

Hi DB2 user,

Fall 2009 issue of DB2mag is available on line:

- DB2mag Fall 2009 (digital version: interactive PDF)
- DB2mag Summer 2009 (digital version: interactive PDF)

- DB2mag Archives (Winter 1996-Spring 2009)

Note: DB2mag became IBMDatabasemag and then IBM Data Management magazine.

- System z Rocks (Again)
Indexing, compression make your applications work faster.
by 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.
by 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.
by 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.
by Matthias Nicola

More information

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

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

Regards,

DB2usa.

Presentations from Guide Share France

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

Hi DB2 user,

Here are several presentations from Guide Share France, available on GSE France website:

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

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

- Access Path Stability for Dynamic Queries
by Thomas Baumann

- Recursive SQL from a Performance Perspective
by Thomas Baumann

Regards,

DB2usa.

Presentations from Baltimore/Washington DB2 Users Group

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

Hi DB2 user,

Here are several presentations from Baltimore/Washington DB2 Users Group, available on BWDB2UG website:

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

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

- DB2 Performance Primer
by Michael Murray

- Index Design in a Busy System
by Larry Kintisch and Tapio Lahdenmäki

- ATS DB2 Health Check
by John Iczkovits

- A List of DB2 Top Ten Lists
by Craig Mullins

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

More information

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

- Database Trends
by Craig Mullins

Regards,

DB2usa.

IBM 2009 Technotes (FAQ) about DB2 for z/OS

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

Hi DB2 user,

Here are several new Technotes (FAQ), available on IBM DB2 for z/OS website:

- 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

Regards,

DB2usa.

Roger Miller's presentations about DB2 9 for z/OS

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

Hi DB2 user,

Here are several Roger Miller's presentations about DB2 for z/OS available on IBM website:

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

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

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

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

More information

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

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

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

Regards,

DB2usa.

Susan Lawson and Dan Luksetich's presentations

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

Hi DB2 user,

Here are several DB2 z/OS presentations of Susan Lawson and Dan Luksetich, available on IDUG website:

- Quit Calling DB2 So Much!
by Susan Lawson and Dan Luksetich

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

- Desperate Table Designs
by Susan Lawson and Dan Luksetich

- Top 10 Ways to Waste CPU
by Susan Lawson and Dan Luksetich

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

- Effective Uses of DB2 Triggers
by Dan Luksetich

- Utilizing DB2 V8 Table Expressions
by Dan Luksetich

- DB2 Legacy Migrations: Experiences of The Industry
by Susan Lawson and Dan Luksetich

- DB2 Application Design for Performance
by Susan Lawson and Dan Luksetich

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

Regards,

DB2usa.

z/Journal (August - September 2009 issue)

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

Hi DB2 user,

Articles from August - September 2009 issue of z/Journal are available online: http://www.zjournal.com

- Avoiding Application Bottlenecks in a Dynamic Environment
by Lockwood Lyon and Lisa Westcott-Dryer

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

- DISPLAY Your Way Out of DB2 Problems
by Craig Mullins

More information

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

Regards,

DB2usa.

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

2009-10-12T01:00:00.003+01:00

Hi DB2 User,

IBM just published a draft version of a new Redpaper, "DB2 9 for z/OS: Buffer Pool Monitoring and Tuning, REDP-4604-00":
http://www.redbooks.ibm.com/redpieces/abstracts/redp4604.html

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

Table of Contents
- 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

More information

- Tuning DB2 at CGU Life
by Mike Barnard

- DB2 for z/OS Bufferpool Management
by Mike Bracey

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

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

Regards,

DB2usa.

IDUG Solutions Journal (Summer 2009)

2009-10-05T01:00:00.002+01:00

Hi DB2 user,

Summer 2009 issue of IDUG Solutions Journal is available on line:

Current issue contains following articles:

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

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

- An Overview of Mainframe Specialty Processors
by Craig Mullins

Regards,

DB2usa.

DB2 9 for z/OS Performance Features by Dave Beulke

2009-09-28T01:00:00.009+01:00

Hi DB2 user,

Dave Beulke published several posts about DB2 9 for z/OS performance features on his 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

More information

- 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

Regards,

DB2usa.

Robert Catterall's presentations

2009-09-07T01:00:00.001+01:00

Hi DB2 user,

Here are several DB2 z/OS presentations of Robert Catterall, available on IDUG website and other websites:

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

- What DB2 People Should Know About SOA
by Robert Catterall

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

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

- DB2 Stored Procedures - Trends and Technology
by Robert Catterall

More information

- DB2 Data Warehouse Performance, Part 1
by Robert Catterall

- DB2 Data Warehouse Performance, Part 2
by Robert Catterall

- Robert's Blog
by Robert Catterall

Regards,

DB2usa.

CDUG 2009 Tech Forum's presentations (Shanghai, China)

2009-08-31T01:00:00.003+01:00

Hi DB2 user,

Here are several presentations, from CDUG 2009 Tech Forum (Shanghai, China) available on DB2 China website:

- Partitioned Table Space Usage Experience Sharing
by Huang Hao

- DB2 Memory Management
by Jim Teng

- INSERT Performance Update
by Jim Teng

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

More information

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

- RTS Operation and Maintenance : notes (Chinese)
by Wu Ding

Regards,

DB2usa.

Akira Shibamiya's presentations

2009-08-24T01:00:00.000+01:00

Hi DB2 user,

Here are several DB2 z/OS Performance presentations of Akira Shibamiya, available on IDUG website:

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

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

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

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

More information

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

Regards,

DB2usa.

z/Journal (June - July 2009 issue)

2009-08-17T01:00:00.001+01:00

Hi DB2 user,

Articles from June - July 2009 issue of z/Journal are available online: http://www.zjournal.com

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

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

- Are DBAs Really DBAs Today?
by Craig Mullins

More information

- Avoid Black Boxes to Improve Performance
by Craig Mullins

- Dynamic SQL On The Rise
by Craig Mullins

- An Overview of Mainframe Specialty Processors
by Craig Mullins

Regards,

DB2usa.

Articles from IBM Techdocs Library

2009-06-29T01:00:00.001+01:00

Hi DB2 user,

Here are several articles from IBM Techdocs Library, available on IBM Techdocs Website:

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

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

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

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

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

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

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

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

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

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

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

Regards,

DB2usa.

IBM DB2 Utililies presentations

2009-06-22T01:00:00.002+01:00

Hi DB2 user,

Here are several presentations about IBM DB2 Utililies, available on the web.

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

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

- DB2 Backup System and Restore System Enhancements
by Bryan Paulsen

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

More information

- What’s New in DB2 9 for z/OS for Backup and Recovery
by 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

Regards,

DB2usa.

Redbook DB2 9 for z/OS Distributed Architecture

2009-06-15T01:00:00.003+01:00

Hi DB2 User,

IBM just published a draft version of a new Redbook, "DB2 9 for z/OS: Distributed Architecture, SG24-6952-01":
http://www.redbooks.ibm.com/Redbooks.nsf/RedpieceAbstracts/sg246952.html?Open

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

Table of Contents
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

More information

First edition of this Redbook, published in June 2003 is still available:

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

Regards,

DB2usa.

Presentations from SQL Adria

2009-06-08T01:00:00.002+01:00

Hi DB2 user,

Here are several presentations from SQL Adria, available on SQL Adria website:

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

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

- Lock Out Your Locking Problems
by Peter Backlund

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

- Desperate Table Designs
by Susan Lawson

- Top 10 Ways to Waste CPU
by Susan Lawson

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

- Clone Table, Hot or not?
by Klaas Brant

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

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

Regards,

DB2usa.

DB2 for z/OS Version Polls (2009)

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

DB2 for z/OS Version
IBM currently supports two versions of DB2 for z/OS. On June 1st 2009,
which hightest version do you use in production?

DB2 for z/OS Version 8
Your production system is in DB2 for z/OS Version 8. Which Mode do you use
on June 1st 2009?

DB2 for z/OS Version 9
Your production system is in DB2 for z/OS Version 9. Which Mode do you use
on June 1st 2009?

Version 9 new functions
Feel free to rate a selection of new functions of DB2 for z/OS Version 9.

z/Journal (February - March and April - May 2009 issues)

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

Hi DB2 user,

Articles from February - March and April - May 2009 issues of z/Journal are available online: http://www.zjournal.com

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

- Not Sure Who You Are? Ask DB2
by Susan Lawson and Dan Luksetich

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

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

- DB2 System Configuration and Performance
by Craig Mullins

More information

- DBA Proverbs
by Craig Mullins

- Recovery Is a Compliance Issue
by Craig Mullins

Regards,

DB2usa.

Presentations from Midwest Database Users Group

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

Hi DB2 user,

Here are several presentations from Midwest Database Users Group, available on MWDUG website:

- Recursive SQL – Unleash the Power!
by Suresh Sane

- More Batch, Less Time
by Troy Coleman

- Performance Topics for DB2 Application Tuners
by Sheryl Larsen

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

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

Regards,

DB2usa.

Presentations from IBM DB2 for z/OS Performance Seminar (Japan)

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

Hi DB2 user,

Here are several presentations, from an IBM DB2 for z/OS Performance Seminar (Japan):

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

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

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

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

Regards,

DB2usa.

XML functionality in DB2 for z/OS

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

Hi DB2 user,

Here are several presentations and articles about XML in DB2 for z/OS, available on IBM websites:

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

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

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

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

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

- DB2 9 and z/OS XML System Services Synergy Update
by Judy Ruby-Brown and 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
by John Shelton and Hardeep Singh

More information

- DB2 for zOS pureXML Wiki
Technical articles, webcasts, podcasts, presentations, samples and Downloads

- DB2 pureXML Blog
by Qi Jin, Guogen Zhang, Matthias Nicola, and other members of the DB2 for z/OS Development team

- XML DevelopperWorks
Articles, online tutorials, and other technical resources on XML standards and technologies

Regards,

DB2usa.

DB2mag Winter 2008

2009-04-20T01:00:00.004+01:00

Hi DB2 user,

Winter 2008 issue of DB2mag is available online: http://ibmdatabasemag.com/db_area/archives/2009/1

Note: DB2mag became IBMDatabasemag.

- DB2 Data Warehouse Performance, Part 1 by 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 by David Beulke
Keep DB2 performance high by avoiding these common Java oversights.
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=216300333

- DB2 Answers by 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
by Rajesh Sambandhan, Simon Harris and 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
by Bryan Patterson and 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 by Conor O'Mahony
How to decide which XML storage option best suits a particular application.
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=216403288

Regards,

DB2usa.

Presentations from IBM DB2 9 for z/OS Migration Seminar (France)

2009-04-13T01:00:00.002+01:00

Hi DB2 user,

Here are several presentations, from IBM DB2 9 for z/OS Migration Seminar (France):

- DB2 for z/OS : Version 9 and Beyond (including 25 pages about DB2 X)
by Gareth Jones

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

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

Regards,

DB2usa.

DB2 for z/OS Year in Review 2008

2009-04-06T01:00:00.001+01:00

Hi DB2 user,

Here is the list of 2008 DB2usa Blog posts:

- Presentations from Heart of Texas DB2 Users Group
- IBM Technotes (FAQ) about DB2 for z/OS
- IDUG Solutions Journal (Winter 2007)
- z/Journal (December 2007 - January 2008 issue)
- More IBM Technotes (FAQ) about DB2 for z/OS
- Redbook DB2 9 for z/OS Stored Procedures: Through the CALL and Beyond
- Partitioning with DB2 for z/OS
- DB2mag Winter 2007
- Roger Miller presentations
- Presentations from Dutch DB2 User Group

- Redbooks 2004-2008 and More
- z/Journal (February - March 2008 issue)
- Presentations from Northeast Ohio Database Users Group
- DB2 Logging with DB2 for z/OS
- New IBM Technotes (FAQ) about DB2 for z/OS
- DB2mag Spring 2008
- Redpaper DB2 for z/OS: Considerations on Small and Large Packages
- z/Journal (April - May 2008 issue)
- IDUG Solutions Journal (Spring 2008)
- Redbook Enterprise Data Warehousing with DB2 9 for z/OS

- Redpaper DB2 9 for z/OS Data Sharing: Distributed Load Balancing
- z/Journal (June - July 2008 issue)
- DB2mag Sumer 2008
- Many more IBM Technotes (FAQ) about DB2 for z/OS
- DB2 for z/OS Year in Review 2007
- DB2 for z/OS Version Polls (2008)
- New IBM Technotes (FAQ) about DB2 for z/OS
- Redpaper DB2 9 for z/OS: Backup and Recovery I/O Related Performance
- IBM DB2 for z/OS Road Show (Spring 2008)
- DB2mag Fall 2008

- Redbook DB2 9 for z/OS: Deploying SOA Solutions
- IDUG Solutions Journal (Summer 2008)
- z/Journal (August - September 2008 issue)
- Presentations from Isaac Yassin

Regards,

DB2usa.

Presentations from Colorado DB2 Users Group

2009-03-30T09:37:00.002+01:00

Hi DB2 user,

Here are several presentations from Colorado DB2 Users Group, available on CDB2UG website:

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

- Optimizing System Performance Using DB2 Statistics Trace
by John Campbell

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

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

- I love packages and SQLJ
by Rob Crane

- Creating customized tools for DB2 for z/OS
by Matt Ramsey and Bob Vargo

Regards,

DB2usa.

Redbook 50 TB Data Warehouse Benchmark on IBM System z

2009-03-16T02:54:00.002+01:00

Hi DB2 User,

IBM just published a draft version of a new Redbook, "50 TB Data Warehouse Benchmark on IBM System z, SG24-7674-00" :
http://www.redbooks.ibm.com/Redbooks.nsf/RedpieceAbstracts/sg247674.html?Open

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

Table of Contents
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

Upcoming DB2 z/OS Redbook residencies

- 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

Information about residencies
http://publib-b.boulder.ibm.com/Redbooks.nsf/pages/how?Open

Regards,

DB2usa.

Presentations from New England DB2 Users Group

2009-03-09T01:29:00.003+01:00

Hi DB2 user,

Here are several presentations from New England DB2 Users Group, available on NEDB2UG website:

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

- Not Logged Table Spaces
by Jay Yothers

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

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

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

- DB2 9 for DBAs and Future Direction
by Roger Miller

Regards,

DB2usa.

DB2 articles from z/OS Hot Topics newsletter

2009-03-02T03:27:00.004+01:00

Hi DB2 user,

Here are some DB2 articles from z/OS Hot Topics newsletter:

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

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

- Safety first zCDP for DB2
by Glenn Wilcok and Laura Kunioka-Weis

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

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

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

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

- Database on demand
by Jim Porell

- DB2: Easier to use, easier to manage
by Bryan Smith, Jim Ruddy and Dave Schwartz

More information about z/OS features

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

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

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

- History of the mainframe poster

Regards,

DB2usa.

IDUG Solutions Journal (Winter 2008)

2009-02-09T10:31:00.005+01:00

Hi DB2 user,

Winter 2008 issue of IDUG Solutions Journal is available on line:

IDUG Solutions Journal Winter 2008 (PDF format)

Current issue contains following articles:

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

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

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

- Database Fundamentals
by Craig Mullins

Regards,

DB2usa.

Redbook DB2 9 for z/OS: Packages Revisited

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

Hi DB2 User,

IBM just published a draft version of a new Redbook, "DB2 9 for z/OS: Packages Revisited, SG24-7688-00" :
http://www.redbooks.ibm.com/Redbooks.nsf/RedpieceAbstracts/sg247688.html?Open

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

Table of Contents
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

Regards,

DB2usa.

Technotes (FAQ), Withdrawal Announcement and Upcoming Redbook residencies

2009-01-26T14:34:00.008+01:00

Hi DB2 user,

Here are several new Technotes (FAQ), available on IBM DB2 for z/OS website:

- 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?

Withdrawal Announcement 908-280 December 2, 2008

- DB2 for z/OS Version 8 to be withdrawn from marketing September 8, 2009
- IBM Software Support Lifecycle

Upcoming DB2 z/OS Redbook residencies

- 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

Information about residencies
http://publib-b.boulder.ibm.com/Redbooks.nsf/pages/how?Open

Regards,

DB2usa.

z/Journal (October - November 2008 issue)

2009-01-19T11:41:00.001+01:00

Hi DB2 user,

Articles from October - November 2008 issue of z/Journal are available online: http://www.zjournal.com

- The Magic of DB2’s Prefetch
by Willie Favero

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

- Reoptimizing SQL
by Craig Mullins

Regards,

DB2usa.

UK GSE Conference 2008 presentations

2009-01-12T01:23:00.004+01:00

Hi DB2 user,

Here are several presentations from UK GSE Conference 2008, available on UK DB2 User Group website:

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

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

- Memory Matters in 2009
by Martin Packer

- Lies, Damned Lies & Statistics
by Andy Ward

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

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

- A Row's Life
by Raymond Bell

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

- Introduction to DB2 on the Mainframe
by Gareth Jones

Regards,

DB2usa.

Presentations from Isaac Yassin

2008-12-22T09:44:00.003+01:00

Hi DB2 user,

Here are several presentations from Isaac Yassin about DB2 for z/OS:

- Where did I loose my memory?
by Isaac Yassin

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

- Existence Checking: Good vs Bad
by Isaac Yassin

Regards,

DB2usa.

z/Journal (August - September 2008 issue)

2008-11-24T01:57:00.001+01:00

Hi DB2 user,

Articles from August - September 2008 issue of z/Journal are available online: http://www.zjournal.com

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

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

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

- DB2 9 Data Format "Stuff"
by Craig Mullins

Regards,

DB2usa.

IDUG Solutions Journal (Summer 2008)

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

Hi DB2 user,

Summer 2008 issue of IDUG Solutions Journal is available on line:

IDUG Solutions Journal Summer 2008 (PDF format)

Current issue contains following articles:

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

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

- The Changing Priorities of Database Administration
by Lockwood Lyon

- Time to Plan for Migration Again
by Roger Miller

- Things You’ve Probably Neglected
by Craig Mullins

Regards,

DB2usa.

Redbook DB2 9 for z/OS: Deploying SOA Solutions

2008-11-10T16:56:00.001+01:00

Hi DB2 User,

IBM just published a draft version of a new Redbook, "DB2 9 for z/OS: Deploying SOA Solutions, SG24-7663-00" :
http://www.redbooks.ibm.com/Redbooks.nsf/RedpieceAbstracts/sg247663.html?Open

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

Table of Contents
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

Regards,

DB2usa.

DB2mag Fall 2008

2008-11-03T01:00:00.000+01:00

Hi DB2 user,

Fall 2008 issue of DB2mag is available online: http://ibmdatabasemag.com/db_area/archives/2008/4

Note: DB2mag became IBMDatabasemag.

- DB2 Programmers Do Exist by 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 by David Beulke
Guidelines for DB2 for z/OS applications.
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=211300322

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

Regards,

DB2usa.

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

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

Hi DB2 user,

Here are several presentations, from IBM DB2 for z/OS Road Show Spring 2008 (USA):

- 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

Regards,

DB2usa.

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

2008-10-20T14:23:00.000+01:00

Hi DB2 User,

IBM just published a new Redpaper, "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

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

Table of Contents
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.

More information about Disaster Recovering

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

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

Table of Contents
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.

New IBM Technotes (FAQ) about DB2 for z/OS

2008-10-06T17:16:00.003+01:00

Hi DB2 user,

Here are several new Technotes (FAQ), available on IBM DB2 for z/OS website:

- 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 ?

Regards,

DB2usa.

DB2 for z/OS Version Polls (2008)

2008-08-20T01:28:00.000+01:00

DB2 for z/OS Year in Review 2007

2008-08-18T20:43:00.004+01:00

Hi DB2 user,

Here is the list of 2007 DB2usa Blog posts:

- z/Journal (October - November 2006 issue)
- IBM DB2 for z/OS Technotes
- Asked and Answered (Robert Catterall) part 2
- Optimization with DB2 for z/OS Version 8
- IDUG Solution Journal (Winter 2006)
- DB2 for z/OS Versions
- Expert Answer Center (Craig Mullins)
- DB2 for z/OS Stored Procedures
- DB2 9 for z/OS will be GA on March, 16th 2007
- IBM presentations about DB2 9 for z/OS

- IDUG's Audio and Video Materials
- DB2 for z/OS Version 8 Polls
- z/Journal (February - March 2007 issue)
- Asked and Answered (Robert Catterall) part 3
- Security in DB2 for z/OS Versions 8 and 9
- SQL Presentations
- IDUG Solutions Journal (Spring 2007)
- DB2 Catalog Presentations
- DB2mag: Spring 2007 issue
- More SQL presentations with DB2 for z/OS Version 8

- Expert Answer Center (Craig Mullins) Part 2
- z/Journal (April - May 2007 issue)
- Redbook DB2 9 for z/OS Technical Overview
- Access Path Selection presentations
- Two new Redbooks about SAP and DB2 9 for z/OS
- DB2 for z/OS V8 Migration (podcasts)
- DB2 9 for z/OS by Craig Mullins
- DB2 9 for z/OS by Willie Favero
- DB2mag: Summer 2007 issue
- Redbook DB2 9 for z/OS Performance Topics

- z/Journal (June - July 2007 and August - September issues)
- DB2 articles from IBM Systems Magazine
- SQL presentations from Tampa Bay Relational Users Group
- IDUG Solutions Journal (Summer 2007)
- Redbook DB2 9 for z/OS: New Tools for Query Optimization
- DB2mag: Fall 2007 issue
- Presentations from DB2 for z/OS Technical Forum (China)
- Robert Catterall's Blog
- z/Journal (October - November 2007 issue)
- Troy Coleman's Blog
- Craig Mullins and Sheryl Larsen presentations
- Bryan Smith presentations
- Presentations from DB2 for z/OS Technical Forum (Taiwan)

Regards,

DB2usa.

Many more IBM Technotes (FAQ) about DB2 for z/OS

2008-08-11T13:39:00.003+01:00

Hi DB2 user,

Here are several new Technotes (FAQ), available on IBM DB2 for z/OS website:

- 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

Regards,

DB2usa.

DB2mag Sumer 2008

2008-08-04T01:42:00.000+01:00

Hi DB2 user,

Summer 2008 issue of DB2mag is available online: http://ibmdatabasemag.com/db_area/archives/2008/3

Note: DB2mag became IBMDatabasemag.

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

- Get On the Enterprise Service Bus by 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 by 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 by 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

Regards,

DB2usa.

z/Journal (June - July 2008 issue)

2008-07-28T01:00:00.000+01:00

Hi DB2 user,

Articles from June - July 2008 issue of z/Journal are available online: http://www.zjournal.com

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

- The Rise of Dynamic SQL
by Craig Mullins

Regards,

DB2usa.

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

2008-07-21T09:32:00.004+01:00

Hi DB2 User,

IBM just published a new Redpaper, "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

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

Table of Contents
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

More information about Data Sharing

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

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

Table of Contents
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

Regards,

DB2usa.

Redbook Enterprise Data Warehousing with DB2 9 for z/OS

2008-06-30T16:47:00.000+01:00

Hi DB2 User,

IBM just published a draft version of a new Redbook, "Enterprise Data Warehousing with DB2 9 for z/OS, SG24-7637-00 " :
http://www.redbooks.ibm.com/redpieces/abstracts/sg247637.html?Open

Abstract
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

Table of Contents
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

Regards,

DB2usa.

IDUG Solutions Journal (Spring 2008)

2008-06-16T18:06:00.000+01:00

Hi DB2 user,

Spring 2008 issue of IDUG Solutions Journal is available on line:

IDUG Solutions Journal Spring 2008 (PDF format)

Current issue contains following articles:

- DB2 9 Application-Related Enhancements
by Bill Arledge

- Enterprise Spatial Solution with DB2 9 for z/OS
by Frank Butt, Yu Dong and Gene Fuh

- Getting you out of a BIND
by Roger Miller

- On Recovery Service Levels
by Craig Mullins and Brenda Honeycutt

Regards,

DB2usa.

z/Journal (April - May 2008 issue)

2008-06-09T01:23:00.002+01:00

Hi DB2 user,

Articles from April - May 2008 issue of z/Journal are available online: http://www.zjournal.com

- Exploiting DB2 Version 8 and DB2 9 SQL Features for SQL Call Reduction
by Susan Lawson and Daniel Luksetich

- Database Administration Best Pratices
by Lockwood Lyon

- Use Real Time Statistics to automate your Database Maintenance
by Craig Mullins

- JDBC, JDBC Drivers and DB2 9.1
by Allen Jaques

Regards,

DB2usa.

Redpaper DB2 for z/OS: Considerations on Small and Large Packages

2008-06-02T01:12:00.009+01:00

Hi DB2 User,

IBM just published a draft version of a new Redpaper, "DB2 for z/OS: Considerations on Small and Large Packages, REDP-4424-00":
http://www.redbooks.ibm.com/Redbooks.nsf/RedpieceAbstracts/redp4424.html?Open

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

More information

- 1993 Redbook DB2 Packages: Implementation and Use, GG24-4001-00

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

- Upcoming Redbook Residency, DB2 9 for z/OS: Packages Revisited, SD-8Z06

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

Information about Residencies
http://publib-b.boulder.ibm.com/Redbooks.nsf/pages/how?Open

Regards,

DB2usa.

DB2mag Spring 2008

2008-05-26T09:29:00.002+01:00

Hi DB2 user,

Spring 2008 issue of DB2mag is available online: http://ibmdatabasemag.com/db_area/archives/2008/2

Note: DB2mag became IBMDatabasemag.

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

- Can SOA Perform? by 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 by 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 by Bonnie Baker
The truth behind this enigmatic lock and other DB2 for z/OS stumpers.
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=207801138

Regards,

DB2usa.

New IBM Technotes (FAQ) about DB2 for z/OS

2008-05-12T01:03:00.002+01:00

Hi DB2 user,

Here are several new Technotes (FAQ), available on IBM DB2 for z/OS website:

- 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?

Regards,

DB2usa.

DB2 Logging with DB2 for z/OS

2008-04-21T17:33:00.008+01:00

Hi DB2 user,

Here are several presentations about logging with DB2 for z/OS, available on IBM and RUGs websites:

- Harnessing the Power of DB2 Logs
by Gregory Parrish

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

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

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

- DB2 Log Extract Tool for audit
by Michael Arlebrandt

More information

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

- Redbook Disaster Recovery with DB2 UDB for z/OS

Regards,

DB2usa.

Presentations from Northeast Ohio Database Users Group

2008-04-14T08:56:00.003+01:00

Hi DB2 user,

Here are several presentations, available on Northeast Ohio Database Users Group website:

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

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

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

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

- Managing Distributed, Dynamic Workloads on DB2
by Progressive

- Progressive’s DB2 Tools and Utilities
by Progressive

Regards,

DB2usa.

z/Journal (February - March 2008 issue)

2008-04-07T10:10:00.002+01:00

Hi DB2 user,

Articles from February - March 2008 issue of z/Journal are available online: http://www.zjournal.com

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

- Much Ado About DB2 9 Locking
by Craig Mullins

More information

Here is a presentation about Universal table spaces and Reordered Row Format from Willie Favero:

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

Regards,

DB2usa.

Redbooks 2004-2008 and More

2008-03-31T09:44:00.002+01:00

Hi DB2 user,

Here is a list of Redbooks about DB2 for z/OS published or updated between 2004 and 2008, available on IBM website:

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

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

Other subjects
- 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 (not published yet), 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

Regards,

DB2usa.

Presentations from Dutch DB2 User Group

2008-03-17T08:58:00.000+01:00

Hi DB2 user,

Here are several presentations, available on Dutch DB2 User Group (DDUG) website:

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

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

- DB2 and WebSphere - Capita Selecta
by Kris Van Thillo

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

Regards,

DB2usa.

Roger Miller presentations

2008-03-10T12:13:00.002+01:00

Hi DB2 user,

Here are several presentations from Roger Miller about DB2 for z/OS available on IBM website:

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

- zIIP, zAAP, and DB2
by Roger Miller

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

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

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

More information

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

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

Regards,

DB2usa.

DB2mag Winter 2007

2008-03-03T13:19:00.005+01:00

Hi DB2 user,

Winter 2007 issue of DB2mag is available online: http://ibmdatabasemag.com/db_area/archives/2008/1

DB2mag became IBMDatabasemag as explained in the following article:

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

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

- Elevating the DBA Role by 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

More information

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

Regards,

DB2usa.

Partitioning with DB2 for z/OS

2008-02-25T13:34:00.001+01:00

Hi DB2 user,

Here are two presentations about partitioning with DB2 for z/OS Version 8, available on Guide Share France website:

- Partitioning Scary Stories
by Phil Grainger

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

More information

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

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

- DB2 Managing Large Partitioned Tables in V8
by Craig Friske

- Major Index Changes in DB2 Version 8
by Jim Teng

Regards,

DB2usa.

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

2008-02-18T19:36:00.000+01:00

Hi DB2 User,

IBM just published a draft version of a new Redbook, "DB2 9 for z/OS Stored Procedures: Through the CALL and Beyond, SG24-7604-00 " :
http://www.redbooks.ibm.com/redpieces/abstracts/sg247604.html

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

Table of Contents
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

Regards,

DB2usa.

More IBM Technotes (FAQ) about DB2 for z/OS

2008-02-11T18:00:00.000+01:00

Hi DB2 user,

Here are more Technotes (FAQ), available on IBM DB2 for z/OS website:

- 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?

Regards,

DB2usa.

DB2usa: Blog about DB2 for z/OS

Redbook Security Functions with DB2 10 for z/OS

DB2mag Summer 2011

z/Journal (June - July 2011 issue)

Redbook DB2 10 for z/OS Performance Topics

DB2mag Spring 2011

z/Journal (April - May 2011 issue)

z/Journal (February - March 2011 issue)

DB2mag Winter 2010

z/Journal (October 2010 - January 2011 issues)

Redpaper Data Studio and DB2 for z/OS Stored Procedures

z/Journal (August - September 2010 issue)

Redbook Extremely pureXML in DB2 10 for z/OS

Redbook DB2 10 for z/OS Technical Overview

John Campbell's DB2 for z/OS presentations

DB2mag Fall 2010

Peter Vanroose's presentations about DB2 for z/OS

DB2mag Spring and Summer 2010

Redbook DB2 9 for z/OS and Storage Management

z/Journal (June - July 2010 issue)

z/Journal (April - May 2010 issue)

Presentations from Heart of America DB2 Users Group

z/Journal (October 2009 - March 2010 issues)

More information about DB2 10 for z/OS

Andy Ward's presentations about DB2 for z/OS

DB2 for z/OS Library History

DB2 10 for z/OS Presentations and Beta Program

DB2mag Winter 2009

Redbooks 2004-2010 and More

Distributed Processing with DB2 for z/OS

DB2 for z/OS Troubleshooting and Monitoring presentations

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

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

DB2 for z/OS Year in Review 2009

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

DB2mag Fall 2009

Presentations from Guide Share France

Presentations from Baltimore/Washington DB2 Users Group

IBM 2009 Technotes (FAQ) about DB2 for z/OS

Roger Miller's presentations about DB2 9 for z/OS

Susan Lawson and Dan Luksetich's presentations

z/Journal (August - September 2009 issue)

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

IDUG Solutions Journal (Summer 2009)

DB2 9 for z/OS Performance Features by Dave Beulke

Robert Catterall's presentations

CDUG 2009 Tech Forum's presentations (Shanghai, China)

Akira Shibamiya's presentations

z/Journal (June - July 2009 issue)

Articles from IBM Techdocs Library

IBM DB2 Utililies presentations

Redbook DB2 9 for z/OS Distributed Architecture

Presentations from SQL Adria

DB2 for z/OS Version Polls (2009)

z/Journal (February - March and April - May 2009 issues)

More presentations from UK DB2 User Group

Presentations from Midwest Database Users Group

Presentations from IBM DB2 for z/OS Performance Seminar (Japan)

XML functionality in DB2 for z/OS

DB2mag Winter 2008

Presentations from IBM DB2 9 for z/OS Migration Seminar (France)

DB2 for z/OS Year in Review 2008

Presentations from Colorado DB2 Users Group

Redbook 50 TB Data Warehouse Benchmark on IBM System z

Presentations from New England DB2 Users Group

DB2 articles from z/OS Hot Topics newsletter

IDUG Solutions Journal (Winter 2008)

Redbook DB2 9 for z/OS: Packages Revisited

Technotes (FAQ), Withdrawal Announcement and Upcoming Redbook residencies

z/Journal (October - November 2008 issue)

UK GSE Conference 2008 presentations

Presentations from Isaac Yassin

z/Journal (August - September 2008 issue)

IDUG Solutions Journal (Summer 2008)

Redbook DB2 9 for z/OS: Deploying SOA Solutions

DB2mag Fall 2008

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

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

New IBM Technotes (FAQ) about DB2 for z/OS

DB2 for z/OS Version Polls (2008)