Chapter 1 Exercises: What Is IBM DB2?

These exercises reinforce and extend the concepts from Chapter 1. They range from foundational recall to advanced research and analysis. Do not skip the ones that feel easy — retrieval of "obvious" facts builds the fluency you need for harder material later.

Difficulty Ratings: - Beginner — Recall and comprehension. If you read the chapter, you can answer these. - Intermediate — Application and analysis. Requires thinking beyond what was explicitly stated. - Advanced — Synthesis and evaluation. Requires research, judgment, or integration of multiple concepts.

Part A: Conceptual Foundations

Exercise 1.1 — DB2 Definition (Beginner)

Write a one-paragraph definition of IBM DB2 that you could give to a non-technical manager. Your definition should include: what DB2 is, what it does, and why it matters to their business. Avoid jargon. Use an analogy if it helps.

Exercise 1.2 — Timeline Construction (Beginner)

Without looking at the chapter, construct a timeline of DB2's history with at least eight key dates and events. After completing your timeline from memory, compare it against Section 1.2 and note what you missed.

Why this matters: The history of DB2 explains many of its current design decisions. Being able to recall this timeline fluently will help you understand "why" throughout the rest of the book.

Exercise 1.3 — Platform Mapping (Beginner)

Fill in the following table from memory:

Exercise 1.4 — z/OS vs. LUW Comparison (Intermediate)

Create a two-column comparison chart listing at least eight differences between DB2 for z/OS and DB2 for LUW. For each difference, explain why the difference exists (hint: it usually relates to the underlying platform or the target workload).

Exercise 1.5 — The Selinger Legacy (Intermediate)

Patricia Selinger's 1979 paper on cost-based optimization is mentioned in the chapter as foundational. In your own words, explain:

1. What problem does a cost-based optimizer solve?
2. Why is it better than the alternative approaches that existed before it (hint-based or rule-based optimization)?
3. How does a cost-based optimizer decide between two possible execution plans?

If you are unsure, this is a good time to search for a summary of the Selinger paper. You do not need to read the full paper for this exercise, but understanding its core contribution is important.

Exercise 1.6 — ACID at the ATM (Beginner)

A customer uses an ATM to withdraw $200 from their checking account. Describe how each of the four ACID properties (Atomicity, Consistency, Isolation, Durability) applies to this single transaction. Be specific about what could go wrong if each property were violated.

Exercise 1.7 — The Rebranding Question (Beginner)

Why did IBM rebrand "DB2" to "Db2" in 2017? What practical impact does this have on database professionals? (Hint: Consider documentation, search engines, and communication.)

Part B: Competitive Analysis

Exercise 1.8 — Database Selection Matrix (Intermediate)

You are a data architect evaluating databases for a new project. Create a weighted scoring matrix comparing DB2 for LUW, Oracle Database, PostgreSQL, and SQL Server across the following criteria:

• Licensing cost (weight: 20%)
• Performance at scale (weight: 20%)
• Ecosystem and tooling (weight: 15%)
• Cloud readiness (weight: 15%)
• Talent availability (weight: 15%)
• Enterprise support (weight: 15%)

Score each database 1-5 on each criterion. Justify your scores with reasoning from the chapter and your own knowledge. What does your matrix recommend?

Note: There is no single correct answer. The point is to practice structured evaluation.

Exercise 1.9 — The PostgreSQL Challenge (Intermediate)

A colleague argues: "PostgreSQL is free, open source, and has all the features of DB2. There is no reason to pay for DB2 anymore." Write a 300-word response that:

1. Acknowledges the legitimate strengths of PostgreSQL
2. Identifies specific scenarios where DB2 remains the better choice
3. Avoids being dismissive of either product

Exercise 1.10 — Cloud-Native vs. DB2 Position Paper (Advanced)

Write a one-page position paper (approximately 500 words) evaluating whether a mid-size insurance company should migrate its DB2 for z/OS policy management system to Amazon Aurora (PostgreSQL-compatible). Consider:

• Current state: 5,000 tables, 200 stored procedures, 15 years of regulatory compliance documentation
• Proposed state: Aurora PostgreSQL on AWS with automated backups and multi-AZ deployment
• Factors: cost, risk, compliance, skills, timeline, business continuity

