P2090-702 Exam Guide: Scope, Skills, and Preparation Roadmap
P2090-702 is presented here as the catalogue identifier for IBM Exam 702, the assessment associated with the IBM Certified Database Administrator—DB2 Universal Database V8.1 for z/OS certification. IBM describes Exam 702 as validating intermediate-to-advanced capability across database design and implementation, operation and recovery, security and auditing, performance, and installation and migration. This guide helps DB2 for z/OS practitioners decide whether their experience matches the exam, which domains deserve the most study time, whether the certification path is complete, and how to turn the official outline into a disciplined preparation plan.
What does P2090-702 represent?
The supplied IBM material identifies the assessment as Exam 702 rather than P2090-702. It associates Exam 702 with the IBM Certified Database Administrator—DB2 Universal Database V8.1 for z/OS certification. Treat P2090-702 as the catalogue label used for this page, but verify the current exam identity and registration details with IBM before scheduling because the supplied PDF describes an older certification context.
The distinction matters when searching for an outline, training course, or registration record. The official source does not establish that P2090-702 is a current IBM exam code, nor does it provide current availability, retirement, delivery, language, price, or scheduling information for that catalogue identifier. The evidence-supported subject is Exam 702 and its DB2 Universal Database V8.1 for z/OS administration scope.
The certification relationship
IBM states that the certification requires passing Exam 700 or Exam 512, plus Exam 702. Exam 702 should therefore be planned as one component of a certification route, not automatically treated as a complete standalone certification requirement. Confirm which prerequisite examination applies to your intended credential before booking any test.
Who should consider this exam?
Exam 702 is best matched to a database administrator who works with DB2 on z/OS and can reason about design, daily operation, recovery, security, performance, and installation or migration decisions. The outline describes intermediate-to-advanced skills, so a candidate should assess practical responsibility and troubleshooting judgment rather than rely on familiarity with product terminology alone.
The exam is less suitable as a first introduction to relational databases or z/OS administration. A newcomer may recognize many topic names while still lacking the operational context needed to select an appropriate action in a scenario. If your experience is concentrated in only one area, use the domain weights and the study diagnostic below to decide whether to build broader foundations before attempting the assessment.
A useful readiness test
Before choosing a date, write down how you would approach a design change, an operational failure, an access-control question, a performance complaint, and a migration task in a DB2 for z/OS environment. For each, identify the evidence you would collect, the decision you would make, and the risk you would control. Gaps in this exercise are more useful than a general confidence rating.
What skills does Exam 702 measure?
IBM groups Exam 702 into five domains: database design and implementation, operation and recovery, security and auditing, performance, and installation and migration on z/OS. The outline therefore tests a connected administrator’s perspective. Preparation should move from structural understanding to controlled operation, diagnosis, protection, and change management rather than treating every topic as an isolated list.
The domain allocation gives a practical way to prioritize revision. Performance and operation and recovery together account for the largest share of the blueprint, while security and auditing and installation and migration still require deliberate coverage. Do not interpret the percentages as a promise about the exact wording or order of questions; use them to distribute study effort.
Database design and implementation — 26 percent
The database design and implementation domain carries 26 percent of the exam breakdown. Study this area as a chain of decisions: how data is organized, how objects and relationships support application needs, how implementation choices affect maintainability, and how design choices create later operational or performance consequences.
A strong revision method is to take a representative application requirement and document the resulting database objects, integrity considerations, access patterns, and implementation trade-offs. Then review where the design could create contention, recovery complexity, or unnecessary administrative work. This connects design knowledge to the other four domains instead of memorizing definitions in isolation.
Operation and recovery — 28 percent
The operation and recovery domain carries 28 percent of the exam breakdown. Focus on how an administrator keeps a DB2 environment usable, recognizes failure conditions, protects recoverability, and chooses a controlled response. The key preparation question is not simply which command exists, but what sequence of actions preserves data integrity and returns service safely.
Build recovery notes around scenarios such as an unavailable object, an interrupted activity, a required restore, or a need to validate that recovery objectives can be met. For each scenario, separate diagnosis, containment, recovery, verification, and communication. This structure helps prevent a common mistake: jumping directly to a corrective action without establishing what has failed or what state the system is in.
Security and auditing — 10 percent
The security and auditing domain carries 10 percent of the exam breakdown. Its smaller allocation does not make it optional. Revise authorization reasoning, separation of responsibilities, protection of database resources, and the purpose of audit information. Be able to distinguish a user’s business need from the minimum privilege needed to perform a task.
Use access scenarios to test yourself. Ask who should receive access, at what scope, for what operation, and how the resulting activity would be reviewed. Avoid studying security as a collection of labels. The valuable skill is selecting a control that supports the required task without creating broad, unexplained access.
Performance — 31 percent
The performance domain carries 31 percent of the exam breakdown, the largest individual domain. Give it the deepest study block. Prepare to reason from symptoms and evidence: distinguish an access-path issue from resource pressure, contention, inefficient design, or an operational change, then identify what should be measured before proposing a remedy.
Create short diagnostic cases for yourself. Start with an observed symptom, list plausible causes, specify the evidence that would separate them, and rank possible interventions by risk. This is more effective than collecting isolated tuning tips because it trains the sequence an administrator needs when several explanations are possible. Keep performance work tied to workload, data design, system behavior, and change control.
Installation and migration — 5 percent
The installation and migration domain carries 5 percent of the exam breakdown. Although it is the smallest named domain, it can expose weak preparation because installation and change activities depend on planning, compatibility, dependencies, validation, and rollback thinking. Review the lifecycle of a controlled change rather than reducing the topic to installation vocabulary.
Prepare a migration checklist that covers prerequisites, affected objects and applications, backup or recovery considerations, test evidence, execution order, validation, and contingency planning. The checklist is a study aid, not a substitute for IBM’s current product documentation. It also reveals whether you understand how installation and migration decisions affect operation, recovery, security, and performance.
How should you allocate study time?
Use the official blueprint as a weighting signal, then adjust it for your own experience. Performance deserves the largest planned block because performance carries 31 percent of the exam breakdown; operation and recovery follows at 28 percent, and database design and implementation at 26 percent. Security and auditing and installation and migration remain required domains even though they carry 10 percent and 5 percent respectively.
A practical allocation is to begin with a diagnostic rather than copy the percentages mechanically. Someone who tunes DB2 daily may need more time on security or migration, while a design-focused practitioner may need additional operational and recovery practice. Keep a written record of missed concepts and revisit them through scenarios. Do not use the blueprint as evidence that any particular question will appear.
A four-pass study cycle
First, map your current work experience to all five domains and mark each topic as confident, familiar, or weak. Second, study the weak foundations while maintaining brief review of strong areas. Third, practise integrated scenarios that cross domain boundaries, such as a design decision that produces a performance symptom or a migration that requires recovery planning. Fourth, perform a final evidence check against the official outline and confirm the current administrative details with IBM.
This sequence avoids two inefficient extremes: spending all your time on your preferred subject and postponing weak areas until the end, or trying to memorize every possible term before understanding how an administrator makes decisions. Each pass should produce an artifact—an outline, a decision table, a scenario answer, or a corrected error log—that can be reviewed quickly later.
Which IBM preparation options are evidenced?
IBM lists several preparation options in the supplied Exam 702 PDF: SQL-Workshop, DB2 UDB for z/OS Database Administration Workshop—Part 1, DB2 UDB for z/OS Database Administration Workshop—Part 2, and DB2 UDB for z/OS/390 Application Performance and Tuning. IBM lists each of the three database administration or performance courses as a five-day preparation course where specified in the PDF.
Choose training according to your gap, not simply by collecting course titles. SQL-Workshop is a sensible foundation choice if SQL reasoning is weak. The database administration workshops fit candidates who need broader operational and implementation structure. Application Performance and Tuning is the most directly aligned option for a performance-heavy study plan, but it should complement—not replace—security, recovery, and migration revision.
The course listings are preparation guidance from the supplied official PDF, not a guarantee that a course is currently offered, unchanged, or sufficient by itself. Check IBM’s current training and certification information before making a purchase or arranging time away from work.
When formal training is worth considering
Formal training is most useful when you need a structured explanation of unfamiliar DB2 for z/OS administration areas, access to an instructor for difficult concepts, or a planned sequence that your work schedule will not provide. Self-study may be more efficient when you already perform the tasks and mainly need blueprint coverage, scenario practice, and disciplined review.
What delivery information can be confirmed?
The supplied IBM PDF states that IBM exams were offered worldwide at Prometric Testing Centers at the time of publication. That is historical information in the source, not confirmation of the current delivery arrangement for P2090-702 or Exam 702. Verify the active registration channel, test-center or remote options, locations, languages, identification rules, rescheduling terms, and available dates directly with IBM or the current authorized provider.
Do not schedule from an old PDF alone. The same caution applies to the exam’s current status, code, prerequisites, scoring policy, and any delivery change. The evidence supplied here confirms that Exam 702 had 61 questions and required a score of at least 55 percent to pass, but it does not establish that those details remain current for a present-day catalogue listing.
What the confirmed exam figures mean
IBM states that Exam 702 contains 61 questions and that a score of at least 55 percent is required to pass. Use these figures only for planning against the supplied Exam 702 document. They should not be converted into a guessed number of correct answers because scoring rules, question treatment, and the identity of the current exam could require confirmation.
How can you study without relying on dumps?
Use the official domain outline to create questions that require explanation and judgment. For each topic, ask what the administrator is trying to protect, what evidence is needed, what alternatives exist, and what validation follows the change. This produces transferable preparation and avoids dependence on unauthorized or unreliable material that may be inaccurate, outdated, or unrelated to the live assessment.
A useful study record has four columns: concept, operational purpose, evidence or signal, and administrator response. Add a fifth column for the reason an attractive alternative would be unsafe or incomplete. Reviewing that reasoning is more valuable than recognizing a memorized phrase, especially for domains such as performance and recovery where several actions can sound plausible without context.
Exam dumps, leaked questions, and answer memorization are not a dependable preparation method and cannot guarantee a pass. They can also train the wrong response if they contain errors or reflect a different version of the exam. Build competence from IBM’s outline, appropriate technical documentation, supervised practice, and your own corrected scenario work.
Scenario prompts to practise
For design and implementation, explain how a proposed data structure supports its application workload and what future administrative costs it introduces. For operation and recovery, state how you would establish the failure state before acting and how you would verify service afterward. For security and auditing, choose the narrowest access that satisfies a stated task and explain how activity is reviewed.
For performance, identify the measurements that distinguish competing causes before selecting a tuning action. For installation and migration, put preparation, execution, validation, and fallback activities in a defensible order. Write the answer in your own words, then check it against authoritative IBM material rather than a memorized answer set.
What mistakes commonly weaken preparation?
The most damaging mistake is treating the exam as five disconnected vocabulary lists. The blueprint describes an administrator who must connect design, operation, security, performance, and change decisions. Another mistake is allowing the largest domain to crowd out the smaller ones. A third is studying only from question-shaped material without learning why an answer is appropriate.
Correct these problems with deliberate constraints. Require every study note to include a purpose and a consequence. Schedule a short review for all five domains, even after focusing on performance. When reviewing a missed question or scenario, record the misunderstood principle rather than only the selected answer. Finally, separate old-source facts from current scheduling information so an outdated document does not drive a present-day booking decision.
Warning signs that you are not ready
You may need more preparation if you can define terms but cannot explain what evidence would guide an action; if you can discuss tuning but not recovery verification; if you know authorization concepts but cannot apply least-privilege reasoning; or if migration planning stops at installation. These gaps indicate decision weakness, not merely a need for more flashcards.
A practical study roadmap
A staged roadmap works best when each stage ends with a decision about readiness. Start by confirming that the current target is actually Exam 702 and that you understand the additional Exam 700 or Exam 512 requirement. Next, map your experience to the five domains, study the largest gaps, practise integrated scenarios, and finish with a source and scheduling check.
The roadmap below is intentionally activity-based rather than tied to an invented calendar. Set the length of each stage according to your background, access to a DB2 for z/OS environment, and the amount of material you must learn. The goal is measurable improvement: clearer explanations, better evidence selection, and safer sequencing of administrative actions.
Stage 1: confirm the target and baseline
Read the supplied IBM Exam 702 document and record its exact title, certification relationship, domains, question count, passing-score statement, and listed preparation options. Then check IBM for current information about the catalogue code, prerequisite route, exam status, delivery, and registration. Complete a five-domain self-assessment without consulting notes.
Your output should be a one-page baseline showing strengths, weak areas, unresolved administrative questions, and the evidence you will use to close each gap. If the current IBM listing differs from the supplied PDF, follow the current official information and revise your plan rather than assuming the older document controls.
Stage 2: build domain foundations
Study database design and implementation, operation and recovery, security and auditing, performance, and installation and migration in that order only if it matches your gaps; otherwise begin with the weakest domain. For every concept, write a short explanation of its purpose, the risk it addresses, and the administrator’s verification step. Use the official percentages to check that no domain has disappeared from your plan.
Keep performance and operation and recovery visible throughout this stage because they carry 31 percent and 28 percent of the exam breakdown respectively. Those numbers are domain-specific planning facts, not a reason to neglect the 26 percent database design and implementation domain or the smaller security and auditing and installation and migration domains.
Stage 3: connect the decisions
Move from isolated notes to cross-domain cases. Take a design change and ask how it affects access, recovery, and performance. Take a performance symptom and ask whether a recent implementation or migration decision could explain it. Take a security change and ask how it should be operated, audited, and validated. This practice builds the connected reasoning reflected in the exam scope.
After each case, compare your answer with authoritative product material and correct the explanation. Mark whether the error came from missing knowledge, confusing two similar controls, skipping evidence collection, or choosing an unsafe sequence. The category matters because each problem needs a different remedy.
Stage 4: rehearse and decide
Use timed practice only after you can explain the underlying concepts. Work through mixed-domain questions or scenarios, record uncertainty as well as incorrect answers, and revisit the relevant domain. The supplied PDF states that Exam 702 contains 61 questions and requires at least 55 percent to pass; use those official figures only as a reference for the Exam 702 document while confirming current details before scheduling.
A readiness decision should include more than a practice score. You should be able to explain why an answer is correct, identify the evidence behind it, and state what you would verify after acting. If one domain remains dependent on guessing, extend preparation instead of compensating with memorization from unauthorized sources.
Stage 5: complete the administrative check
Before booking, confirm the current exam code, certification path, prerequisite examination, delivery method, location or remote availability, language, price, dates, identification requirements, and rescheduling rules through the current IBM registration information. The supplied evidence does not establish present-day details for those items.
Keep a copy of the source and date you used for the booking decision. If the listing still refers to Exam 702 while your provider uses P2090-702, verify that the two identifiers refer to the same assessment before paying or reserving a seat.
Which IBM sources should you verify next?
Start with the official Exam 702 PDF because it supports the exam identity, certification relationship, skill domains, blueprint weights, question count, passing-score statement, and preparation-course listings used in this guide. Use current IBM certification or registration information for anything time-sensitive. The other supplied IBM support pages are general support resources and should not be treated as evidence of Exam 702 delivery or scoring.
The supplied Fix Central page is relevant when an administrator needs IBM support resources for identifying fixes, but it is not an Exam 702 blueprint. The IBM Security Bulletins page is a source for checking security information, not proof of a particular exam topic list. The AIX FLRT page likewise should not be used to infer DB2 for z/OS exam requirements. Keep product-support research separate from certification-verification research.
A disciplined source-checking habit
For every fact in your plan, label it as one of three types: official exam requirement, official blueprint information, or practical recommendation. A requirement such as the additional Exam 700 or Exam 512 route needs IBM confirmation. A recommendation such as writing recovery decision tables is your study method. Keeping those categories separate prevents useful advice from being mistaken for an IBM rule.
What should you do now?
First, verify whether your intended booking is Exam 702 or a current assessment represented by P2090-702. Second, confirm whether you still need Exam 700 or Exam 512 for the certification route. Third, perform the five-domain baseline and give priority to the areas where you cannot explain evidence, sequence, and verification. Only after those checks should you choose training, set a study schedule, and investigate current delivery details.
Use the official blueprint to keep preparation balanced: performance is 31 percent of the exam breakdown, operation and recovery is 28 percent, database design and implementation is 26 percent, security and auditing is 10 percent, and installation and migration is 5 percent. Treat those figures as supported planning guidance for Exam 702, not as a substitute for confirming the current exam listing.
Conclusion
The strongest preparation decision is not whether to memorize more material; it is whether your DB2 for z/OS knowledge supports safe, evidence-led administration across all five Exam 702 domains. Confirm the P2090-702 and Exam 702 identifiers, check the additional certification requirement, use the blueprint to expose neglected areas, and practise explaining why an administrative response is appropriate. IBM’s supplied PDF provides the core historical exam facts, while current IBM registration information must settle present-day status and delivery questions.
