DB2 Database Performance Tuning
Course
In Gatwick
Description
-
Type
Course
-
Location
Gatwick
-
Duration
3 Days
Upon completion of this presentation, the participant should understand the following as they relate to the optimal performance of IBM DB2 UDB database for LUW: How to organise and implement performance, monitoring and tuning. How to optimally size the RDBMS. How to determine server requirements. How to optimise the disk subsystem. How to optimise physical database design. How to optimise the use of utilities. How to optimise SQL
Facilities
Location
Start date
Start date
About this course
Completion of our course Database Administration or
equivalent knowledge.
Reviews
Course programme
- How to organise and implement performance, monitoring and tuning
- How to optimally size the RDBMS
- How to determine server requirements
- How to optimise the disk subsystem
- How to optimise physical database design
- How to optimise the use of utilities
- How to optimise SQL
- How to optimise the use of multi-dimensional clustering (MDC) tables
DB2 Database Performance Tuning