Take a clear position (migrate, don't migrate, or conditional recommendation) and defend it.

Part C: Meridian National Bank

Exercise 1.11 — Meridian Architecture Diagram (Beginner)

Draw (on paper or using a diagramming tool) the technology architecture of Meridian National Bank as described in Section 1.7. Your diagram should show:

• The mainframe environment (z/OS, DB2, CICS)
• The distributed environment (Linux, Db2 for LUW, microservices)
• The analytics environment (Db2 Warehouse)
• The data flows between these environments (Kafka)

Label each component and indicate which DB2 product runs where.

Exercise 1.12 — Meridian Transaction Volume (Intermediate)

Meridian processes approximately 500 million transactions per year. Calculate:

1. The average number of transactions per day
2. The average number of transactions per second (assuming even distribution)
3. The likely peak transactions per second (assuming peak is 3x average and concentrated during business hours — 8 AM to 6 PM, Eastern Time, Monday through Friday)
4. How these numbers compare to the DB2 for z/OS capabilities described in Section 1.1

Show your work. Discuss whether Meridian's volume justifies a mainframe deployment.

Exercise 1.13 — Meridian Staffing Plan (Advanced)

Based on the description of Meridian National Bank, estimate the number and roles of DB2 professionals the bank would need. Consider:

• z/OS DBA staff for the mainframe environment
• LUW DBA staff for the distributed environment
• Application developers with DB2 skills
• A data architect
• After-hours and on-call coverage

Justify your estimates. How does the aging DB2 workforce (mentioned in Section 1.6) affect Meridian's staffing strategy?

Part D: Research Exercises

Exercise 1.14 — IBM Z Hardware Research (Intermediate)

Research the current generation of IBM Z hardware (the IBM z16 or its successor). Answer:

1. What is the maximum processing capacity in MIPS?
2. What unique hardware features does it provide (e.g., on-chip AI, encryption)?
3. How does the hardware design support DB2's availability guarantees?
4. What is the approximate starting price for an entry-level z16 configuration?

Cite your sources. Note that exact pricing information may be difficult to find — explain why.

Exercise 1.15 — DB2 in the Job Market (Beginner)

Search a major job board (Indeed, LinkedIn, or similar) for "DB2 DBA" positions. Record:

1. The total number of open positions
2. The salary range for entry-level, mid-level, and senior positions
3. The split between z/OS and LUW positions (where specified)
4. The most commonly requested complementary skills (e.g., COBOL, Java, Linux)
5. Geographic distribution of positions

How do these findings compare to the chapter's discussion in Section 1.6?

Exercise 1.16 — Continuous Delivery Deep Dive (Advanced)

Research IBM's continuous delivery model for DB2 12 for z/OS. Answer:

1. What is a "function level" and how does it differ from a traditional version upgrade?
2. How does an installation activate a new function level?
3. What happens if a new function level introduces a regression — can it be backed out?
4. How does continuous delivery change the DBA's approach to planning upgrades?

Use IBM's official documentation (IBM Knowledge Center) as your primary source.

Part E: DB2 Clinic (Diagnostic Exercises)

These exercises present scenarios you might encounter in a real DB2 environment. They are designed to build diagnostic thinking, even at this early stage.

Exercise 1.17 — The Confused Developer (Beginner)

A junior developer on your team says: "I wrote my SQL query on DB2 for LUW and it works perfectly. I sent it to the mainframe team and they say it doesn't run on z/OS. But it's the same database!"

Using what you learned in Section 1.3, explain to this developer: 1. Why their SQL might not work on both platforms 2. What categories of SQL differences exist between z/OS and LUW 3. How they should approach writing cross-platform SQL in the future

Exercise 1.18 — The Migration Debate (Intermediate)

You are in a meeting where a senior executive says: "We are paying $2 million a year for DB2 on the mainframe. PostgreSQL is free. Let's migrate and save $2 million."

Based on Section 1.5 and Section 1.6, prepare a 3-minute verbal response that: 1. Acknowledges the cost concern 2. Introduces the concept of total cost of ownership 3. Identifies the hidden costs of migration 4. Offers a constructive alternative (if appropriate)

Write your response as talking points, not a script.

Exercise 1.19 — The Product Identification Challenge (Beginner)

A colleague shows you a DB2 error message. You need to determine which DB2 platform produced it. For each of the following (fictional but realistic) clues, identify whether the source is most likely DB2 for z/OS or DB2 for LUW:

1. The error message references a "DSNZPARM" parameter
2. The database configuration mentions "LOGFILSIZ" and "LOGPATH"
3. The system uses RACF for authentication
4. The tool being used is called "db2top"
5. The SQL references a "STOGROUP"
6. The installation is described as an "instance" running under a specific UNIX user ID

Exercise 1.20 — Availability Mathematics (Intermediate)

A manager asks: "What's the big deal about five-nines availability? Four nines (99.99%) seems good enough."

Calculate the difference in annual downtime between: - 99.9% availability (three nines) - 99.99% availability (four nines) - 99.999% availability (five nines) - 99.9999% availability (six nines)

Then explain, using the Meridian National Bank context, what the business impact of each downtime level would be. How many transactions would be lost? What would the financial exposure be?

Part F: Mixed Practice (Interleaved Review)

These exercises deliberately mix topics from different sections of the chapter. Research shows that interleaved practice — alternating between different types of problems — produces better long-term retention than blocked practice (doing all problems of one type before moving to the next).

Exercise 1.21 — Concept Linking (Intermediate)

For each pair of concepts, explain the connection between them in 2-3 sentences:

1. System R and cost-based optimization
2. Parallel Sysplex and five-nines availability
3. Continuous delivery and migration cost
4. Polyglot persistence and Meridian National Bank
5. Ted Codd and data independence

Exercise 1.22 — Scenario Analysis (Advanced)

For each scenario below, recommend a database platform (DB2 for z/OS, DB2 for LUW, Oracle, PostgreSQL, SQL Server, or a cloud-native option) and justify your recommendation in 3-4 sentences. There may be multiple valid answers — defend yours.

1. A 200-employee manufacturing company needs a database for its ERP system. The IT team has three people and primarily uses Windows.

2. A government tax authority processes 150 million tax returns annually. Data must be retained for seven years and be recoverable to any point in time. The agency has an existing mainframe infrastructure.

3. A Silicon Valley startup is building a real-time analytics platform for e-commerce. They need to handle 50,000 events per second with sub-100ms query latency. Their team consists of 12 engineers who all know PostgreSQL.

4. A large European bank is building a new mobile banking application. Their core banking system runs on DB2 for z/OS. The mobile app needs to read (but not write) customer account data.

5. A healthcare company needs to store patient records with strict HIPAA compliance. They currently have no database infrastructure and want to avoid managing servers.

Exercise 1.23 — The Elevator Pitch (Beginner)

You have 60 seconds in an elevator with a CTO who asks: "Why should I care about DB2?" Write your elevator pitch. It should be exactly 60 seconds when spoken aloud (approximately 150 words). Practice saying it.

Exercise 1.24 — Historical Counterfactual (Advanced)

This is a thought exercise, not a factual question.

Suppose IBM had never built System R, and the relational model had been first implemented commercially by a different company (or an open-source project). How might the database landscape look different today? Consider:

1. Would SQL still be the dominant query language?
2. Would the mainframe database market look different?
3. How would this have affected Oracle's trajectory (Oracle was inspired by System R)?
4. Would IBM still be a major force in the database market?

Write a 300-500 word speculative essay. The point is not to be "right" but to think critically about how technology history shapes the present.

Exercise 1.25 — Self-Assessment Checklist (Beginner)

Rate your confidence (1 = not confident, 5 = very confident) on each of the chapter's learning objectives:

For any objective rated 3 or below, return to the relevant section and re-read it. Then close the book and try to explain the concept aloud to an empty room (or a willing colleague). This "teach-back" method is one of the most effective learning strategies available.

Answers and Discussion Notes

Exercise 1.6 — ACID at the ATM (Sample Answer)

Atomicity: The withdrawal involves at least two operations: deducting $200 from the account balance and dispensing cash. If the ATM dispenses cash but the balance update fails, the customer gets free money. If the balance is deducted but the cash is not dispensed, the customer loses money. Atomicity ensures both happen or neither happens.

Consistency: Before and after the withdrawal, the database must satisfy all constraints — for example, the balance cannot go below zero (if the account has no overdraft protection), and the total of all transactions must equal the change in balance. If consistency is violated, the bank's books won't balance.

Isolation: If the customer's spouse is simultaneously making a purchase with a debit card from the same account, neither transaction should see an intermediate state of the other. Without isolation, both transactions might read a $500 balance, each authorize a $300 operation, and overdraw the account.

Durability: Once the ATM displays "Withdrawal Complete" and the receipt is printed, the transaction is permanent. Even if the ATM loses power one second later, or the data center experiences a disk failure, the withdrawal is recorded and cannot be lost.

Exercise 1.12 — Meridian Transaction Volume (Sample Calculation)

1. Per day: 500,000,000 / 365 = approximately 1,369,863 transactions per day
2. Per second (even): 1,369,863 / 86,400 = approximately 15.9 transactions per second
3. Peak TPS: Business hours = 10 hours/day * 5 days/week. Annual business hours = 10 * 260 = 2,600 hours. If 70% of transactions occur during business hours: 350,000,000 / (2,600 * 3,600) = approximately 37.4 TPS average during business hours. At 3x peak: approximately 112 TPS.
4. Comparison: DB2 for z/OS can handle 10,000+ TPS. Meridian's 112 TPS peak is well within a single subsystem's capacity. However, the mainframe is justified by the availability requirements, batch processing capacity, and regulatory environment — not just TPS.

Exercise 1.20 — Availability Mathematics (Sample Calculation)

The business impact extends beyond lost transactions to reputational damage, regulatory scrutiny, and customer trust — factors that are difficult to quantify but often dominate the cost analysis.

Return to Chapter 1 | Continue to Quiz