P2090-714 IBM Information Management DB2 z-OS Performance Technical Mastery Test v1 Exam Overview
"Please visit at www.certsmaster.com or email us at [email protected]
Performance Tuning Guidelines
5%
Managing Performance
DB2 Access Paths
20%
Access Path Selection
Writing Effective Queries
EXPLAIN
10%
EXPLAIN Tables
Dynamic SQL
20%
Dynamic Statement Caching
Prepares
Optimization
DB2 Accounting and Statistics Reports and Other Tools
35%
Accounting Reports
Statistics Reports
RMF Reports
Buffer Pool Tuning
DB2 Traces
DSNZPARMs
5%
Setting DSNZPARMs to Optimize Performance
Online DB2 Performance Monitoring
5%
DB2 DISPLAY Commands"