Creating tables and tablespaces
- Review concepts of SMS and DMS tablespaces
- show table options like identity columns and generated columns
- introduction to data row compression
- basic design using data range partitioning
Advanced SQL techniques
- how to use different outer join techniques
- using OLAP functions
- review Nested and common table expressions
- using recursion with common table expressions
SQL performance
- Hints and tips for effectively using SQL
Data Access and EXPLAIN
- Review of Data access techniques
- How to use various explain tools and interpret results
The DB2 Optimizer
- Review of strategy to improve optimization strategy
- Design of indexes for optimum performance
Event and snapshot Monitors
- How to use event monitors
- options for creating and using event monitors
DB2 Operational Model
- Review the architectural concepts for DB2
- look at the behavior of DB2, with respect to I/O operations
- identify important cache and monitoring elements
DB2 Configuration Parameters
- review important configuration parameters for the a database and the database manager
- Introduce auto configuration
- identify the concepts of the Design Advisor
Multi Dimensional Clustering (MDC)
- the terminology of multi dimensional data.
- Know why and how to create a table that is clustered in multiple dimensions.
- Create generated columns to be used for dimension columns.
- Understand the concept of monotonicity associated with generated dimension columns.
Advanced table options
- Using table range partitions
- table row compression
- advanced options for REORG, RUNSTATS utilities
- Supporting identity columns in utilities
Configuring for self tuning of DB2
- automatic maintenance with utilities
- Self tuning memory
- database global memory
- automatic tuning
| 