Articles & Content

Archives

Future and Internals for DBA - Part I - D05

Topic: DB2 for LUW

Subtopic: 2012



DBAs often need to understand what's going on 'under the covers' in the relational database system, in order to fully appreciate how best to tune the database, and to have full confidence in their database installations. This presentation gives DBAs definitive knowledge about DB2 on Linux Unix and Windows' internal algorithms and how to control them. It covers key concepts like how tablespaces are designed, SMS vs DMS vs Automatic Storage internals, space management within tables, index management, memory management and STMM, logging and recovery, locking, parallelism, shared nothing and shared data clustering, and how threads and processes are used. In each of these areas, the presentation covers internal design fundamentals at a conceptual level, and then follows up with guidance on how to influence the described DB2 behavior via tuning knobs and controls. The material in this presentation will be up-to-date as of the latest versions of DB2 available on the conference date in May 2012.



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.