IBM DB2: From First Query to Enterprise Architecture
From First Query to Enterprise Architecture
Start Reading →
37 chapters
~53 hours total
282 sections
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 40 chapters · ~67h Advanced Data Science 39 chapters · ~57h AI Ethics 39 chapters · ~82h AI Literacy 21 chapters · ~13h AI & ML for Business 40 chapters · ~80h AI Engineering 40 chapters · ~53h Algorithmic Addiction 40 chapters · ~71h American Government 40 chapters · ~77h Applied Psychology 40 chapters · ~52h Assembly Language 40 chapters · ~27h Blockchain & Crypto 40 chapters · ~68h Calculus 40 chapters · ~51h College Football Analytics 28 chapters · ~18h Creator Economy 41 chapters · ~57h Pattern Recognition 43 chapters · ~92h Cybersecurity 40 chapters · ~84h Data & Society 40 chapters · ~71h Data Viz with Python 35 chapters · ~53h Discrete Mathematics for Computer Science 40 chapters · ~75h Ethical Hacking 41 chapters · ~58h Fandom 44 chapters · ~71h History of Appalachia 42 chapters · ~69h How Humans Get Stuck 40 chapters · ~36h Handling Confrontation 40 chapters · ~80h How to Learn Anything 38 chapters · ~54h How Your House Works 40 chapters · ~66h Intermediate COBOL 54 chapters · ~44h Intermediate Data Science 36 chapters · ~39h Intro CS Python 27 chapters · ~13h Intro to Data Science 36 chapters · ~54h Introductory Economics 40 chapters · ~12h Introductory Statistics 28 chapters · ~47h Learning COBOL 42 chapters · ~64h Prediction Markets 42 chapters · ~60h Linear Algebra 40 chapters · ~60h Metacognition 28 chapters · ~52h Media Literacy 41 chapters · ~81h Music Production 40 chapters · ~84h NFL Analytics 28 chapters · ~16h Nuclear Physics 35 chapters · ~28h Organic Chemistry 40 chapters · ~21h Pascal Programming 40 chapters · ~43h Physics of Music 48 chapters · ~75h Political Analytics 41 chapters · ~67h Popular Psychology 40 chapters · ~21h Practical Philosophy 38 chapters · ~63h Basketball Analytics 31 chapters · ~30h Soccer Analytics 30 chapters · ~43h Propaganda 40 chapters · ~80h Python for Business 40 chapters · ~40h Quantum Mechanics 40 chapters · ~66h RegTech 40 chapters · ~59h The Science of Cooking 40 chapters · ~70h Science of Seduction 45 chapters · ~60h Sports Betting 42 chapters · ~63h Technical Writing 40 chapters · ~70h Architecture of Surveillance 40 chapters · ~54h Science of Luck 40 chapters · ~72h Eastern Cultures 40 chapters · ~47h Western Culture 40 chapters · ~30h Vibe Coding 42 chapters · ~58h Video Game Design 40 chapters · ~36h Why They Watch 40 chapters · ~48h Working with AI 42 chapters · ~58h