DB2 11 Fundamentals for z/OS: Exam Guide, Scope, and Study Decisions
DB2 11 Fundamentals for z/OS was an entry-level IBM certification for users of the DB2 for z/OS product family. Its associated exam, C2090-320, tested foundational knowledge across SQL and XML, security, planning, operations, administration, database objects, and transaction isolation. IBM states that the certification was withdrawn on October 31, 2021, and expired on March 31, 2023. This guide therefore helps you decide whether the archived objectives are useful for study or whether you should pursue a current replacement instead.
Is this certification still available?
No. IBM states that the DB2 11 Fundamentals for z/OS certification was withdrawn on October 31, 2021, and expired on March 31, 2023. The associated exam was C2090-320, titled “DB2 11 Fundamentals for z/OS.” Treat the material as an archived knowledge outline, not as a currently schedulable certification. Before investing in booking plans, check IBM’s current certification catalogue for the replacement or successor path.
The historical IBM page says that C2090-320 was withdrawn and would be replaced by exam C1000-122. The supplied official information does not establish the current availability, title, delivery method, price, dates, or status of C1000-122, so those details should not be assumed from the older exam page.
The practical decision is straightforward: use this guide if you need to understand an existing credential, maintain familiarity with Db2 11 for z/OS, or prepare for work involving an older environment. If your goal is a new IBM credential, stop at the status check and identify the current certification before buying training or attempting to schedule an exam.
Who was the exam designed for?
IBM described the certification as entry-level for users of the DB2 for z/OS product family. IBM recommended entry-level experience using DB2 11 and basic knowledge of SQL, so the intended candidate was not necessarily a senior database administrator. The target was someone who could understand core Db2 concepts and participate in routine database work.
The stated knowledge included day-to-day administration, basic SQL, DB2 11 additional products, database and database-object creation, security, and transaction isolation. That combination points to a foundation exam: candidates needed to connect database concepts with common z/OS Db2 tasks rather than specialize in one advanced operational discipline.
A sensible audience includes junior Db2 professionals, application developers who interact with Db2 for z/OS, systems or operations staff who support Db2 environments, and experienced relational-database users moving toward the z/OS product family. The entry-level label does not remove the need to understand Db2 terminology, object relationships, authorization, and operational responsibilities.
What knowledge did the objectives cover?
The exam objectives covered working with SQL and XML, security, planning, and operations. IBM also described day-to-day administration, database and database-object creation, additional products, and transaction isolation. Prepare by learning how these areas relate in a Db2 for z/OS environment, not by studying isolated vocabulary lists.
The official Db2 11 for z/OS documentation organizes relevant material around installation or migration, application development and execution, and database and subsystem administration and operation. Those three broad documentation areas provide a useful map for arranging the older exam objectives into study blocks.
SQL and XML should be studied as practical data-access topics. Focus on the purpose of common SQL operations, the relationship between statements and database objects, and the role of XML in the published objective area. For every topic, ask what problem the feature solves, which object or authority it depends on, and what operational consequence follows.
Security deserves separate attention because a candidate can understand SQL syntax yet still miss authorization and access-control concepts. Study who can perform an action, what object is protected, and how security affects application or administrative work. Keep the distinction clear between being able to issue a statement and being authorized to complete it.
Planning covers the decisions made before implementation or change. Use it to organize database and database-object creation, design choices, installation or migration considerations, and the relationship between applications and the Db2 subsystem. Avoid turning planning into a list of commands; the important question is why a particular design or implementation choice is appropriate.
Operations connects the database to its ongoing use. Review routine administration, subsystem operation, application execution, and the operational meaning of transaction isolation. Build short scenarios in which you identify the task, the relevant Db2 object or subsystem area, and the likely impact on users or applications.
How should the published percentages be read?
IBM allocated 14% of the exam objectives to working with SQL and XML, 8% to security, 17% to planning, and 14% to operations. These percentages belong to the named exam domains and should not be treated as a complete current blueprint, especially because the certification and exam are withdrawn.
The largest published allocation among these listed domains was planning at 17% of the exam objectives. That makes planning a sensible early study priority, but it is not a reason to neglect security or SQL and XML. Security accounted for 8% of the exam objectives, while working with SQL and XML accounted for 14% and operations accounted for 14%. Keep each percentage attached to its domain when making a study plan.
The supplied official material does not provide a complete breakdown of every objective or confirm whether the listed percentages sum to the entire exam. Do not invent missing domains or redistribute the published values. Use them as directional evidence for emphasis, then validate the exact objective list against the archived IBM page and the Db2 11 documentation.
Which IBM documentation should anchor preparation?
Start with IBM’s Db2 11 for z/OS documentation rather than general Db2 material. IBM identifies that documentation as applying to software version 11.0 on z/OS and lists manuals such as the Administration Guide, Application Programming and SQL Guide, Command Reference, Installation and Migration Guide, Managing Security, SQL Reference, and Utility Guide and Reference.
Use the Administration Guide for administration and operation concepts, the Application Programming and SQL Guide for application-facing behavior, and the SQL Reference when a term or statement needs precise confirmation. Use Managing Security for authorization topics, the Command Reference for command purpose and context, and the Installation and Migration Guide for planning-related implementation concerns.
The documentation is broad, so reading every manual from beginning to end is inefficient. Begin with the archived exam objectives. For each objective, locate the smallest relevant documentation section, write a plain-language explanation, and record any dependencies. Return to the wider manual only when the local explanation assumes a concept you do not yet understand.
IBM states that Db2 11 for z/OS reached end of support on March 31, 2021, and that the existing online documentation is provided as-is for clients with extended support contracts. That matters for source control: use the documentation to understand the historical product and exam scope, but do not assume that every Db2 11 practice is the preferred approach for a later release.
IBM also says that the entire set of Db2 11 for z/OS product documentation can be downloaded as a single indexed PDF collection. A local indexed copy can make cross-referencing easier when studying an archived release. Keep a source note beside each study item so that a later Db2 release does not silently replace the version 11 behavior you intended to learn.
What is the historical exam format?
IBM’s archived certification page states that the exam had 63 questions, required 41 correct answers to pass, and allowed 90 minutes. Those figures describe the historical C2090-320 exam only. Because IBM withdrew the exam, they must not be used to plan a current booking or assumed to describe a replacement.
The historical figures imply that preparation needed both subject knowledge and disciplined question handling. Candidates could not rely on looking up every unfamiliar term during the examination. A useful practice method is to answer objective-based questions from memory, mark uncertainty, and review the underlying concept rather than memorizing an answer pattern.
Do not infer a present delivery method from general IBM Db2 education pages. The supplied IBM tutorials page says that certification exams are typically available exclusively at IDUG Conferences and also describes a process for certain Db2 exams outside official events. That general information does not prove that C2090-320 remains deliverable or that it applies to a successor exam.
Do not use old question dumps, leaked questions, or memorization claims as a substitute for learning. Archived questions may be inaccurate, unauthorized, or tied to a different blueprint. Build readiness by explaining concepts, interpreting small scenarios, and checking each answer against official version 11 documentation.
How should you sequence the study?
Use a dependency-first sequence: establish relational and Db2 vocabulary, learn object creation and planning, connect applications and SQL, then study security and operations through scenarios. This order reduces backtracking because later topics depend on knowing what the database objects are, how applications interact with them, and which authorities govern access.
First, make a scope sheet from the archived objectives. Divide it into SQL and XML, security, planning, operations, administration, database and database-object creation, additional products, and transaction isolation. Label each item as “explain,” “distinguish,” or “apply.” That classification prevents a familiar word from being mistaken for usable knowledge.
Next, build the structural foundation. Identify the purpose and relationship of the principal database and object concepts covered by the documentation. For each one, write what it stores or controls, which users or applications depend on it, and what an administrator would need to consider before changing it.
Then study planning and creation together. Planning was allocated 17% of the exam objectives, the largest of the named published allocations, so give it early attention. Work through design decisions on paper: define the requirement, identify the Db2 objects involved, select the relevant documentation area, and state the operational or security consequence.
After that, connect application development and SQL. Practice reading a requirement and deciding whether it calls for data definition, data manipulation, retrieval, or an application-execution concern. Add XML only after the SQL foundation is stable, and keep a separate note for terminology that is specific to the objective rather than universally applicable to relational databases.
Finish with security, operations, and transaction isolation. These topics are easier to remember when attached to situations: a user needs access, an application runs concurrently with another workload, an administrator performs a routine task, or a subsystem change must be planned. For each situation, explain the trade-off and the authority or operational dependency involved.
A four-stage roadmap
Stage one is orientation. Read the archived IBM certification page, confirm that you are studying historical material, and create the scope sheet. Refresh basic SQL before opening the more specialized Db2 manuals. If you cannot explain tables, relationships, retrieval, modification, and authorization in plain language, resolve those gaps first.
Stage two is product structure. Use the Administration Guide and the relevant creation, administration, and planning sections to map database objects and subsystem responsibilities. Draw relationships between concepts instead of copying definitions. A diagram that shows how an application, database object, authorization decision, and operational task connect is more useful than a long glossary.
Stage three is application and control. Study the Application Programming and SQL Guide, SQL Reference, Managing Security, and the relevant command material. For every feature, write one “what it does” statement and one “when it matters” statement. This forces you to understand both function and context.
Stage four is consolidation. Take mixed, self-written practice prompts that require a choice or explanation. Review wrong answers by domain, not only by question. If several errors involve planning, return to the planning documentation; if errors involve authorization, separate identity, privilege, and object scope in your notes. Finish by checking whether every archived objective has evidence beside it.
How can you study without a Db2 11 z/OS environment?
A live environment is useful but not required for every foundation topic. Use official documentation to build concept maps, read command and SQL examples carefully, and reason through object, authorization, and transaction scenarios. If you have access to an employer’s Db2 for z/OS system, observe under approved procedures; do not alter production objects merely to gain practice.
Separate knowledge that requires interpretation from knowledge that requires execution. Definitions, object relationships, security principles, planning decisions, and transaction-isolation reasoning can be studied with documentation and written scenarios. Syntax, command context, and application behavior benefit more from controlled exercises or supervised observation.
IBM’s Db2 education page lists no-cost learning resources, including Db2 Lite tier, Coursera, and other partners. Those resources may help with general relational or Db2 foundations, but the supplied evidence does not establish that they reproduce the historical Db2 11 for z/OS blueprint. Use them to close fundamentals gaps, then return to the z/OS documentation for product-specific study.
Avoid treating a Linux, UNIX, or Windows Db2 exercise as proof of z/OS readiness. Shared relational concepts can transfer, but platform, subsystem, administration, and documentation context may differ. Mark each note as general Db2 knowledge or Db2 for z/OS knowledge so that you know what still needs version-specific verification.
What mistakes waste the most preparation time?
The first mistake is preparing as if C2090-320 were an active exam. Its withdrawal and the certification’s expiration make current scheduling assumptions unsafe. Confirm the current IBM path before setting a deadline, purchasing a course, or relying on the historical format.
The second mistake is studying only SQL. IBM’s target knowledge also included administration, additional products, database and object creation, security, and transaction isolation. SQL is visible and easy to practice, but a candidate who ignores planning and operations can leave major parts of the historical scope uncovered.
The third mistake is memorizing commands without understanding their purpose. A foundation exam can test whether you recognize the correct concept or responsibility in a scenario. For each command or statement you study, record the task it supports, the object or subsystem area it affects, and the authorization or planning issue that accompanies it.
The fourth mistake is using percentages as a substitute for coverage. The published values identify 14% for working with SQL and XML, 8% for security, 17% for planning, and 14% for operations, but they do not provide a complete detailed blueprint in the supplied evidence. Prioritize planning while still completing every objective area.
The fifth mistake is mixing product generations without labels. Db2 11 for z/OS documentation is historical, and IBM says the release reached end of support on March 31, 2021. A newer manual may explain a related concept differently. Record the release beside each source and verify version-sensitive statements before using them in your notes.
The final mistake is relying on recalled questions or claims that memorization guarantees passing. That approach does not build transferable skill and may expose you to inaccurate or unauthorized material. Use questions only as prompts for reasoning, then verify the underlying answer in IBM documentation.
How do you know your preparation is complete?
You are ready to close the study loop when you can explain every archived objective without opening a reference, distinguish planning from operations, connect SQL behavior to database objects, and reason about security and transaction isolation in a short scenario. For an obsolete exam, this is a knowledge-readiness test, not evidence that a booking is possible.
Create a final review table with four columns: objective, your explanation, IBM source section, and unresolved question. Do not mark an item complete because you recognize its terminology. Mark it complete only when you can describe its purpose, dependencies, and practical consequence accurately.
Use mixed review rather than domain-by-domain repetition at the end. A realistic prompt may combine an application requirement with object creation, authorization, and operational impact. After answering, identify the first incorrect assumption in your reasoning. That habit is more valuable than merely counting correct responses on unofficial practice material.
If a topic remains uncertain, return to the official documentation and narrow the question. “I do not understand security” is too broad; “which authority is relevant to this action on this object?” is answerable. Keep the corrected explanation in your own words and note the manual used to verify it.
What should you do next?
First, decide whether your objective is historical knowledge or a current credential. If it is a current credential, use IBM’s certification information to identify the replacement path rather than attempting to schedule C2090-320. If it is historical knowledge, download or browse the Db2 11 for z/OS documentation and study against the archived objectives.
Second, assess your baseline against IBM’s recommendation of entry-level DB2 11 experience and basic SQL knowledge. A gap in either area should change your plan: refresh SQL and relational fundamentals first, or spend time with administration and object concepts before tackling detailed documentation.
Third, create the scope sheet and allocate the earliest focused study block to planning, which IBM assigned 17% of the exam objectives. Continue with SQL and XML at 14% of the exam objectives, operations at 14% of the exam objectives, and security at 8% of the exam objectives, while covering the additional objective areas described by IBM.
Finally, verify every time-sensitive decision on an official IBM page. The old exam’s question count, passing requirement, time allowance, withdrawal, expiration, and any historical delivery information should remain clearly labeled as historical. Do not convert an archived guide into a promise of present availability.
Official source boundaries
The IBM certification page is the authority for the historical exam title, exam code, audience, recommended experience, objective descriptions, published allocations, historical format, withdrawal, and expiration. The Db2 11 documentation pages are the authority for the version 11 product documentation and its manual structure. IBM’s Db2 tutorials page is useful for general learning-resource context, but it does not restore the withdrawn exam.
Because the product has reached end of support and the certification has expired, source discipline matters more than usual. Use the archived material to understand what the exam validated, distinguish old facts from current options, and confirm any replacement through IBM before making a scheduling or purchasing decision.
Conclusion
DB2 11 Fundamentals for z/OS remains useful as a historical map of entry-level Db2 for z/OS knowledge, but it is not a current certification route according to IBM’s supplied information. Study its domains through the official Db2 11 manuals, give planning deliberate attention, and test your understanding with scenarios rather than memorized answers. For a live credential decision, verify the successor and its current requirements directly with IBM before proceeding.
