DB2 Performance


DB2 for z/OS Features Contribute to High Availability by Lee Siegmund

DB2 for z/OS High Availabilty and Unplanned Outage Recovery by Lee Siegmund

A DB2 Health Check - Part 1 by Lockwood Lyon

A DB2 Health Check - Part 2 by Lockwood Lyon

DB2 Performance Expert for Multiplatforms V2.2

DB2's Three R's by Bonnie Baker


The Impact of the DB2 Installation Keyword CONTSTOR by Willie Favero

Using 64-Bit Virtual Storage and Large Real Storage to Improve Performance and Availability in DB2 for z/OS by Jeffrey Berger

WebSphere for z/OS Performance Tuning by K. Miller, A. Beaubien, M. Betancourt, A. Black, M. Casile, D. Draeger, T. Gissel, R. Iyer, K. McGuinnes, and D. Patel

Extreme Availability with IBM WebSphere and DB2 by David W. Coleman and Charles F. Bowman

DB2 for z/OS: DB2 Universal Database concurrency by Fred Whitlark

Performance Management of a Data Warehouse

DB2 for z/OS: DB2 Database Design: Principles of Peak Performance
by Fred Whitlark, IBM Corp.
Some general guidelines and recommendations for achieving better DB2 performance in z/OS® environments by making better design decisionsearly during the development process.

Java Stored Procedure Performance
IBM Corp.
By using Java stored procedures when you use DB2 view over and MQ queue, while using DB2 MQ Functions, you can improve performance.

Performance Basics Redux
by Casey Young
A review of the basics, including the health of DB2 objects and the access path of an SQL statement.

LOBs Performance with DB2 for z/OS Version 7
Recommendations from IBM on choosing the best options when inserting or loading relatively small LOBs.

Basic DB2 Buffering and Memory guidelines
by Craig S. Mullins
a high-level tip for memory tuning.

DB2 Parallel Operations and Query Performance
by Eric Garrigue Vesely
This covers situations that could benefit from using parallelism, why you should consider it, the best types of queries and more about improving performance.

Reporting Concurrent DDF Thread Usage
by Jeannette L. Vincent
The author shares several REXX EXECs and batch jobs to collect active DDF thread use and requestor information and store it in sequential files. Plus, tips on creating a graph to see the data.

DB2 Performance Traces

by Craig S. Mullins

Index Usage for Performance (pdf)
by Gabrielle Wiorkowski
This article covers topics such as how indexes are used, the use of multiple indexes, index cardinality, and more.

Optimizing Tablespace and Indexspace
by Bernard Zver
This article provides an REXX procedure, ATI, that helps you manage DB2 DASD, enabling you to generate a JCL stream that alters the space used by table and index spaces.

RUNSTATS and Reorganization (pdf)
by Gabrielle Wiorkowski
This presentation includes information on why and when to execute runstats, online REORG, deleting rows during a reorganization, and more.

When Less is More
by Robert Catterall
Want the skinny on database efficiency? Think lean and mean.

Improve DSN1COPY Performance
Save significant execution time by using the information here.

DB2 for OS/390 Performance on IBM Enterprise Storage Server (pdf)
These are detailed performance measurements to show how Enterprise Storage Server benefits DB2.

Saving CPU in your Multiple Counts SQL Statements
by Terry Purcell
Ideas plus code from Terry Purcell.

Capacity Planning and Sizing Strategy for Content Manager
for OS/390

by Michael Heyl
A a strategy for capacity planning and sizing for Content Manager for OS/390 V2.3.

Using Java with DB2 for z/OS and Designing
for High Performance
by John Campbell
An overview of JDBC including a comparison with SQLJ, a discussion about the tuning system environment, and design guidelines for applications.

Optimal DB2 Performance with SQLJ and JDBC
by Tom Syroid
A tutorial introducing SQLJ and JDBC, explaining how to take advantage of the features of SQLJ when accessing DB2 to achieve the best overall performance in your Java programs.

Designing for Speed
by John A. Lynch, Jr.

For good performance, designers and developers should incorporate an understanding of the importance of transaction and batch elapsed time, the amount of CPU required to sustain transaction and batch processes, and concurrency into all of their applications.

Arm Yourself Against Performance Erosion
by Casey Young
Finding the cause of a gradual DB2 performance slowdown can be difficult. Author Casey Young offers five areas you can work with to solve your performance problems.

Boosting Performance For Data Sharing
by Flavio C. Lima
Boosting performance for complex database environments is daunting, but possible. It takes knowing where to focus your efforts to conquer complex tuning challenges.

Evolution of Star Join Optimization in DB2 for OS/390 (pdf)
by Terry Purcell, et al
A discussion of the IBM DB2 for z/OS and OS/390 implementation of star schema support and and IBM's commitment to DSS and OLAP.

DB2 Performance Tuning Roadmap
by Craig S. Mullins
DB2 tuning issues, with tips in the context of a high-level roadmap for achieving optimal performance.

Optimizing for Top Performance?
by Michael S. Dougherty
How to get the best performance from the applications that use those methods.

