- DB2 architecture
- Application program tuning
- Access Strategies
- EXPLAIN, PLAN_TABLEs, DSN_STATEMNT_TABLEs, and DSN_STATEMENT_CACHE_TABLEs
- Indexable, Stage 1, and Stage 2 predicates
- Catalog tables and filter factors
- Catalog table modification
- Join and subquery access strategies
- BIND parameter considerations
- Concurrency and locking
- Batch issues
- Security issues and strategies
- Sequential and list prefetch
- Visual Explain
- Attachment facility issues, RCT parameters, and thread reuse
- Data base design considerations
- Utility issues
- DB2 traces and Instrumentation Facility
- DB2 system parameters
- z/OS issues
Comments are closed.