Table Space Odyssey

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).

Aby pobrać prezentację należy się zalogować.