March 27th - DB2 z/OS Performance Review Class - David Beulke

Lori A Galluzzo

March 27th - DB2 z/OS Performance Review Class - David Beulke
Hi everyone! As promised, we have lined up David Beulke to teach a DB2
z/OS Performance Review Class on March 27th for the Central PA Users
Group. You can locate the class details via the RUG Calendar Of Events:

The cost of this 1-day class is $399 till March 16th & $499 after March
16th. You can signup using the link below :
. This link is only good until March 16th.

Here is the abstract :

How to do a DB2 zOS Performance Review Class- By David Beulke

This class will discuss the research, process and impact of doing a
performance review of your DB2 environments, systems, and applications.
An overall system, architectural, database and performance tuning review
can dramatically reduce costs and improve system and application
performance, availability and scalability. By analyzing many processing
performance conditions and detailing various recommendations you can
quickly improve database application performance, throughput and
response time.

This class will detail activities to evaluate production DB2 z/OS
environments. This class will detail problem areas and the improvements
that can be made in system configurations, database designs and batch,
online and Websphere applications. These techniques at many consulting
clients have dramatically reduced daily CPU consumption and saved
clients millions of dollars in CPU costs.

Instructor Biography
David Beulke is an internationally recognized DB2 consultant, author and
lecturer. He is known for his extensive expertise in database
performance, data warehouse designs and internet java applications. He
is currently a member of the IBM DB2 Gold Consultant program, co-author
of the IBM V8 and V7 z/OS DB2 Certification exams, co-author of the
Business Intelligence Certification exam, past president of the
International DB2 Users Group (IDUG), columnist for DB2 Magazine, and
former instructor for The Data Warehouse Institute (TDWI). Dave has 20+
years of experience tuning mainframe and UNIX systems, restructuring
database designs, improving applications and providing more efficient
SQL to solve business problems. He specializes in performance reviews
and tuning of large complex operational and data warehousing systems
saving his clients millions of dollars in CPU charges, hardware upgrades
and software licensing costs. He can be reached at [login to unmask email] for
any help, questions or comments.

Chapter 1: Performance Overview
Platform Properties
Architecture Attributes
System Settings
Database Details
Application Considerations

Chapter 2: DB2 z/OS Overview
DB2 z/OS Components
DB2 z/OS Architecture
DB2 z/OS Address Spaces
DB2 System Parameters
Operational Flow

Chapter 3: System Research Techniques
Basic Processing
Performance Attributes
Files and databases
CPU, Memory and I/O
Statistics Gathering

Chapter 4: Tablespace Design Review
Tablespace Page Consideration
Tablespace Definition Types
Partitioning Alternatives Designs Alternatives

Chapter 5: Index Performance Factors
Index performance Factors
Types of Index Keys
Index Key considerations
Keys for Partitioning

Chapter 6: Application Performance Keys
Connection Types & Processes
Application Characteristics
Error Checking
Application Top Ten Analysis

Chapter 7: SQL Performance
SQL Access Choices
Access Path Considerations
Explain Extended

Chapter 8: Application and SQL Research Methodology
Application Characteristics
Application Consideration
SQL Processing & Indexes
SQL Explain



For those still interested in registering but have not yet responded,
please rsvp to [login to unmask email]

Lori Ann Galluzzo
IBM DB2 V8.1 Certified Specialist & Solutions Expert
EDS - Healthcare - Metavance Product ADU
( phone: +01-717-975-5482 (8-428)
+ mailto:[login to unmask email]
cell : 717-215-0587

Welcome to the DB2 User Group - Central Pennsylvania list. To unsubscribe, go to the archives and home page at From that page select "Join or Leave the list". The IDUG Listserv FAQ is at The DB2 User Group - Central PA List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at