Chapter 14: Further Reading

IBM Official Documentation

z/OS

  • DB2 13 for z/OS: Administration Guide — Chapter on tablespace design, partitioning, and compression. IBM Knowledge Center.
  • Sections on Universal Table Spaces, DSSIZE, MAXPARTITIONS, SEGSIZE.

  • URL: https://www.ibm.com/docs/en/db2-for-zos/13

  • DB2 13 for z/OS: SQL Reference — CREATE TABLESPACE syntax, ALTER TABLESPACE, partition management.

  • Complete syntax diagrams for all tablespace-related DDL.

  • DB2 13 for z/OS: Utility Guide and Reference — REORG TABLESPACE, RUNSTATS, COPY, DSN1COMP.

  • Covers partition-level utility execution and compression dictionary management.

  • DB2 13 for z/OS: Performance Monitoring and Tuning Guide — Buffer pool tuning, I/O optimization, compression impact analysis.

LUW

  • Db2 11.5: Database Administration Concepts and Configuration Reference — Tablespace management, automatic storage, storage groups, page sizes.

  • URL: https://www.ibm.com/docs/en/db2/11.5

  • Db2 11.5: SQL Reference — CREATE TABLESPACE, ALTER TABLE ... PARTITION, COMPRESS YES ADAPTIVE, INLINE LENGTH.

  • Db2 11.5: Troubleshooting and Tuning Database Performance — Buffer pool configuration, prefetch tuning, I/O optimization.

  • Db2 11.5: Administrative Routines and Views — ADMIN_GET_TAB_COMPRESS_INFO, MON_GET_TABLESPACE, SNAP_GET_TBSP.

IBM Redbooks

  • DB2 for z/OS: Data Sharing and Partitioning Guide (SG24-6250)

  • Comprehensive coverage of partition-by-range and partition-by-growth strategies on z/OS. Includes migration guidance from classic partitioned to Universal Table Spaces.

  • DB2 11 for z/OS Technical Overview (SG24-8180)

  • Coverage of adaptive compression, temporal data, and Universal Table Space enhancements.

  • Db2 Best Practices: Physical Database Design (REDP-5446)

  • IBM best practice guidelines for tablespace design, page size selection, and compression on both platforms.

  • DB2 Compression Implementation and Best Practices (SG24-8471)

  • Deep dive into compression architecture, dictionary management, adaptive compression, and ROI analysis methodologies.

  • Optimizing DB2 Queries with IBM DB2 Analytics Accelerator (SG24-8056)

  • Relevant for understanding how physical design on z/OS interacts with accelerator offload for analytical workloads.

Books

  • DB2 Developer's Guide by Craig Mullins (6th edition). Pearson.

  • Chapter on physical database design covers tablespace types, page sizes, and storage planning. The industry-standard reference for DB2 practitioners.

  • DB2 for z/OS: Database Administration Certification Study Guide by Susan Lawson and Dan Luksetich. MC Press.

  • Covers physical design topics required for DB2 z/OS DBA certification. Practice questions aligned with IBM exam objectives.

  • DB2 SQL PL: Deployment and Advanced Configuration by Zamil Janmohamed et al. MC Press.

  • Covers physical design considerations for stored procedure and UDF deployment, including temp table strategies and LOB handling.

  • Database Design and Relational Theory by C.J. Date. O'Reilly Media.

  • Theoretical foundation for understanding why physical design decisions matter. Connects relational theory to practical implementation.

Research Papers and Technical Articles

  • Boncz, P., Zukowski, M., and Nes, N. "MonetDB/X100: Hyper-Pipelining Query Execution." CIDR 2005.

  • Background on columnar compression techniques that influenced DB2's adaptive compression design.

  • Abadi, D., Madden, S., and Ferreira, M. "Integrating Compression and Execution in Column-Oriented Database Systems." SIGMOD 2006.

  • Foundational paper on database compression strategies. Explains the CPU-versus-I/O tradeoff that makes compression beneficial for I/O-bound workloads.

  • IBM developerWorks: "Understanding DB2 Universal Table Spaces" (technical article series).

  • Multi-part series covering UTS migration, performance characteristics, and best practices.

Online Resources

  • IDUG (International DB2 Users Group) — https://www.idug.org

  • Conference proceedings include numerous sessions on physical design, compression, and storage optimization. The annual IDUG North America and EMEA conferences are the premier venues for DB2 practitioners.

  • DB2 for z/OS and OS/390 DBA Certification Study Material — IBM Training

  • IBM's official certification preparation includes physical design modules with hands-on exercises.

  • Planet DB2 — https://planetdb2.com

  • Aggregator of DB2 blog posts from practitioners worldwide. Search for "tablespace design," "compression," and "partitioning" for real-world experience reports.
  • Chapter 3: DB2 Architecture — Buffer pools, memory management, and storage manager internals that underpin physical design decisions.
  • Chapter 11: Data Types and Domains — Data type selection affects row size, which drives page size and storage calculations.
  • Chapter 13: Logical Database Design — The logical model that this chapter translates into physical structures.
  • Chapter 15: Index Design — Index placement, index tablespace configuration, and the interaction between table partitioning and index partitioning.
  • Chapter 22: Utilities Deep Dive — REORG, RUNSTATS, LOAD, and other utilities referenced in this chapter for compression dictionary management and partition maintenance.
  • Chapter 27: Capacity Planning — Extends the storage estimation methodology from this chapter into full-scale enterprise capacity planning.