|
Provided by: Affinity IT Training, LLC DB2 -- Performance and Tuning |
 |
Training
Provided by Affinity IT Training, LLC
This course provides experienced SQL developers with a fast-paced transition to DB2 performance and tuning.
Following a review of the DB2 architecture, environment, and data structures,
course coverage includes index internals, block index MDC
'
s,
access methods, and how to write effective SQL predicates.
'
Explain
'
tables and tools are covered in detail as well as additional performance tools.
The optimizer is studied along with RUNSTATS to understand why index methods are chosen by the access plan.
Then MQT
'
s, database partitions and table partitions are explored and their relationships.
Finally, monitoring with admin views is covered along with some performance suggestions
Audience:SQL Developers with previous experience with DB2.
|
|
||||||||||
DB2 -- Performance and Tuning
Objectives
- Use and Understand performance components of DB2
- Understand internal and index structures
- Efficiently query with effective predicates
- Employ data optimization techniques
- Create and Use MQT's, MDC's and partitions
- Use monitoring tools
- Understand and Use explain tables and tools
Outline
DB2 Architecture
DB2 v9
Performance
DB2 Architecture
Agents
Agent Pools
Page Cleaners
DB2 Memory
Buffer pools
Tablespaces
A transaction
Federated Databases
High Availability
Routines
Query Processing
Query Tools
Structures
Databases
Containers
Tablespaces
SMS
DMS
Extents
Tablespace Map
I/O Servers
Tables
Pages
RID
Rows
Formatted Data Record Structure
Space Used
Indexes
Index Structure
B+ Tree
Creating Options
PCTFREE
MINPCTUSED
PAGE SPLITS
Information
SYCAT.INDEXES
XML pattern expression
XML regions index
XML column path index
Multi-Dimensional Clusters (MDC)
Describing MDC's
Block Indexes
Creating MDC's
Terminology
Choosing Dimensions
Query Optimization
RID and BID
Access Methods
Table Scan
Index Seek
Index Scan
Index Point Query
Index Range Query
Index Only Query
Access Speed
Join Strategy
Nested Loop
Merge Join
Hash Join
SQL Predicates
Typology
Range delimiting predicates
Index SARGable predicates
Data SARGable predicates
Residual predicates
Processing
Filter Factor
COLCARD
Selectivity
Implied Predicates
Explain Tables & Tools
Query Optimization
Explain Tables
Setup
- Access to DB2 Version 9 Server
- Accounts and permissions for students and Instructor
Seminar Pre-Requisites
- Application development experience with DB2
- DB2 - Fast Track to Programming
Training Materials
- Course Workbook
1.0
About The Training Provider: Affinity IT Training, LLC
Affinity IT Training, LLC - .
We are a provider of hands-on, instructor-led IT training for the global business community including website development, databases, programming languages and more. Training includes: ASP, .NET, C#, C , DB2, AJAX, JavaScript, HTML/XHTML/XML, Unix, Linux, Perl, Python, Ruby On Rails, Oracle, Sybase, SQL Server, Project Management Training and customized Integrated Case Study.
