April 23 SIRDUG Meeting Featuring Susan Lawson



Meeting Details

WHEN? April 23 (Friday)

WHERE?
IBM Harris Blvd facility (Charlotte, NC) - See directions below

COST? $195 cash or check, per day, at the door.
We do not accept credit cards.

All students get a V7 catalog poster and we will draw for some DB2 Family V7 Reference Guides and V7 DBA Certification Guides.


Meeting Agenda

April 23
Featured Speaker - Susan Lawson

 8:00 -  9:00  -  Registration - Coffee, Danish, and Networking
 9:00 - 10:10  -  "DB2 High Performance Design and Tuning (continued)"
10:10 - 10:30  -  Break 
10:30 - 12:00  -  "DB2 High Performance Design and Tuning (continued)"
12:00 -  1:00  -  Lunch
 1:00 -  4:00  -  "DB2 High Performance Design and Tuning (conclusion)"

Registration

To pre-register please email registration@sirdug.org and give us your name and company. If you are not already on our distribution list and wish to be, include your email address and phone number.

Pre-registration must be completed by Midnight, Friday, April 16th. Please feel free to invite others from your company (just make sure they pre-register as well). If you know others in your company who are interested in attending future SIRDUG events, please encourage them to become members of our distribution list (we just need their names, email addresses and phone numbers).

Registration Note
SIRDUG will be calling or emailing a confirmation for each person who pre-registers by the deadline. If you have pre-registered and have not received a confirmation by the day after the deadline, please notify us as your registration may not have been received.

If you have not pre-registered by the deadline, you may pre-register after the deadline or register at the door, but the availability of presentation handouts and lunch can not be guaranteed and confirmations will not be sent.


Directions to the meeting site:

The meeting is in the IBM Harris Blvd facility (8501 IBM Drive, Bldg 301)

For a map to the location click here

North bound on I-77 (from the Rock Hill direction): Turn right onto I-85 North and follow next directions.

On I-85 (coming from either direction): Take exit 45B onto Harris Blvd. West Turn Left at 2nd stop light onto IBM Drive and follow directions below.

