White Paper: Pump up performance using improved metrics in DB2 for z/OS and LUW

Carl Nelson

White Paper: Pump up performance using improved metrics in DB2 for z/OS and LUW

IBM < http://ibm.com/vrm/images/can_oneoff/ibm_logo.gif >
<http://www.ibm.com/i/c.gif> < http://www.ibm.com/i/c.gif >
< http://www.ibm.com/i/c.gif >
< http://ibm.com/vrm/images/can_oneoff/blue_vert_line.gif >
<http://www.ibm.com/i/c.gif> < http://www.ibm.com/i/c.gif >
< http://www.ibm.com/i/c.gif > Best Practices for DB2 Database
Administration Best
practices for DB2
software<http://ibm.com/vrm/images/can_oneoff/best_practices_DB2.gif
> < http://www.ibm.com/i/c.gif >
White Paper < http://ibm.com/vrm/canc_dbae8_1/CNelson82772745 >
<http://www.ibm.com/i/c.gif> < http://www.ibm.com/i/c.gif >

If information is power, then DB2 V8 has been hitting the weight
room. Enhanced statistics and diagnostics facilities provide much
more information to help DBAs tune performance and quickly detect
and resolve system problems. And improvements to the RUNSTATS
utility allow you to provide more information to DB2 to help it find
the fastest access path for your workload.

Are you making the most of the enhanced statistical information
provided by DB2 V8? These complimentary white papers can help.


Need Information? DB2 V8 for z/OS Statistics and Diagnostics
< http://ibm.com/vrm/canc_dbae8_1/CNelson82772745 > , by DB2 expert
Susan Lawson, details how to best exploit the statistic and
diagnostic enhancements of DB2 V8 for z/OS, such as:
<http://www.ibm.com/i/c.gif> < http://www.ibm.com/i/c.gif >
< http://www.ibm.com/i/c.gif >
< http://ibm.com/vrm/images/can_oneoff/blue_bullet.gif >
Leveraging enhanced information from performance, accounting and
statistics traces to pinpoint problems, measure resource usage, and
plot historical trends
< http://ibm.com/vrm/images/can_oneoff/blue_bullet.gif >
Using new diagnostic information to proactively analyze SQL errors,
address connection issues and tune access paths used by dynamic SQL
statements
< http://ibm.com/vrm/images/can_oneoff/blue_bullet.gif >
Making optimum use of RUNSTATS to capture historical trend data and
supply the optimizer with timely access path information
< http://www.ibm.com/i/c.gif >
Lawson is a consultant for Yevich, Lawson & Associates with many
years of experience in designing and tuning large databases and
applications.

RUNSTATS in DB2 UDB V8.2 for LUW: Guidelines & Examples
< http://ibm.com/vrm/canc_dbae8_1/CNelson82772745 > , by DB2
specialist Larry Pay, reviews best practices (including 38 code
examples) that ensure optimal use of the RUNSTATS utility, such as:

<http://www.ibm.com/i/c.gif> < http://www.ibm.com/i/c.gif >
< http://www.ibm.com/i/c.gif >
< http://ibm.com/vrm/images/can_oneoff/blue_bullet.gif >
Understanding the best scenarios for performing RUNSTATS on tables
and indexes
< http://ibm.com/vrm/images/can_oneoff/blue_bullet.gif >
Using the REORGCHK command as an alternative method of collecting
statistics for all tables
< http://ibm.com/vrm/images/can_oneoff/blue_bullet.gif >
Performing RUNSTATS across partitioned databases
< http://ibm.com/vrm/images/can_oneoff/blue_bullet.gif >
Leveraging strategies to reduce impact of RUNSTATS on system
performance
< http://ibm.com/vrm/images/can_oneoff/blue_bullet.gif >
Using the autonomic statistics collection feature of V8.2
< http://www.ibm.com/i/c.gif >
Author Larry Pay is an IBM engagement specialist from the DB2 Data
Warehouse Consulting Group in Toronto. An IBM Certified Database
Administrator for DB2 UDB, he's been helping customers implement DB2
and Business Intelligence Solutions for more than five years.

This expert advice is part of the IBM software series of best
practices for DB2 database administration.

< http://www.ibm.com/i/c.gif >

< http://www.ibm.com/i/c.gif >
< http://ibm.com/vrm/images/can_oneoff/dba1_photo.jpg >
< http://www.ibm.com/i/c.gif >
<http://www.ibm.com/i/c.gif> < http://www.ibm.com/i/c.gif >
< http://ibm.com/vrm/images/can_oneoff/Mosaic.jpg >
< http://www.ibm.com/i/c.gif >
<http://www.ibm.com/i/c.gif> < http://www.ibm.com/i/c.gif >
<http://www.ibm.com/i/c.gif> < http://www.ibm.com/i/c.gif >
< http://ibm.com/vrm/images/can_oneoff/black_pixel.gif >
< http://www.ibm.com/i/c.gif >
If you'd like IBM to refrain from sending similar e-mails in the
future, please
click here < http://ibm.com/vrm/canc_dbae8_2/CNelson82772745 > .
< http://www.ibm.com/i/c.gif >
IBM Corporation, Software Group, 100 North Sepulveda Boulevard, El
Segundo, California 90245 U.S.A.
< http://www.ibm.com/i/c.gif >
(c) International Business Machines Corporation, 2005. DB2, IBM, the
IBM logo and z/OS are trademarks of International Business Machines
Corporation in the United States, other countries or both. Other
company, product and services names may be trademarks or service
marks of others. All rights reserved.

< http://www.ibm.com/i/c.gif >
<http://www.ibm.com/i/c.gif> < http://www.ibm.com/i/c.gif >


CONFIDENTIALITY NOTICE: This e-mail message, including any attachments,
is for the sole use of the intended recipient(s) and may contain confidential
and privileged information or otherwise protected by law. Any unauthorized
review, use, disclosure or distribution is prohibited. If you are not the
intended recipient, please contact the sender by reply e-mail and destroy
all copies of the original message.

---------------------------------------------------------------------------------
Welcome to the DB2 User Group - Indiana list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/DB2-UG-Indiana.html. From that page select "Join or Leave the list". The IDUG Listserv FAQ is at http://www.idugdb2-l.org. The DB2 User Group - Indiana List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm