Table Space Odyssey

Download PDF

Session title: Table Space Odyssey

Session abstract: Db2 storage de-mystified. DMS, SMS, Automatic Storage table space internals. Default table space types across different Db2 editions and versions. Best practices. Container structure, naming conventions, internal architecture.Buffer pool considerations. Storage paths, auto-extend mechanisms, automatic striping. Parallelism vs. performance discussions. Common high watermark issues, reclaimable (object-relative) vs. nonreclaimable (pool-relative). Explanation on current deprecation statements, upgrade paths and considerations. Common tooling and tricks to deep dive into the storage components (db2dart, db2pd, and others).
Objectives Understand the current table space types Learn about the best usage practices Clarify the current deprecation statements Reveal the internal design of Db2 storage Get an insider view of advanced problem determination techniques.

Speaker biography: Always thrilled to work on hard-to-crack puzzles. Expertise in Db2 LUW kernel architecture, configuration and administration, advanced problem determination, memory architecture, memory leak troubleshooting, and assembly language. Hands-on development experience with buffer pool management, storage, prefetching, page cleaning, transaction logging, recovery, monitoring, and problem determination. As a member of the Db2 team, Pavel spent years in Db2 L2/L3 advanced support (over 1,500 resolved cases), then transitioned to Db2 LUW kernel development. In his past life Pavel was an application developer mostly using C++, SQL, .NET, Oracle, MS-SQL, and Informix on Windows, Linux, Solaris, and HP-UX.