|
Provided by: Affinity IT Training, LLC DB2 -- Performance and Tuning |
 |
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.
|
|
||||||||
Training
Provided by Affinity IT Training, LLC
- R asked: Looking for a classroom setting away from work (out-of-state, NH) for better concentration and focus. I want to learn more about interpreting the EXPLAIN results, and how RUNSTATS affects performance.
- A asked: I would like to know how much is this class? Also, if it can be split up over weekends as I am currently working and will be busy during weekdays. Thanks.
- S asked: Hi, How much does this course cost for an individual? When is the next time it is being offered and at what location?? Thanks..
- asked: Could you please give me details about, your training program covers these topics? . Setup and manage database connections to AS/ DB . Performance monitoring/ enhancement for database connections to AS . AS connection pooling Also tell me what is the duration, cost of the training and is there any other branch in chennai. Thanks, Gandhimathi. B
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
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
- Application development experience with DB2
- DB2 - Fast Track to Programming
- 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.
