View Printable Version

D10 - Table Space Odyssey

Session Number: 5105
Track: Db2 for LUW - II
Session Type: Podium Presentation
Primary Presenter: Pavel Sustr [IBM Toronto Lab]
Time: May 02, 2018 (09:20 AM - 10:20 AM)
Room: Commonwealth D

Session Code: D10
Speaker Bio: Senior Manager and Senior Software Engineer with IBM DB2 LUW development, responsible for multiple core DB2 kernel components. 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.

Audience experience level: Beginner, Intermediate, Advanced
Presentation Category: Data Management
Presentation Platform: Select a Value
Audiences this presentation will apply to: Database Administrators, Systems Programmers
Technical areas this presentation will apply to: User Experiences
Objective 1: Understand the current table space types
Objective 2: Learn about the best usage practices
Objective 3: Clarify the current deprecation statements
Objective 4: Reveal the internal design of DB2 storage
Objective 5: Get an insider view of advanced problem determination techniques

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. non-reclaimable (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).

For questions or concerns about your event registration, please contact