April 23 SIRDUG Meeting Featuring Susan Lawson
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.
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)"
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.
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 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.
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.