DB2 Buffer Pool Tuning - A Methodology
by Mike Barnard
How do we tell if a buffer pool is well tuned? To really tune a buffer pool we need to get down to collecting and analyzing statistics at the pageset level. This article describes a method for doing just that.

To REBIND or not to REBIND
by Roger Miller
"To REBIND or not to REBIND" — that is not the question, since sooner or later, you'll have to REBIND. The reqal question is, WHEN.

CICS-DB2 Performance: Hints, Tips, and War Stories (pdf)
by Rob Catterall
Practical information intended to facilitate the performance tuning of CICS-DB2 transactions and the diagnosis and resolution of CICS-DB2 performance problems.

Page Turners
Robert Catterall
DB2 accounting reports offer the inside scoop on performance stories.

Improving DB2 for OS/390 Query Performance with DSTATS
by Steve Bower
Analysis of a statistical tool used to improve the performance of ad hoc queries running against unevenly-distributed data values, using DB2 for OS/390 Version 5 or later.

The Intelligent Optimizer - Everything you want to know about query processing
by Pat Selenger

The Intelligent Optimizer
by Pat Selinger
A discussion of two capabilities that make DB2 applications easier to write.

Managing DB2 Application Performance
by Martin Hubel
A performance management strategy for the DB2 environment can help ensure that response times will be as fast as possible.

Performance Implications of DSSIZE
by Craig S. Mullins
DB2 expert Craig Mullins addresses performance implications of using DSSIZE.

Interpreting DB2 accounting trace using COBOL
by Pranav Sampat
This article presents a small, easily customized utility program that would interpret the SMF 101 record (DB2 accounting record) and produce a report that could help analyse a performance problem or take proactive action.

Additional Considerations for IN List Performance
by Terry Purcell
On coding IN list values that restrict the search and other methods of improving IN list performance.

Ask the Expert: Limiting CPU Usage of DB2 Users
by Steve Samson
Performance and workload management expert Steve Samson recommends a multi-step approach to deal with this issue.

Ask the Expert
by Craig Mullins
DB2 expert Craig Mullins answers a question about how to do the analysis to initially divide one large bufferpool.

Star Join Optimization DB2 UDB for z/OS and OS/390
by Terry Purcell
This article to summarizes the current implementation of Star Schema support in DB2 UDB for z/OS and OS/390 V6 and V7, and provide an overview of the issues and complexity associated with this join methodology.

eDesign for ePerformance
by Maria Sarikos
This article looks at the different ways the new object relational features of DB2 can be used to enhance the performance of distributed and e-enabled applications. In particular we look at how moving application code back onto an active database management system can increase performance.

The Seedy Underworld of DB2 UDB for OS/390
by Chad Reiber
Influencing the Optimizer's access path.

Predicate Evaluation, Part 1
by Bonnie Baker
How to tell the benign Stage 2 predicates from the devastatingly evil ones in DB2 for OS/390.

Data Warehouse Query Optimization
by Pat Selinger
How some leading edge users are adopting a disciplined approach to database design and application development aimed at reducing total cost of ownership.

Designing VLDB's for Performance
by Steven Di Spigna and Autum Bonnabeau
How DBAs at UPS manage several multi-terabyte, highly complex databases using sometimes unorthodox or unconventional measures.

Predicate Evaluation, Part 3
by Bonnie Baker
A discussion about reasons to avoid or not complex predicates.

DB2 Performance Benchmarks
Benchmark results can be published at a quick pace and it is rare to see a hardware vendor delivering benchmark results from competing database software vendors on the exact same hardware configuration. This makes it difficult to show a true comparison between benchmark results. This article focuses on the value that can be demonstrated by the benchmarking effort.

Hinting and the DB2 Optimizer (registration required)
by Hemanta Ranjan Panda
Query optimization features have always been upgraded by incremental releases of DB2. DB2 UDB Version 6 has come up with a very effective technique by which users can give hints to the optimizer.

Zero Latency Enterprise Data Store Techniques for DB2 for OS/390 and z/OS
by Bryan Smith, John Campbell, and Akira Shibamiya
A “zero latency enterprise” is a solution in which there are no significant delays in getting information from one part of a business to another. This article discusses techniques and to describe how to exploit functions in DB2 in order to deliver a zero latency solution.

Dynamic Statements Cache: Getting the Most Out of It
by Namik Hrle
Caching of a dynamic SQL statement is a key ingredient of a well performing application that is based on dynamic SQL and satisfies the usage conditions.

A Report on DB2 UDB for OS/390 Catalog Migration Performance by Ching Lee, John Lyle, Mai Nguyen, and Akira Shibamiya
This team responded to a customer's problem by significantly reducing the time required for a catalog migration and providing a technique to estimate how long a given migration job would take as a function of the catalog size.



Roger Miller
DB2® for z/OS® Version 9


Craig Mullins' DB2 BLOG >>


Soccer Blog

(c) 2005, Double Loop Marketing LLC and Mullins Consulting, Inc.
All Right Reserved

DB2 is a registered trademark of IBM Corporation.