P2090-702 Exam Guide: Scope, Skills, and a Practical Preparation Plan
P2090-702 refers to IBM Exam 702 in the supplied certification catalogue context. IBM describes Exam 702 as an assessment for intermediate-to-advanced DB2 Universal Database V8.1 for z/OS administration skills, including design, recovery, security, performance, and migration. It supports the IBM Certified Database Administrator—DB2 Universal Database V8.1 for z/OS certification, which also requires Exam 700 or Exam 512. This guide helps candidates decide whether their experience matches the exam, which domains deserve the most study time, and how to build a focused preparation sequence from the official outline.
What does Exam 702 validate?
Exam 702 validates the practical knowledge needed to administer DB2 Universal Database V8.1 for z/OS across the database life cycle. The official outline covers database design and implementation, operation and recovery, security and auditing, performance, and installation and migration. It is therefore better suited to administrators who can connect configuration choices with operational consequences than to candidates studying SQL in isolation.
The assessment is associated with the IBM Certified Database Administrator—DB2 Universal Database V8.1 for z/OS certification. IBM states that the certification requires passing Exam 700 or Exam 512, plus Exam 702. Treat Exam 702 as one part of the certification path, not as a standalone substitute for the other required examination.
The wording of the official material is specific to DB2 Universal Database V8.1 for z/OS. Candidates should confirm that this historical product and certification scope matches the requirement from their employer or certification plan before investing in preparation. Do not assume that familiarity with a newer DB2 release automatically maps to every behavior represented in this exam.
Who should take this exam?
The strongest candidates are database administrators, system programmers, and technical specialists who already understand DB2 on z/OS and need to demonstrate administration competence. The exam’s intermediate-to-advanced scope favors people who can reason through design, recovery, authorization, tuning, and migration decisions rather than recall isolated terminology.
A candidate with mainly application-development experience should first test whether they can explain administrative outcomes: how object design affects access and maintenance, how recovery choices affect availability, how security controls are audited, and how performance symptoms are investigated. If those topics are unfamiliar, begin with structured DB2 administration training before attempting question practice.
Candidates who administer another database platform can use their existing knowledge as a foundation, but should not rely on cross-platform analogies. DB2 for z/OS has its own operational concepts, utilities, recovery model, security integration, and performance considerations. Build a comparison list that identifies where your previous platform knowledge is useful and where it could create misleading assumptions.
How is the exam weighted?
Study time should follow IBM’s domain breakdown, with extra attention to performance and operation because together they represent the largest share of the outline. Use the percentages as a planning signal, not as permission to ignore the smaller domains: installation and migration accounts for less of the assessment but can still expose a clear knowledge gap.
The exam breakdown assigns 31 percent to performance. This is the largest named domain, so preparation should include diagnosis and tuning logic rather than only definitions of performance terms.
The exam breakdown assigns 28 percent to operation and recovery. Review the administrative decisions that protect data, support restart or recovery, and keep routine operations controlled.
The exam breakdown assigns 26 percent to database design and implementation. This domain deserves substantial study because design decisions influence access paths, maintenance, storage, and later tuning work.
The exam breakdown assigns 10 percent to security and auditing. Cover authorization, control objectives, auditing concepts, and the relationship between secure administration and operational accountability.
The exam breakdown assigns 5 percent to installation and migration. Learn the sequence, dependencies, and risk controls involved in introducing or moving DB2 components, while avoiding the mistake of treating this smaller domain as optional.
These figures are from IBM’s official Exam 702 outline: https://public.dhe.ibm.com/software/data/education/exam-702.pdf. Keep each percentage attached to its domain when building a study plan so that notes and progress reports remain meaningful.
What are the official exam facts?
IBM states that Exam 702 contains 61 questions and that a score of at least 55 percent is required to pass. Those facts help candidates understand the assessment’s published structure, but they do not justify aiming only for the minimum. A stronger target is consistent reasoning across every domain, including the topics that carry smaller weights.
The official PDF states that IBM exams were offered worldwide at Prometric Testing Centers at the time of publication. Because that delivery statement is explicitly historical, it should not be treated as confirmation of current availability, registration procedure, location, or delivery mode. Verify present scheduling information through IBM’s current certification channels before making travel or booking decisions.
The supplied evidence does not establish a current exam price, duration, language list, retirement status, registration workflow, or present testing provider. Do not rely on third-party listings for those details without checking IBM. The official PDF remains the source for the published Exam 702 facts used in this guide.
Which topics should you study first?
Start with performance and operation and recovery, then connect them to design. This sequence reflects both the published weighting and the way administration decisions interact: a design choice can create a performance symptom, while operational and recovery choices determine how safely the system can be changed or restored.
For performance, organize study around a troubleshooting chain. Begin with the observed symptom, identify the relevant workload or resource, separate likely causes from evidence, and select a corrective action whose side effects you can explain. Practice distinguishing design-related problems from configuration, access, concurrency, or operational causes rather than memorizing a single remedy for each symptom.
For operation and recovery, build a procedure-oriented set of notes. Record the purpose of each administrative activity, the conditions under which it is used, what it protects, and what must be checked afterward. Recovery knowledge is more useful when you can explain both the recovery objective and the operational trade-off involved.
For database design and implementation, study relationships between object choices, data access, maintenance, and future change. Draw small design examples and annotate why a particular choice would help or constrain administration. This makes the domain practical and reduces dependence on disconnected vocabulary lists.
For security and auditing, map each control to the risk it addresses and the evidence an administrator or auditor would expect to see. Review authorization as an operating process, not merely as a list of privileges.
For installation and migration, create a dependency-focused checklist. Include preparation, compatibility or prerequisite checks, implementation order, validation, and rollback or recovery considerations. The aim is to reason about a controlled change, not to memorize an undifferentiated sequence.
How should you use IBM’s preparation options?
IBM lists DB2 UDB for z/OS Database Administration Workshop—Part 1, DB2 UDB for z/OS Database Administration Workshop—Part 2, DB2 UDB for z/OS/390 Application Performance and Tuning, and SQL-Workshop as preparation options. Select among them according to your weakest domain and your access to a suitable lab or experienced instructor.
IBM lists DB2 UDB for z/OS Database Administration Workshop—Part 1 as a five-day preparation course and DB2 UDB for z/OS Database Administration Workshop—Part 2 as a five-day preparation course. These courses are most relevant when your administration fundamentals are incomplete or your experience is narrow. Do not schedule training simply because it is listed; first compare its subject coverage with your diagnostic results.
IBM lists DB2 UDB for z/OS/390 Application Performance and Tuning as a five-day preparation course. It is the most directly aligned listed option for a candidate whose performance knowledge is weaker than their general administration knowledge.
IBM also lists SQL-Workshop as a preparation option. Use it to strengthen SQL foundations where needed, but do not let SQL syntax study displace the administration domains that make up the Exam 702 outline.
The course names and durations above come from IBM’s official PDF: https://public.dhe.ibm.com/software/data/education/exam-702.pdf. The PDF does not establish current course availability, delivery format, price, or scheduling, so verify those details before enrolling.
What is a sensible study roadmap?
Use a diagnostic-first roadmap rather than reading every topic at the same depth. Establish your baseline, close the largest domain gaps, integrate the subjects through operational scenarios, and finish with timed review based on your own error patterns. This approach gives you a reason for each study activity and a clear decision point before scheduling.
Phase one: establish scope and baseline. Read the official Exam 702 outline and write down the five domains with their labels and weights. Then attempt representative, legitimate practice questions or create your own scenario prompts from documentation. Record whether each error came from missing knowledge, confusing two concepts, misreading the scenario, or changing an answer without evidence.
Phase two: repair the foundation. Study database design and implementation alongside operation and recovery. For every topic, produce a short explanation, an administrative example, a common consequence of getting it wrong, and a verification step. If you cannot explain the consequence or verification step, the topic is not yet secure.
Phase three: concentrate on performance. Work through symptom-to-cause reasoning. For each scenario, state what information you would inspect, which hypotheses remain plausible, and why the proposed corrective action is appropriate. This is more valuable than collecting lists of tuning tips without conditions.
Phase four: cover security, auditing, installation, and migration deliberately. Their smaller weights make them easy to postpone, so put them on fixed study sessions. Use checklists and contrasts: authorized versus unauthorised activity, planned change versus recovery action, and installation prerequisite versus post-change validation.
Phase five: integrate and review. Mix domains in a single session so that you must identify whether a scenario is primarily a design, operational, security, performance, or migration problem. Revisit only the errors and uncertain areas that your records identify. Before scheduling, confirm that you can explain the core reasoning without relying on memorized answer patterns.
How can you study with limited system access?
Limited access to a z/OS DB2 environment does not eliminate useful preparation, but it changes the emphasis. Use official technical documentation and course material to build decision maps, then test your understanding with scenario explanations, command or utility purpose summaries, recovery sequences, and design trade-offs. Be explicit about which procedures you have studied conceptually rather than performed.
Create a study notebook with five sections matching the official domains. For each entry, include the problem being addressed, the objects or components involved, the expected administrative decision, the evidence that would confirm success, and the risk of an incorrect action. This format turns passive reading into a repeatable reasoning exercise.
When documentation differs by release or environment, label the version and platform context in your notes. Exam 702 is identified in IBM’s material as DB2 Universal Database V8.1 for z/OS, so avoid silently replacing older product-specific behavior with assumptions drawn from a different platform or release.
A lab, where legitimately available, should be used to verify concepts rather than to chase supposed exam questions. Focus on observing cause and effect: make a controlled design or configuration change, inspect the result, and document what changed. Do not use leaked questions or exam dumps; they do not establish understanding and cannot guarantee a passing result.
Which preparation mistakes should you avoid?
The most damaging mistakes are studying by topic popularity, treating SQL as the entire exam, and confusing recognition with operational judgment. Correct those habits by following the official domain weights, linking every concept to an administrative decision, and reviewing why an answer is correct rather than merely whether it matches a key.
Ignoring performance because it feels familiar is risky: the performance domain carries 31 percent of the exam breakdown. Experienced administrators can still have gaps in diagnosis, measurement, or trade-off analysis, especially when their daily environment hides the underlying DB2 mechanisms.
Over-focusing on performance is also a mistake. The operation and recovery domain carries 28 percent, and database design and implementation carries 26 percent. Keep those domain labels attached to the percentages and maintain working knowledge of security, auditing, installation, and migration.
Studying only certification summaries can leave important reasoning gaps. Use the official outline to define scope, then expand each heading into procedures, consequences, and validation checks. Conversely, reading broad product documentation without an outline can consume time on material that is not central to the assessment.
Booking too early creates avoidable pressure. First use a baseline and a second mixed-domain review to identify persistent weaknesses. Schedule only after confirming the current delivery and registration details through IBM, since the supplied historical PDF does not prove that its Prometric statement remains current.
What should you do next?
Begin by confirming that the IBM Certified Database Administrator—DB2 Universal Database V8.1 for z/OS path is the requirement you actually need, including the additional Exam 700 or Exam 512 requirement. Then download and read IBM’s Exam 702 material, map your experience against its five domains, and choose training or self-study based on the largest verified gap.
Use this action list: identify your weaker domain; build a domain-labelled study schedule; reserve dedicated sessions for performance and operation and recovery; create scenario-based notes for design, security, and migration; track every error by cause; and verify current registration details before scheduling. Keep the official PDF available as your reference for the published exam facts.
The IBM source used for the exam scope, certification relationship, preparation options, question count, pass requirement, domain breakdown, and historical delivery statement is https://public.dhe.ibm.com/software/data/education/exam-702.pdf. The other supplied IBM support pages concern Fix Central, security bulletins, or AIX support and do not add verified Exam 702 requirements, so they should not be used to infer current exam rules.
Conclusion
Exam 702 preparation is most effective when treated as an administration decision exercise rather than a vocabulary test. Anchor the plan to IBM’s five domains, give performance, operation and recovery, and database design and implementation the depth their published weights warrant, and use security, auditing, installation, and migration as deliberate checkpoints. Confirm the certification combination and current scheduling information from IBM before committing to the exam.