South bound on I-77 (from the Statesville direction) Turn left onto Harris Blvd. East (exit 18)
Go approximately 6.3 miles to the 10th stop light (counting the one at top of I-77 ramp)
Turn Right onto IBM Drive (Don't turn onto the IBM Drive at the 7th stop light).

Once on IBM Drive, Turn Right at 2nd drive. Go through gate (tell them that you are here for a SIRDUG meeting). Look for the SIRDUG parking sign on the right side of the road. We are to park in the lower visitor parking lot. Enter the Visitors Lobby and follow the SIRDUG signs to the Cafeteria Conference Room.



Susan Lawson Biography

Susan Lawson is an internationally recognized consultant and lecturer with a strong background in system and database administration, and is a principal with YL&A. In the past, she has been an IBM Data Sharing advocate where she supported a variety of large DB2 customers. She provided technical expertise for migration to DB2 Data Sharing in a Parallel Sysplex environment, as well as troubleshooting performance problems during post-implementation. She currently works with several clients to help develop, implement and tune some of the world's largest and most complex DB2 databases. Her other activities have included authoring articles, presenting at user group meetings (where she has won best speaker awards), and providing technical editing for trade journals. She is an IBM GOLD Consultant for DB2 and S/390, and is an IBM Certified DBA and Application Developer for DB2 UDB Version 7 for OS/390. She is one of the authors of "DB2 Answers!" published by Osborne/McGraw-Hill, "DB2 High Performance Design and Tuning" published by Prentice-Hall, "DB2 UDB for OS/390 Version 7 DBA Certification Guide" published by Prentice-Hall, “DB2 UDB for OS/390 Version 7 Application Development Certification Guide” and “DB2 UDB V7 Family Reference Guide” published by YL&A.


"DB2 High Performance Design and Tuning"

Platform: DB2 for OS/390 and z/OS

Audience: DBA's, System Programmers, Application Programmers

Achieving maximum performance from DB2 requires a different approach and stricter methodologies than simply getting a DB2 application to perform well. In todayÂ’s web and e-business environment the rules have changed and we must find every tuning knob in order to get another transaction through the system. This seminar focuses on specific issues of system design, physical object design, application design and tuning methods used to achieve high performance. Topics such as table and index design, large tables and NPI's, DPSIs, pushing logic into SQL, control and concurrency, enterprise wide performance topics are examined for OLTP, batch, and data warehousing. Topics such as buffer pool design and utilization, concurrency and locking, DB2 compression, EDM pool sizing, RID pool sizing, SORT work tuning, and parallelism are examined, and it is shown how poor memory tuning directly effects application performance. The performance techniques of the some of the new object-relational SQL features are also covered. Focus is on the complete set of design points of DB2, and how they will affect performance of your applications. Discover why many old guidelines no longer apply, how old standards can actually hurt us and learn the approaches to systems management and tuning for the DB2 environment. This course gives new ideas on achieving the new demands placed on us in today high volume/high availability environments. The rules have changed.

The case study examples and stories told are from actual performance audits and design/development efforts.

All topics and examples are current with DB2 z/OS Version 8.

System Overview
    Some Internals For Discussion
    Discussion of All Performance Opportunities

Physical Database Design Issues
    Table Design
    Non-attribute Columns
    Code Tables And Reference Tables
    Denormalization
    Column Placement
    Large Tables and Their Indexes
    Partitioning for size and performance
    Index Design
    Clustering versus non-clustering indexes
    Partitioning index design
    Referential integrity and index design
    NPIs and Pieces
    DPSIs
    Compression
    Designing for 24x7
    Large table case study

Concurrency
    Locking Issues
    Coding for Minimal Locking Overhead
    Impacts of Row Level Locking
    Lock avoidance
    Lock monitoring – proactive vs reactive

Bufferpools
    Buffer Manager Overview
    Impacts on Application performance
    Buffer Pool Parameters
    Bufferpool Management and Hiperpools
    Bufferpool Use, Thresholds, and Performance
    Sequential prefetch impact
    List prefetch impact
    Checkpoint impacts
    Virtual Pool Design Strategies

RID Pool
    RID Pool Usage
    List prefetch impact
    Correct sizing
    Performance problems
    Application impacts
    Statistics detail

Sort Pool
    SORT Pool Usage
    Relationship to DSNDB07
    Correct Sizing
    Performance problems
    Statistics detail
    Application performance detail

EDM Pool
    Correct sizing
    Impacts of new features
    Monitoring its efficiency
    EDM pool and I/O activity
    Dynamic SQL caching
    Impact of data spaces

Application Design Issues
    Load Reduction By Application Transaction Re-design
    Uncommitted Read
    CURRENTDATA(NO)
    RELEASE(DEALLOCATE)
    DEGREE(ANY)
    Plan/Package Ratio

Parallelism
    Query CPU Parallelism
    How the Degree is determined
    Buffer Pool Impacts on Parallelism
    Basic Trace Records For Parallelism
    IFCID 221 &222

SQL Performance Issues
    Code for Reduced CPU
    Pushing Logic into the SQL
    Binding and reoptimization issues
    Filtering data for best performance

OLTP
    OLTP: SQL Transaction Cost
    Sequential Numbering Issues

Batch
    Reducing CPU and I/O
    Checkpoint/Restart
    Commits and Savepoints
    Hueristic control tables
    Browsing Performance
    Scrollable Cursors
    Mass updates, deletes and inserts

Final Guidelines
    Use of Defaults
    Rules Of Thumb: Physical Issues
    Rules Of Thumb: Application Design.



If you have any links that you would like to see on our pages, send SIRDUG an EMAIL using our mail box below.


 


SIRDUG Home Page

Last Update: March 15, 2004

Copyright © 2004 SIRDUG Inc. All rights reserved.