AppliedData34 min
Advanced DB2
Beyond SQL: how DB2 for z/OS chooses access paths and how to read EXPLAIN, indexing and statistics, the REORG, COPY, LOAD and RECOVER utilities, buffer pools, locking, data sharing and the traces you use to find where time goes.
What you will be able to do
- Read EXPLAIN output and relate access paths to indexes and statistics
- Explain what REORG, COPY, LOAD, RUNSTATS and RECOVER do and the states they leave
- Plan image copy and point-in-time recovery for related objects
- Diagnose lock timeouts, deadlocks and slow threads from codes and accounting data
Lessons
- Access paths, EXPLAIN, indexes and statisticsDB2's optimizer chooses how to run each SQL statement, using catalog statistics to estimate costs. EXPLAIN shows you that choice. Good indexes and current statistics are the main…
- Utilities, backup and recoveryDB2 utilities keep data healthy and recoverable: REORG restores order, COPY takes image copies, LOAD brings data in and RECOVER rebuilds objects from copies and the log. Knowing…
- Buffer pools, locking, data sharing and troubleshootingDB2 performance depends on how well data is cached in buffer pools, how much programs block each other with locks, and, in a data sharing group, how members coordinate through…
Track your progress and earn a certificate.
Free account, 15 quiz questions for this subject.