C2090-737
DB2 9 System Administrator for z/OS -
DB2 9 System Administrator for z/OS Exam Guide
Exam C2090-737 is identified by IBM’s certification roadmap as the IBM Certified System Administrator DB2 9 for z/OS credential. It is aimed at professionals responsible for administering a DB2 9.1 subsystem and related operational work, although the supplied official sources do not provide a current exam blueprint, delivery format, duration, scoring method, or domain weights. This guide helps you make a practical decision: whether to pursue a historical DB2 9 credential, how to validate its availability, and how to prepare from authoritative DB2 9 administration material rather than relying on unsupported exam claims.
What credential does this exam identify?
IBM’s October 2014 DB2 for z/OS certification roadmap identifies “IBM Certified System Administrator DB2 9 for z/OS” as Exam C2090-737. The roadmap places it alongside later system-administrator exams, including C2090-617 for DB2 10 and C2090-317 for DB2 11. The roadmap itself is historical, so confirm current availability before investing in a booking or study plan.
The credential is version-specific. IBM’s technical overview applies to IBM DB2 Version 9.1 for z/OS, program number 5635-DB2. That matters when selecting references: material for later Db2 releases may explain related administration concepts but should not automatically be treated as evidence of DB2 9 exam coverage.
The first decision is therefore administrative, not technical. Check with the current IBM certification or testing channel whether C2090-737 can still be scheduled, whether it has been retired or replaced, and which candidate policies apply. The supplied sources identify the exam and its historical roadmap listing, but they do not verify present-day registration status.
Who should consider this exam?
This exam is most relevant to a professional who administers DB2 9 for z/OS or needs to demonstrate knowledge of that release’s subsystem, database, security, recovery, utility, connectivity, and performance responsibilities. It is a poor fit if your only experience is with distributed DB2 products or if you need a current credential for a later z/OS release.
A useful candidate profile includes people who work with installation or migration planning, subsystem configuration, database objects, utilities, authorization, operational recovery, distributed access, stored procedures, and performance monitoring. Those areas are drawn from the organization of IBM’s DB2 9 information roadmap, which separates planning, installing and migrating, configuring, administering, security, performance, stored procedures, troubleshooting, and related resources.
Do not treat the credential as a substitute for current operational support. IBM states that support for DB2 for z/OS Version 9 was discontinued on June 27, 2014. If your goal is production administration today, compare this historical credential with the skills and certification path for the Db2 release actually used by your employer.
What does the available evidence say about measured skills?
The supplied official research does not include an exam objectives page, domain list, percentage blueprint, question count, time limit, passing score, languages, prerequisites, or delivery method. No responsible guide should invent those details. Prepare against the documented DB2 9 administration work areas, then verify the official candidate guide if IBM provides one for your booking route.
The IBM information roadmap presents a practical study map rather than an exam blueprint. Its DB2 9 material is organized around product overview, planning, installing and migrating, configuring, administering, developing, stored procedures, security, managing performance, troubleshooting, reference, and community resources. These headings can structure preparation, but they must not be presented as weighted exam domains.
Use the distinction actively. “Official requirement” means a condition confirmed by the current IBM registration or candidate documentation. “Preparation recommendation” means a study choice made because it improves coverage or exposes weak reasoning. The available sources support the exam code, credential name, DB2 9.1 context, documentation areas, and support history; they do not support a numerical exam blueprint.
How to handle missing blueprint weights
There are no verified blueprint percentages in the supplied research. Consequently, this guide does not assign percentages to administration, security, recovery, performance, or any other domain. If a current IBM exam guide supplies percentages, record each percentage together with its exact domain label and use those labels to allocate study time; do not compare bare percentages copied from an unofficial source.
Which official references should anchor preparation?
Start with IBM’s DB2 for z/OS Information Roadmap, then use the DB2 9 for z/OS Technical Overview to establish release context. The roadmap links to installation, configuration, administration, security, performance, troubleshooting, stored-procedure, and reference material. The technical overview introduces DB2 9 enhancements and supports assessing migration and the applicability of key capabilities.
Use the Program Directory when studying installation or migration decisions. IBM describes Program Directories as sources of information needed to install or migrate to a new product version, and the DB2 9 Program Directory provides SMP/E installation sample jobs and instructions. It is a procedural reference, not a replacement for understanding why a subsystem change is required.
Use the Performance Monitoring and Tuning Guide for performance topics. The roadmap describes it as helping administrators monitor a DB2 9 subsystem and tune system and application performance. For stored procedures, IBM’s listed Redbooks publication covers design, installation, management, and tuning. Select references by task instead of reading every available document from cover to cover.
The roadmap also lists material on distributed functions, dynamic SQL, internationalization, data sharing, utilities, and DB2 tools. These subjects are useful when your role includes them, but the supplied research does not establish that each item is tested or how heavily it is tested.
A practical reference hierarchy
Use the current IBM candidate documentation first for eligibility and booking facts. Use the DB2 9 roadmap to locate release-specific manuals. Use the technical overview for feature context, Program Directory material for installation procedures, and specialist references for performance, stored procedures, distributed functions, or data sharing. Keep a note beside each study topic identifying the exact source and whether it is an official requirement or your own preparation inference.
How should you assess readiness before studying?
Perform a task-based diagnostic before building a calendar. List the DB2 9 responsibilities you can explain from memory, the ones you can perform only with local procedures, and the ones you have never performed. Then test yourself with scenario prompts based on documentation—not recalled or leaked exam questions—to expose missing reasoning.
For each topic, answer four questions: what is the administrator trying to protect or improve; which DB2 or z/OS component is involved; what evidence would confirm the diagnosis; and what operational risk follows from the change? This approach is more useful than collecting definitions because system administration decisions usually depend on dependencies, sequence, and recovery consequences.
Your diagnostic should include at least these study lanes: installation and migration planning; subsystem configuration; database and object administration; authorization and security; utilities and operational maintenance; recovery and availability; distributed access; stored procedures; performance monitoring and tuning; and troubleshooting. These lanes reflect the subject areas visible in the IBM roadmap, while the exact exam scope still requires official confirmation.
What should the first study phase cover?
Begin with architecture and lifecycle context before memorizing commands or parameters. Establish how a DB2 9 subsystem is introduced, configured, maintained, and supported, then connect each administrative task to the relevant IBM manual. This sequence prevents isolated facts from replacing an understanding of dependencies between installation, configuration, security, recovery, and performance.
Read the DB2 9 technical overview for release orientation. Create a two-column note: “capability or change” and “administrative consequence.” For every capability you retain, write what must be planned, configured, monitored, secured, or validated. IBM describes the overview as useful for understanding new functions, assessing migration and applicability, and planning use of key capabilities.
Next, map the roadmap’s documentation sections to your work environment. If you have access to a DB2 9 system, identify the local procedures used for subsystem startup, object changes, utility execution, backup and recovery, authorization changes, and incident escalation. If you do not have access, study the official procedures and mark hands-on conclusions as unverified until you can validate them in a suitable environment.
How should you study installation, migration, and configuration?
Treat installation and migration as controlled operational processes, not as lists of SMP/E terms. Study prerequisites, supplied jobs, sequencing, customization points, validation, and rollback or recovery considerations from the relevant IBM documentation. The Program Directory is especially important for the installation sample jobs and instructions identified in the official roadmap.
Build a process sheet with these stages: plan the target state; identify required product and environment information; review supplied jobs and customization; execute in the documented order; validate the result; and record what would be restored or corrected if validation fails. Do not invent site-specific job names or parameter values when the source does not provide them.
For configuration study, connect each setting to its scope and operational effect. Ask whether it affects the subsystem, a database, an object, an application, a utility, or a client connection. Note dependencies and restart implications only when the DB2 9 reference confirms them. A confident but unverified assumption about configuration scope is a common source of preparation errors.
How should you approach administration, security, and utilities?
Study administration as a set of ownership and control decisions: who can perform an action, which object or subsystem is affected, how the action is issued, and how its result is checked. Pair security reading with ordinary administration so that authorization is understood in context rather than memorized as disconnected terminology.
Create a permissions matrix using documented roles or privileges from your references. For each operation, record the actor, target, required authority, expected effect, and evidence of completion. Keep conceptual authorization separate from local enterprise policy; a workplace convention is not automatically a DB2 9 product requirement.
For utilities, trace purpose, input, output, resource impact, and post-operation validation. Include utility-related material from the DB2 Utilities Suite references listed by IBM, but avoid turning an unverified list of utility names into assumed exam coverage. The useful question is whether you can choose and validate an operational action for a stated administrative problem.
Include security failure scenarios in review: an authorized action against the wrong object, an incomplete change, an operation that affects availability, or a result that was not checked. Explain the prevention and verification step using the documentation. This develops judgment without implying access to live exam questions.
How should you prepare for recovery, availability, and troubleshooting?
Recovery preparation should connect protection, failure diagnosis, restoration, and validation. Study the DB2 9 documentation that applies to your environment, then write incident decision trees: identify the symptom, preserve useful evidence, determine the affected scope, choose the documented response, and confirm service and data integrity afterward.
Availability topics should be tied to the architecture you actually need to understand. The roadmap includes resources on data sharing, Parallel Sysplex, coupling facilities, log analysis, and high availability. Those references are valuable for candidates whose roles include shared or highly available environments, but the supplied sources do not establish a separate exam weighting for any of them.
For troubleshooting, do not stop at naming an error category. Explain what evidence would distinguish configuration, authorization, utility, connectivity, application, and performance causes. IBM’s roadmap also points to APARs, technotes, and support resources. Learn how those resources fit into an investigation, while recognizing that a historical product’s support position changes the practical usefulness of old support channels.
How should performance preparation differ from memorization?
Performance study should make you connect symptoms to measurements and controlled changes. IBM identifies the DB2 for z/OS Performance Monitoring and Tuning Guide as a resource for monitoring a DB2 9 subsystem and tuning system and application performance. Use it to build a measurement-first habit: establish the symptom, inspect relevant evidence, change one justified factor, and verify the result.
Keep separate notes for subsystem performance, application or query behavior, utility impact, buffer pool behavior, and distributed activity. The roadmap lists performance topics and a DB2 9 buffer pool monitoring and tuning reference. Use those materials to understand what is being measured and why a tuning action might help, not to memorize isolated recommendations detached from workload and evidence.
A strong review prompt is: “What would I measure before changing this?” Follow it with: “What result would support the change, and what side effect would I watch?” If you cannot answer those questions from the reference, mark the topic for another pass. Never use an unverified tuning claim as a universal rule.
When do stored procedures and distributed functions deserve study time?
Give stored procedures and distributed functions priority when they appear in your job responsibilities or when your diagnostic shows a major gap. IBM’s roadmap includes DB2 9 stored-procedure material covering design, installation, management, and tuning, as well as a Redbooks publication on configuring stored procedures. It also lists DB2 9 distributed-functions material covering DDF environments and distributed access.
Study the complete operational path rather than only development syntax. For stored procedures, trace design, installation, invocation, management, and tuning. For distributed functions, trace the environment, connection path, security boundary, workload effect, and troubleshooting evidence. This keeps the material relevant to a system administrator rather than turning it into a developer-only exercise.
Do not infer that a listed Redbooks title guarantees a question on every chapter. The official research confirms that IBM provides these resources and describes their purposes; it does not publish a chapter-by-chapter exam mapping.
What is a realistic study roadmap?
Use a staged roadmap that moves from scope validation to documentation, then from explanation to scenario practice. Adjust the pace to your experience and the result of your diagnostic. The sequence below is a preparation recommendation, not an IBM schedule, and it deliberately avoids unsupported claims about the exam’s duration, question count, score, or delivery.
Stage one: confirm the credential decision. Verify whether C2090-737 is available through the current IBM channel, identify the current candidate guide, and check whether your target role still uses DB2 9. Record any newly confirmed requirements separately from the historical information supplied here.
Stage two: build the reference map. Start with the information roadmap and technical overview. Add the Program Directory for installation and migration, administration and security manuals for operational control, performance references for monitoring and tuning, and specialist material only where your role or diagnostic warrants it.
Stage three: study by administrative workflow. Work through planning, installation or migration, configuration, routine administration, security, utilities, recovery and availability, distributed access, stored procedures, performance, and troubleshooting. For each lane, produce a one-page explanation, a dependency diagram, and a short list of validation checks.
Stage four: practise scenarios. Write your own prompts from the manuals, such as choosing the next diagnostic evidence, identifying an affected scope, planning a controlled configuration change, or explaining post-utility validation. Answer without looking at notes, then cite the paragraph or section that supports the answer. This is legitimate practice; it is not a substitute for the official exam objectives.
Stage five: close gaps and perform a readiness review. Revisit only the topics that produced incomplete explanations or unsupported assumptions. Confirm that you can distinguish DB2 9 material from later-release material, explain why a procedure is sequenced as documented, and identify what must be checked after an administrative action.
A compact weekly rhythm
A practical weekly rhythm is to read one defined topic, convert it into an operational diagram, answer scenario prompts, and review the source for corrections. End each session by recording one unresolved question and one action for the next session. This creates a visible evidence trail and reduces the temptation to measure progress by pages read alone.
Which preparation mistakes should you avoid?
The most damaging mistakes are treating a historical roadmap as current booking evidence, studying later DB2 releases as though they were DB2 9, memorizing commands without understanding scope, and accepting unofficial claims about exam format or content. Correct these by separating verified facts, source interpretation, and personal study recommendations in your notes.
Do not rely on exam dumps, leaked questions, or memorization as a passing strategy. They do not establish competence, may be inaccurate or unauthorized, and cannot replace the ability to reason through an administration scenario. Use official manuals and self-created prompts instead.
Avoid reading every linked resource equally. The roadmap is broad because it supports installation, administration, programming, troubleshooting, and related work. Prioritize the tasks in the credential’s system-administrator context and your own diagnostic, while checking any current official objective document before finalizing the allocation.
Do not confuse “I have seen the term” with “I can administer the feature.” A stronger readiness test asks whether you can explain purpose, prerequisites, authority, sequence, evidence, risk, and recovery for the task. If you cannot, return to the source and write the missing explanation.
What should you do before scheduling?
Before scheduling, verify the exam’s current status and candidate rules through the official IBM route. The supplied IBM roadmap is dated October 2014, while IBM’s product roadmap states that DB2 for z/OS Version 9 support ended on June 27, 2014. Those facts make a current availability check essential; they do not by themselves prove whether a booking is or is not possible today.
Confirm the exact exam identifier, credential name, accepted delivery arrangements, registration process, prerequisites, and any current candidate guide. None of those time-sensitive details should be taken from an old catalogue entry or an unofficial preparation page unless the current official source confirms them.
If the credential is unavailable, decide whether a later DB2 for z/OS system-administrator certification better matches your environment. IBM’s historical roadmap lists later exams C2090-617 and C2090-317, but the supplied research does not establish their present status or current requirements. Treat those identifiers as leads for verification, not as booking advice.
Once the administrative facts are confirmed, schedule only after your study evidence shows consistent reasoning across the relevant work areas. Keep your final review release-specific, source-based, and focused on decisions an administrator must make rather than on recalled question wording.
How can you use this guide with PassQueen responsibly?
Use PassQueen as a planning aid, not as evidence of current IBM policy or a source of guaranteed exam content. Compare any practice material with the official IBM candidate documentation and DB2 9 references. When a practice question gives a format, score, topic weight, or prerequisite, accept it only if the current official source confirms it.
A responsible review process has three checks: identify whether the statement is about the product or the exam; confirm the release; and locate the supporting IBM source. If a claim cannot pass those checks, label it unverified and do not let it determine your booking or study priorities.
Your final preparation package should contain the confirmed registration facts, a DB2 9 reference map, workflow notes, scenario answers with source citations, and a gap list. That package is more durable than a collection of unsupported predictions because it shows what you know, what remains uncertain, and what must be verified next.
Conclusion
C2090-737 is a historical IBM identifier for the IBM Certified System Administrator DB2 9 for z/OS credential, not a basis for assuming current availability or an undocumented exam format. Verify the credential first, then prepare from IBM’s DB2 9 roadmap, technical overview, Program Directory, and task-specific administration references. Study through operational decisions, evidence, dependencies, and validation checks. That approach keeps preparation honest while helping you decide whether this version-specific credential still serves your professional objective.