1
Front Matter
5 chapters2
Part I: Foundations — Understanding DB2
5 chapters- Part I: Foundations — Understanding DB2
- Chapter 1: What Is IBM DB2? History, Architecture, and Why It Still Runs the World's Most Critical Systems
- Chapter 2: The Relational Model — How DB2 Thinks About Data
- Chapter 3: DB2 Architecture — What's Running When DB2 Is Running
- Chapter 4: Setting Up Your DB2 Environment -- Installation, Configuration, and Your First Database
3
Part II: SQL Mastery
9 chapters- Part II: SQL Mastery
- Chapter 5: SQL Fundamentals — SELECT, WHERE, ORDER BY, and the Art of Asking Questions
- Chapter 6: Joining Tables — INNER, OUTER, CROSS, and LATERAL
- Chapter 7: Aggregation and Grouping — COUNT, SUM, AVG, GROUP BY, HAVING, and Analytical Patterns
- Chapter 8: Subqueries and Common Table Expressions — Queries Within Queries
- Chapter 9: Data Modification: INSERT, UPDATE, DELETE, MERGE, and Transaction Control
- Chapter 10: Advanced SQL — Window Functions, OLAP Functions, Recursive Queries, and Temporal Queries
- Chapter 11: Data Definition Language — CREATE, ALTER, DROP: Building and Evolving Database Structures
- Chapter 12: Views, Triggers, and Stored Procedures — Encapsulating Logic in the Database
4
Part III: Database Design
5 chapters- Part III: Database Design
- Chapter 13: Logical Database Design — From Business Requirements to Entity-Relationship Models
- Chapter 14: Physical Database Design — Tablespaces, Partitioning, Compression, and Storage Optimization
- Chapter 15: Index Design — B+ Trees, Index-Only Access, Clustering, and the Art of Knowing What to Index
- Chapter 16: Schema Evolution and Data Migration — ALTER TABLE, Online Schema Changes, and Zero-Downtime Migrations
5
Part IV: Administration Fundamentals
6 chapters- Part IV: Administration Fundamentals
- Chapter 17: DB2 Utilities — REORG, RUNSTATS, COPY, RECOVER, LOAD, UNLOAD: The DBA's Essential Toolkit
- Chapter 18: Backup, Recovery, and Logging — Protecting Data Against Every Failure Mode
- Chapter 19: Security and Authorization — Authentication, Privileges, Roles, Row-Level Security, and Audit
- Chapter 20: Monitoring and Problem Determination — Knowing What's Wrong Before the Phone Rings
- Chapter 21: Catalog and Directory — Understanding DB2's Data About Your Data
6
Part V: Performance
7 chapters- Part V: Performance
- Chapter 22: How the DB2 Optimizer Works — Cost-Based Optimization, Access Path Selection, and Why Your Query Plan Changed
- Chapter 23: Reading and Interpreting EXPLAIN — The Single Most Important DBA Skill
- Chapter 24: SQL Tuning — Rewriting Queries for Performance Without Changing Results
- Chapter 25: Buffer Pool and Memory Tuning — Giving DB2 the Right Resources
- Chapter 26: Locking, Concurrency, and Isolation Levels — Balancing Throughput and Consistency
- Chapter 27: Performance Diagnosis Methodology — A Systematic Approach to Finding and Fixing the Bottleneck
7
Part VI: High Availability and Scalability
5 chapters- Part VI: High Availability and Scalability
- Chapter 28: Data Sharing and Parallel Sysplex — Multi-Member DB2 on z/OS
- Chapter 29: HADR and Replication — High Availability for DB2 LUW
- Chapter 30: Partitioning Strategies — Distributing Data for Scale and Manageability
- Chapter 31: DB2 in the Cloud — Db2 on Cloud, Db2 Warehouse, and Hybrid Deployment Patterns
8
Part VII: Application Development Patterns
5 chapters- Part VII: Application Development Patterns
- Chapter 32: Embedded SQL for COBOL and C — Static SQL, Cursors, and the Bind Process
- Chapter 33: JDBC, ODBC, and Python Access — Connecting Modern Applications to DB2
- Chapter 34: Stored Procedures, UDFs, and Application Logic in the Database
- Chapter 35: RESTful APIs and Modern Access Patterns: z/OS Connect, GraphQL, and Event Streaming
9
Part VIII: Capstone and Career
3 chapters10
Appendices
9 chaptersExplore Related Books
More open-access textbooks from our library
Advanced COBOL 305 pages AI Ethics 304 pages AI Literacy 40 pages AI & ML for Business 304 pages AI Engineering 307 pages Algorithmic Addiction 303 pages Applied Psychology 303 pages College Football Analytics 213 pages Creator Economy 318 pages Pattern Recognition 322 pages Data & Society 305 pages Ethical Hacking 318 pages Fandom 332 pages History of Appalachia 324 pages How Humans Get Stuck 285 pages Handling Confrontation 306 pages How Your House Works 306 pages Intermediate COBOL 334 pages Intro CS Python 44 pages Intro to Data Science 266 pages Introductory Statistics 216 pages Learning COBOL 322 pages Prediction Markets 316 pages Metacognition 222 pages Media Literacy 314 pages NFL Analytics 182 pages Physics of Music 316 pages Political Analytics 324 pages Basketball Analytics 214 pages Soccer Analytics 230 pages Propaganda 304 pages Python for Business 298 pages Quantum Mechanics 303 pages RegTech 307 pages Science of Seduction 320 pages Sports Betting 322 pages Architecture of Surveillance 299 pages Science of Luck 306 pages Vibe Coding 316 pages Why They Watch 308 pages Working with AI 316 pages