Bibliography
Sources are organized into three tiers reflecting their nature and verification status, then grouped by topic area within each tier.
Tier 1: Verified Sources
These are primary sources from IBM and canonical published works whose content can be independently verified.
IBM Official Documentation
IBM Knowledge Center. Db2 11.5 for Linux, UNIX, and Windows Documentation. IBM Corporation. https://www.ibm.com/docs/en/db2/11.5
IBM Knowledge Center. Db2 13 for z/OS Documentation. IBM Corporation. https://www.ibm.com/docs/en/db2-for-zos/13
IBM Knowledge Center. Db2 12 for z/OS Documentation. IBM Corporation. https://www.ibm.com/docs/en/db2-for-zos/12
IBM Corporation. DB2 SQL Reference for Cross-Platform Development. Version 6. IBM Corporation, 2021.
IBM Corporation. Db2 11.5 SQL Reference, Volumes 1 and 2. SC27-8857, SC27-8858. IBM Corporation.
IBM Corporation. Db2 for z/OS SQL Reference. SC19-4066. IBM Corporation.
IBM Corporation. Db2 for z/OS Administration Guide. SC19-4050. IBM Corporation.
IBM Corporation. Db2 for z/OS Utility Guide and Reference. SC19-4067. IBM Corporation.
IBM Corporation. Db2 for z/OS Performance Monitoring and Tuning Guide. SC19-4060. IBM Corporation.
IBM Corporation. Db2 for z/OS Managing Performance. SC19-4059. IBM Corporation.
IBM Redbooks
Bartels, Whei-Jen, et al. DB2 11 for z/OS Technical Overview. IBM Redbooks, SG24-8180. IBM Corporation, 2014.
Beaton, John, et al. DB2 12 for z/OS Technical Overview. IBM Redbooks, SG24-8435. IBM Corporation, 2017.
Bruni, Paolo, et al. DB2 for z/OS: Data Sharing in a Nutshell. IBM Redbooks, SG24-8492. IBM Corporation, 2018.
Campbell, Whei-Jen, et al. Db2 12 for z/OS Administration. IBM Redbooks, SG24-8180. IBM Corporation, 2018.
Coelho, Rafael, et al. Db2 11.1 Certification Study Guide. IBM Redbooks, SG24-8410. IBM Corporation, 2017.
Driscoll, Joe, et al. DB2 Recovery Expert for Multiplatforms. IBM Redbooks, SG24-7224. IBM Corporation.
Fisk, Dale, et al. Db2 for z/OS Buffer Pool Monitoring and Tuning. IBM Redbooks, SG24-6380. IBM Corporation.
Hahn, Terry, et al. High Availability and Disaster Recovery with Db2 for z/OS. IBM Redbooks, SG24-8218. IBM Corporation.
Ketelaars, Tetiana, et al. pureScale: Risk-Free Agile Scaling. IBM Redbooks, SG24-8210. IBM Corporation.
Lapis, George, et al. DB2 for z/OS and OS/390: Ready for Java. IBM Redbooks, SG24-6435. IBM Corporation.
Melnyk, Brian, et al. Modernizing DB2 for z/OS Applications. IBM Redbooks, SG24-8496. IBM Corporation.
Saraiva, Tetiana, et al. What's New in Db2 for z/OS: Version 13. IBM Redbooks, SG24-8585. IBM Corporation, 2022.
Canonical DB2 Books
Birchall, Susan Lawson. DB2 for z/OS and OS/390 Development for Performance. Birchall Associates, 2003. A deep treatment of physical design decisions and their performance implications.
Chamberlin, Don. A Complete Guide to DB2 Universal Database. Morgan Kaufmann, 1998. Historical reference from one of the co-inventors of SQL and original DB2 architects.
Gunning, Craig S., and Rick Swagerman. DB2 Universal Database for OS/390 v7 Application Programming and SQL Guide. McGraw-Hill, 2001.
Mullins, Craig S. DB2 Developer's Guide. 6th Edition. IBM Press / Pearson, 2012. The comprehensive reference for DB2 for z/OS application developers. Covers SQL, embedded programming, stored procedures, and utilities.
Mullins, Craig S. Database Administration: The Complete Guide to DBA Practices and Procedures. 2nd Edition. Addison-Wesley Professional, 2012. A vendor-neutral treatment with substantial DB2 coverage.
Padmanabhan, Sanjay, et al. DB2 for z/OS: Your Complete Guide to DB2's Foundations and Capabilities. MC Press Online, 2015.
Ramakrishnan, Raghu, and Johannes Gehrke. Database Management Systems. 3rd Edition. McGraw-Hill, 2003. The academic reference for relational algebra, query optimization theory, and transaction management covered in Appendix A and Chapters 7 and 12.
Silberschatz, Abraham, Henry F. Korth, and S. Sudarshan. Database System Concepts. 7th Edition. McGraw-Hill, 2019. Another standard academic text with thorough coverage of B+ trees, concurrency control, and recovery.
Yevich, Richard, and Susan Lawson. DB2 for z/OS: The Database for Today and Tomorrow. Yevich Lawson & Associates, 2005.
Zikopoulos, Paul, George Baklarz, and Roman Melnyk. DB2 pureScale: Risk Free Agile Scaling. MC Press Online, 2010.
Zikopoulos, Paul, et al. DB2 Essentials: Understanding DB2 in a Big Data World. 3rd Edition. IBM Press, 2013.
Database Theory and Foundations
Codd, E. F. "A Relational Model of Data for Large Shared Data Banks." Communications of the ACM, Vol. 13, No. 6 (June 1970), pp. 377-387. The foundational paper that established the relational model.
Date, C. J. An Introduction to Database Systems. 8th Edition. Addison-Wesley, 2003. The definitive academic treatment of relational theory.
Gray, Jim, and Andreas Reuter. Transaction Processing: Concepts and Techniques. Morgan Kaufmann, 1993. The authoritative reference on ACID properties, logging, and recovery algorithms.
Hellerstein, Joseph M., Michael Stonebraker, and James Hamilton. "Architecture of a Database System." Foundations and Trends in Databases, Vol. 1, No. 2 (2007), pp. 141-259. An excellent overview of RDBMS internals applicable to understanding DB2's architecture.
Mohan, C., et al. "ARIES: A Transaction Recovery Method Supporting Fine-Granularity Locking and Partial Rollbacks Using Write-Ahead Logging." ACM Transactions on Database Systems, Vol. 17, No. 1 (March 1992), pp. 94-162. The recovery algorithm underlying DB2's logging and recovery subsystem.
Selinger, P. Griffiths, et al. "Access Path Selection in a Relational Database Management System." Proceedings of ACM SIGMOD, 1979, pp. 23-34. The original paper on cost-based query optimization, written by the System R team---direct ancestors of DB2.
Performance and Tuning References
Ballard, Chuck, et al. DB2 Performance Expert for Multiplatforms. IBM Redbooks, SG24-7073. IBM Corporation.
Bondi, Andre B. "Foundations of Software and System Performance Engineering." Addison-Wesley, 2014. General performance engineering principles applicable to DB2 capacity planning.
Gunning, Craig. The Art and Science of DB2 Performance Tuning. IBM User Group presentations, various years. Widely referenced in DB2 performance discussions.
Jain, Raj. The Art of Computer Systems Performance Analysis. Wiley, 1991. Statistical methods for performance measurement referenced in Chapters 16 and Appendix A.
Security
Natan, Ron Ben. Implementing Database Security and Auditing. Elsevier/Digital Press, 2005. Covers DB2 security architecture including LBAC and auditing.
Standards and Specifications
International Organization for Standardization. ISO/IEC 9075:2023 --- Information Technology --- Database Languages --- SQL. The SQL standard that DB2 implements with extensions.
The Open Group. DRDA (Distributed Relational Database Architecture) Reference. Version 5. The communication protocol specification used by DB2 for cross-platform and distributed access.
Additional IBM Publications
IBM Corporation. Db2 for z/OS: Codes. GC19-4053. Reference for all SQLCODE values, reason codes, and ABEND codes on z/OS.
IBM Corporation. Db2 for z/OS: Installation and Migration Guide. GC19-4052. Required reading for z/OS DB2 installation, migration, and version upgrade planning.
IBM Corporation. Db2 for z/OS: Command Reference. SC19-4051. Complete reference for all DB2 commands (-START, -STOP, -DISPLAY, etc.).
IBM Corporation. Db2 for z/OS: Data Sharing: Planning and Administration. SC19-4055. The definitive guide for data sharing configuration and administration.
IBM Corporation. Db2 for Linux, UNIX, and Windows: Database Administration Concepts and Configuration Reference. SC27-8845. Covers all configuration parameters and administrative concepts on LUW.
IBM Corporation. Db2 for Linux, UNIX, and Windows: Troubleshooting and Tuning Database Performance. SC27-8851. IBM's own performance tuning guide for LUW.
IBM Corporation. IBM Data Server Driver for JDBC and SQLJ. Documentation for the JDBC Type 4 driver used by Java applications connecting to DB2.
Tier 2: Attributed Sources
These are findings, analyses, and techniques attributed to specific practitioners, organizations, or research but not independently verified by the authors beyond citation.
Industry Analyses and Reports
Gartner Group. Magic Quadrant for Operational Database Management Systems. Various annual editions. Referenced in Chapter 1 for DB2's market positioning.
IDC. Worldwide Relational Database Management Systems Market Share. Various annual editions. Referenced in Chapter 1 for DB2 usage statistics.
ITIC (Information Technology Intelligence Consulting). 2023 Global Server Hardware, Server OS Reliability Report. Referenced in Chapter 18 for z/OS reliability claims.
Technical Articles and Presentations
Campbell, John. "DB2 for z/OS Buffer Pool Tuning: A Practical Approach." Presented at IDUG North America, various years. Referenced in Chapters 9 and 16.
Corrigan, John. "HADR Best Practices for Db2 LUW." IBM Data Magazine, 2019. Referenced in Chapter 17.
Freiwald, Chris, and Dale McInnis. "Db2 BLU Acceleration: Innovation Delivered." IBM developerWorks, 2013. Referenced in Chapter 27.
Huras, Matt, and Adam Storm. "Db2 with BLU Acceleration: So Much More Than Just a Column Store." Proceedings of the VLDB Endowment, Vol. 6, No. 11, 2013. Referenced in Chapter 27.
Lightstone, Sam, Toby Teorey, and Tom Nadeau. Physical Database Design. Morgan Kaufmann, 2007. Referenced in Chapter 4 for physical design methodology.
Lohman, Guy. "Is Query Optimization a 'Solved' Problem?" Keynote, VLDB 2014. Referenced in Chapter 12 for discussion of optimizer limitations.
Markl, Volker, et al. "Robust Query Processing through Progressive Optimization." Proceedings of ACM SIGMOD, 2004. Referenced in Chapter 12 for adaptive query processing concepts.
Sloan, Terry. "DB2 for z/OS: Lock Avoidance Techniques." SHARE Conference, various years. Referenced in Chapter 7.
Snow, Dawn. "Db2 for z/OS: What's New in Version 13." IDUG Conference proceedings, 2022. Referenced in Chapter 37.
Blog Posts and Online Resources
Db2 on Campus Program. IBM Corporation. Free Db2 licenses for academic use. https://www.ibm.com/academic
Ember Crooks (Db2Commerce blog). Various articles on Db2 LUW administration, HADR, and performance. Referenced in Chapters 15 and 17.
Db2 Portal (db2portal.com, now archived). Historical community resource for DB2 z/OS practitioners.
IDUG (International DB2 Users Group). Conference proceedings and online content library. https://www.idug.org. Referenced throughout for community expertise.
Planet DB2. Community blog aggregator for DB2 content. https://planetdb2.com.
Stack Overflow. Various DB2-tagged questions and answers. Referenced as a community resource in Appendix E.
Vendor and Tool Documentation
DBeaver. DBeaver Community Edition Documentation. https://dbeaver.com/docs/wiki/. Referenced in Appendix C for GUI tool setup.
Docker, Inc. Docker Hub: IBM Db2 Community Edition. Container image documentation and configuration options. Referenced in Appendix C.
Zowe. Zowe CLI Documentation and Db2 Plugin Reference. https://docs.zowe.org. Referenced in Appendix C for z/OS access from modern workstations.
Conference Proceedings and User Group Content
SHARE Association. Various technical sessions on DB2 for z/OS administration, performance, and new features. SHARE conferences (held semi-annually) are the primary venue for z/OS DB2 knowledge sharing among practitioners.
IDUG (International DB2 Users Group). IDUG Solutions Journal and conference proceedings. IDUG is the premier organization for DB2 practitioners on both platforms, providing peer-reviewed technical content and networking opportunities.
IBM Think Conference. Annual IBM conference with DB2 technical sessions covering product direction, customer case studies, and hands-on labs.
White Papers and Technical Reports
IBM Corporation. "Db2 BLU Acceleration: Breakthrough Analytics Performance." IBM White Paper, 2013. Referenced in Chapter 27 for BLU architecture and benchmarks.
IBM Corporation. "Db2 pureScale: Continuous Availability for Enterprise Applications." IBM White Paper, 2014. Referenced in Chapter 18 for pureScale architecture and failover behavior.
IBM Corporation. "Db2 AI Database: Machine Learning Capabilities for Database Administration." IBM White Paper, 2020. Referenced in Chapter 37 for AI-driven database management features.
Finlayson, Mark, et al. "Db2 Event Store: Fast Data Ingestion for AI Applications." IBM Research Report, 2019. Referenced in Chapter 37 for emerging DB2 capabilities.
Tier 3: Illustrative Sources
These are fictional or composite examples used for pedagogical purposes. Any resemblance to real organizations beyond the general patterns described is coincidental.
Case Studies and Scenarios
Meridian Bank. A composite case study used in Chapters 7, 15, and 18 to illustrate transaction isolation, backup/recovery procedures, and data sharing configuration in a banking environment. The scenario is based on common patterns observed across multiple financial institutions but does not represent any specific organization.
Northwind Logistics. A composite case study used in Chapters 10 and 28 to illustrate batch processing, data loading strategies, and database partitioning for a supply chain management workload.
Pacific Health Systems. A composite case study used in Chapters 22 and 30 to illustrate row-level security (RCAC), audit compliance, and temporal data management in a healthcare setting subject to regulatory requirements.
Apex Trading Platform. A composite case study used in Chapters 12, 13, and 16 to illustrate real-time performance tuning, query optimization, and capacity planning for a high-frequency trading analytics workload.
GreenField SaaS. A composite case study used in Chapters 17 and 35 to illustrate HADR configuration for a cloud-based SaaS application and migration from Oracle to DB2.
Continental Insurance. A composite case study used in Chapter 30 to illustrate bi-temporal data modeling for insurance policy management, combining system-time and application-time temporal tables to satisfy regulatory audit requirements.
Metro Transit Authority. A composite case study used in Chapters 23 and 28 to illustrate workload management and database partitioning for a high-volume IoT data ingestion scenario involving transit sensor data.
Pinnacle Retail. A composite case study used in Chapters 27 and 29 to illustrate BLU Acceleration for retail analytics and federated queries spanning DB2 warehouse tables and external data sources.
Worked Examples
All SQL examples, query results, EXPLAIN output, and performance measurements in the text are either: 1. Executed against the IBM SAMPLE database or the custom schema defined in Chapters 2 and 3. 2. Synthesized from patterns commonly seen in production environments but with altered names, values, and scales. 3. Simplified for clarity---real production plans and statistics may show additional operators and steps.
Organized by Topic Area
For readers researching a specific topic, the following cross-reference maps topics to the most relevant sources.
Relational Theory and SQL
- Codd (1970), Date (2003), Ramakrishnan and Gehrke (2003), Chamberlin (1998)
DB2 Architecture and Internals
- Hellerstein et al. (2007), IBM Knowledge Center, Beaton et al. (Redbook), Mullins (2012)
Query Optimization
- Selinger et al. (1979), Lohman (2014), Markl et al. (2004), IBM Performance Monitoring and Tuning Guide
Physical Design and Storage
- Lightstone et al. (2007), Birchall (2003), IBM Administration Guide
Transaction Processing and Recovery
- Gray and Reuter (1993), Mohan et al. (1992/ARIES), IBM Recovery documentation
High Availability
- Bruni et al. (Redbook/Data Sharing), Hahn et al. (Redbook/HA-DR), Ketelaars et al. (Redbook/pureScale), Corrigan (2019)
Performance Tuning
- Mullins (2012), Ballard et al. (Redbook), Jain (1991), Gunning (various), Fisk et al. (Redbook/Buffer Pools)
Security and Compliance
- Natan (2005), IBM DB2 Security Guide, Pacific Health Systems case study
BLU Acceleration and Analytics
- Huras and Storm (2013), Freiwald and McInnis (2013), Zikopoulos et al. (2013)
Application Development
- Mullins (2012), Lapis et al. (Redbook/Java), IBM Application Programming Guide
z/OS-Specific Topics
- Padmanabhan et al. (2015), Yevich and Lawson (2005), Campbell et al. (Redbook/Admin), SHARE and IDUG proceedings
Migration
- IBM Migration Toolkit documentation, GreenField SaaS case study, Zikopoulos et al. (2013)
All URLs were verified at the time of writing. IBM Knowledge Center URLs may change as IBM reorganizes its documentation; search ibm.com/docs for the most current links.