Chapter 30 Further Reading

IBM Official Documentation

z/OS

  • DB2 13 for z/OS: Managing Performance — Chapter on partitioning strategies and partition elimination. IBM Knowledge Center. https://www.ibm.com/docs/en/db2-for-zos/13

  • DB2 13 for z/OS: Administration Guide — Sections on partition-by-range universal table spaces, DPSI, NPSI, and partition-level utility operations. https://www.ibm.com/docs/en/db2-for-zos/13

  • DB2 13 for z/OS: Utility Guide and Reference — Detailed syntax for REORG, COPY, RECOVER, RUNSTATS, and LOAD with partition-level options (PART keyword). https://www.ibm.com/docs/en/db2-for-zos/13

  • DB2 13 for z/OS: SQL Reference — CREATE TABLE with PARTITION BY RANGE syntax, ALTER TABLE ADD/ROTATE PARTITION. https://www.ibm.com/docs/en/db2-for-zos/13

LUW

  • Db2 11.5: Database Administration Guide — Table partitioning overview, range partitioning, hash partitioning, ATTACH/DETACH operations. https://www.ibm.com/docs/en/db2/11.5

  • Db2 11.5: SQL Reference — CREATE TABLE with PARTITION BY RANGE and DISTRIBUTE BY HASH syntax. https://www.ibm.com/docs/en/db2/11.5

  • Db2 11.5: Database Partitioning Guide — Database Partitioning Feature (DPF), partition groups, distribution keys, collocated joins. https://www.ibm.com/docs/en/db2/11.5

IBM Redbooks and Technical Papers

  • DB2 for z/OS: Data Sharing in a Nutshell (SG24-8489) — Covers partition-level operations in data sharing environments, including considerations for partition-level utilities running across members.

  • DB2 11 for z/OS Technical Overview (SG24-8180) — Chapter on partition-by-range universal table spaces and the transition from classic partitioned table spaces.

  • Db2 Warehouse and Db2 on Cloud: Best Practices for Data Warehouse Performance — IBM technical white paper covering partitioning strategies in cloud-based Db2 deployments.

  • DB2 for z/OS: Indexing Best Practices — IBM technical paper covering DPSI vs. NPSI trade-offs, partition key inclusion in indexes, and clustering considerations.

Books

  • Mullins, Craig S. DB2 Developer's Guide: A Solutions-Oriented Approach to Learning the Foundation and Capabilities of DB2 for z/OS, 7th Edition. IBM Press, 2020. — Chapter 22 covers partitioning strategies in depth with real-world examples.

  • Zikopoulos, Paul C., et al. DB2 pureScale: Risk Free Agile Scaling, IBM Press, 2012. — Covers DPF and its evolution into pureScale, with partitioning strategy guidance.

  • Campbell, Susan Lawson. DB2 Utilities for z/OS: Partitioning Strategies and Utility Optimization, IBM, 2019. — Focused guide on aligning partitioning design with utility performance.

Community Resources

  • IDUG (International DB2 Users Group) — Annual conference presentations on partitioning best practices. Search the IDUG content library for "partitioning" and "rolling window." https://www.idug.org

  • IBM DB2 for z/OS Community — Forum discussions on partition key selection, DPSI vs. NPSI trade-offs, and rolling window automation. https://community.ibm.com/community/user/datamanagement

  • PlanetDB2 — Blog aggregator for DB2 content. Search for partitioning-related articles. http://www.planetdb2.com

  • Chapter 14: Indexing Strategies — Clustering indexes and their interaction with partitioned tables.
  • Chapter 17: Query Optimization — EXPLAIN output interpretation, including partition elimination indicators.
  • Chapter 22: Concurrency and Locking — Lock escalation in partitioned table spaces.
  • Chapter 28: Backup and Recovery — Partition-level backup and recovery strategies.
  • Chapter 29: HADR and High Availability — Partitioning combined with HADR for comprehensive availability.