DB2 9 System Administrator for z/OS: Exam C2090-737 Study Guide
Exam C2090-737 is the exam associated with IBM Certified System Administrator DB2 9 for z/OS in IBM’s certification roadmap. Its intended audience is therefore administrators and experienced DB2 for z/OS practitioners who need to organize their knowledge around installation, configuration, administration, performance, security, troubleshooting, and related operational work. The practical decision is whether this legacy credential still matches your goal, and, if it does, how to prepare from the surviving IBM documentation without relying on unsupported exam claims or question dumps.
What does Exam C2090-737 represent?
IBM’s certification roadmap identifies “IBM Certified System Administrator DB2 9 for z/OS” as Exam C2090-737. The roadmap is dated October 2014 and places the credential alongside later system-administrator exams for DB2 10 and DB2 11. That establishes the exam’s identity and product version, but the supplied official material does not provide a current exam page, objective list, scoring model, or blueprint. (https://public.dhe.ibm.com/software/data/sw-library/education/cert-roadmaps/DB2_for_zOS.pdf)
Treat the exam title as a scope signal rather than a complete syllabus. A system administrator for DB2 9 for z/OS would be expected to work across the operational areas represented in IBM’s DB2 9 documentation roadmap, including planning, installation and migration, configuration, administration, security, performance management, troubleshooting, and supporting functions such as stored procedures and distributed access. These are preparation areas supported by the documentation structure, not verified percentage-weighted exam domains. (https://www.ibm.com/support/pages/db2-zos-information-roadmap)
The credential should not be confused with a general SQL developer examination. The available evidence points toward administration of a DB2 subsystem and its surrounding z/OS operating environment: planning a release, installing or migrating it, configuring resources, controlling access, monitoring behavior, and resolving operational problems. The exact boundary between tested and untested subjects is not available in the supplied research.
Is this a sensible exam choice now?
Check the credential’s present availability with IBM before investing in a study plan. IBM states that support for DB2 for z/OS Version 9 was discontinued on June 27, 2014, while the certification roadmap carrying C2090-737 is dated October 2014. Those facts make the exam historically documented, but they do not establish that registration or delivery remains available today. (https://www.ibm.com/support/pages/db2-zos-information-roadmap)
The important distinction is between product support and exam availability. The end of DB2 9 support is an official product-lifecycle fact; it is not, by itself, a published statement that the certification exam was retired, cancelled, or still offered. Do not infer a registration deadline, testing-center status, online delivery option, fee, language, duration, or passing score from the roadmap.
Use a simple decision rule. If your employer, contract, or personal record specifically requires the historical DB2 9 credential and IBM confirms a route to take it, proceed with targeted preparation. If your goal is current production administration, ask whether a later DB2 for z/OS credential or current-version training better reflects your environment. The roadmap lists later system-administrator exams C2090-617 for DB2 10 and C2090-317 for DB2 11, but the supplied source does not establish their current availability either. (https://public.dhe.ibm.com/software/data/sw-library/education/cert-roadmaps/DB2_for_zOS.pdf)
Who should use this guide?
This guide is most useful for a DB2 for z/OS administrator, systems programmer, database specialist, or technically experienced operator who must study a legacy DB2 9 administration body of knowledge. It is less suitable as a first introduction to relational databases because the official material assumes a product-documentation ecosystem rather than presenting a beginner curriculum.
Candidates with hands-on access to a DB2 9 subsystem can connect documentation to subsystem parameters, utilities, authorization rules, logs, and performance observations. Candidates without an environment can still study effectively, but should replace practical execution with command-flow diagrams, job-control analysis, parameter tables, failure scenarios, and written explanations of why an administrative action is safe or unsafe.
Application developers should first decide whether the role they are targeting is administration. IBM’s roadmap separately organizes development, stored procedures, distributed functions, and enterprise-application material. Those subjects may intersect with administration, but reading every related publication without a role-based plan can consume time without improving operational judgment. (https://www.ibm.com/support/pages/db2-zos-information-roadmap)
What skills should preparation measure?
Because the supplied official research contains no C2090-737 objective matrix or domain percentages, measure readiness by demonstrated tasks rather than invented weights. You should be able to explain an administrative decision, identify the relevant IBM manual, distinguish planning from execution, predict dependencies and risks, and diagnose a symptom using evidence instead of selecting a memorized phrase.
Build a personal skills matrix around the documentation areas IBM exposes for DB2 9 for z/OS: planning; installing and migrating; configuring; administering; security; managing performance; troubleshooting; and specialized operational topics. The roadmap describes itself as an information resource for installation, administration, and programming, and its navigation separates these product activities. It is a sound research index, not proof of exam weighting. (https://www.ibm.com/support/pages/db2-zos-information-roadmap)
For each area, record four levels: can define the terminology, can explain relationships, can choose an action in a scenario, and can verify the result. The final two levels matter most for administration. For example, knowing that a buffer pool affects access behavior is weaker than explaining which observations would justify a change and what side effects should be monitored afterward.
Do not publish or trust a percentage-based plan unless IBM provides an official blueprint that names the domains. If a later source supplies weights, keep each percentage attached to its exact official domain label. The current supplied evidence contains no verified percentages for C2090-737, so this guide deliberately does not manufacture them.
How should you sequence the IBM documentation?
Start with the DB2 9 for z/OS Technical Overview to establish the product’s major capabilities and the reasons an administrator might encounter them. IBM describes this Redbooks publication as an introduction to DB2 9 enhancements that supports understanding new functions, assessing migration and applicability, and planning how to exploit key capabilities. (https://www.redbooks.ibm.com/redbooks/pdfs/sg247330.pdf)
Move next to planning and installation material. The IBM roadmap links to Program Directories for DB2 Version 9.1 for z/OS and related components, and explains that Program Directories provide information needed to install or migrate a product. The supplied facts specifically describe the DB2 9 Program Directory as containing SMP/E installation sample jobs and instructions. Read it for dependencies, installation flow, and the difference between sample material and a site’s approved implementation. (https://www.ibm.com/support/pages/db2-zos-information-roadmap)
Then study the operational manuals in the order an administrator uses them: configuration and administration first, security alongside authorization-related work, performance monitoring and tuning after you understand normal operation, and troubleshooting after you know which evidence each component produces. Finish with specialist subjects that appear relevant to your target role, such as stored procedures, distributed functions, data sharing, internationalization, and utility operation.
Use the roadmap as a map to the surviving DB2 9 publications. IBM states that DB2 for z/OS Version 9 publications were available in HTML through the installable information center and in PDF and BookManager formats through the IBM Publications Center. Availability of an archived publication does not guarantee that every linked resource remains accessible, so save permitted copies and record the document title and version as you study. (https://www.ibm.com/support/pages/db2-zos-information-roadmap)
A practical reading method
Do not read each manual from the first page to the last. For every topic, answer five questions in your notes: what problem does the function solve, what prerequisites does it have, what objects or subsystem resources does it affect, how is success verified, and what evidence indicates failure? This turns reference reading into operational recall.
Create one page per subject with terminology, dependencies, actions, verification, and failure indicators. Add the exact manual or section location beside each note. When two documents describe the same function from different angles, keep both links: one may explain setup while the other explains monitoring or recovery.
What should the installation and migration study block cover?
Installation and migration preparation should focus on sequencing and dependencies, not on memorizing isolated job names. Use the Program Directory and related installation documentation to understand SMP/E samples, prerequisites, supplied components, customization decisions, and the evidence needed before moving to the next stage. The official roadmap identifies these resources as part of DB2 9 planning and installation. (https://www.ibm.com/support/pages/db2-zos-information-roadmap)
Practice separating three questions that are often confused: what must be prepared in z/OS, what must be installed into the product libraries, and what must be configured in the DB2 subsystem. For each question, identify inputs, outputs, ownership, and rollback or recovery considerations. This distinction helps with scenario questions in which an apparently correct action is performed at the wrong stage.
Migration study should include compatibility reasoning. IBM’s Technical Overview is specifically positioned to help readers assess migration and the applicability of new functions. Read new-feature descriptions with two filters: what changes existing administration, and what requires an explicit decision before adoption? Avoid assuming that a feature described in an overview is automatically enabled, appropriate for every workload, or safe to introduce without testing. (https://www.redbooks.ibm.com/redbooks/pdfs/sg247330.pdf)
A common mistake is to treat sample JCL as a universal production procedure. Sample jobs are valuable evidence of IBM’s expected installation mechanics, but local naming conventions, security controls, storage standards, change procedures, and subsystem topology can alter the implementation. Study the purpose and prerequisites of each step rather than memorizing text that may not match a real site.
How do you study daily administration and configuration?
Organize administration notes by lifecycle: create or alter resources, make them available, monitor them, protect them, back them up or recover them, and retire or change them safely. Include the relationship between DB2 objects, subsystem resources, utilities, logs, and z/OS facilities. This lifecycle view is more useful than a glossary because it forces you to explain what happens before and after an administrative command.
For every configuration topic, write a before-and-after record. State the initial condition, the parameter or resource being changed, the activation requirement, the expected effect, and the verification method. If the documentation does not establish whether a change is online, deferred, or disruptive, mark that point for direct confirmation in the manual instead of guessing.
Include operational boundaries in your notes. Ask which actions require elevated authorization, which actions affect applications, which actions can consume substantial system resources, and which actions need coordination with storage, security, or operations teams. These questions turn configuration knowledge into administrator judgment without claiming a specific exam question or test-day scenario.
The IBM roadmap includes administration, configuration, troubleshooting, and reference resources as separate navigation areas. Use that separation to cross-check your understanding: an administration procedure tells you how to act, while a reference or troubleshooting section may explain messages, restrictions, or diagnostic evidence. (https://www.ibm.com/support/pages/db2-zos-information-roadmap)
How should performance and troubleshooting be prepared?
Study performance as an evidence chain: symptom, measurement, likely causes, controlled change, and validation. 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 learn what is measured and how observations support a decision, not merely to collect tuning vocabulary. (https://www.ibm.com/support/pages/db2-zos-information-roadmap)
Give buffer pools a dedicated study pass. The IBM Redpaper on DB2 9 for z/OS buffer pool monitoring and tuning describes buffer pool functions, read and write performance metrics, setup and monitoring considerations, and tuning recommendations. Build exercises that require you to interpret a metric, propose a change, state the risk, and define the follow-up measurement. (https://www.ibm.com/support/pages/db2-zos-information-roadmap)
For troubleshooting, create symptom cards for unavailable resources, authorization failures, poor application performance, utility problems, distributed-access issues, and logging or recovery concerns. Each card should contain the first evidence to collect, the component that owns that evidence, the safest initial action, and the conditions under which escalation is appropriate.
Avoid the tuning mistake of changing several variables at once. If buffer pool settings, SQL access paths, utility scheduling, and application behavior are all changed together, the result cannot show which intervention helped. A better study exercise is to isolate one hypothesis, state what result would disprove it, and document the observation that follows.
Performance material may include application and workload considerations, not only subsystem parameters. The roadmap lists material on performance topics, buffer pools, query optimization, dynamic SQL, and data sharing. Use these resources to understand interactions, while keeping the exam boundary conservative because no official C2090-737 domain list was supplied. (https://www.ibm.com/support/pages/db2-zos-information-roadmap)
Which specialist subjects deserve targeted review?
Add specialist subjects only after the core administrative cycle is secure. Stored procedures, distributed functions, data sharing, internationalization, utilities, and enterprise applications can matter to an administrator, but their relevance depends on the role and environment. Use the IBM roadmap to select topics connected to your target work instead of attempting to memorize every linked publication. (https://www.ibm.com/support/pages/db2-zos-information-roadmap)
Stored procedures are a useful example of cross-functional administration. IBM describes DB2 9 for z/OS Stored Procedures: Through the CALL and Beyond as helping readers design, install, manage, and tune stored procedures. Study the operational boundary: deployment, runtime dependencies, authorization, diagnostics, and performance. Do not reduce the subject to application coding alone. (https://www.ibm.com/support/pages/db2-zos-information-roadmap)
Distributed access deserves a similar treatment. The listed DB2 9 for z/OS: Distributed Functions publication covers setting up a DDF environment, deploying DDF capabilities in different configurations, and developing applications that access distributed databases. For administrator preparation, concentrate on configuration choices, connectivity dependencies, security implications, and evidence used when remote access fails. (https://www.ibm.com/support/pages/db2-zos-information-roadmap)
Data sharing and Parallel Sysplex topics should be studied when your target role includes them. The roadmap points to material on Sysplex data sharing and high availability, while its support resources include coupling-facility information. Keep the concepts connected to operational decisions: coordination, availability, monitoring, and failure handling. Do not infer that every data-sharing detail is a tested C2090-737 objective.
Internationalization is worth reviewing when systems handle multiple encodings or Unicode. IBM’s Internationalization Guide is described as covering international data, character conversion, Unicode, and communication with subsystems using different encoding schemes. Prepare to explain where conversion can occur and why an administrator must identify encoding assumptions before diagnosing corrupted or unexpected data. (https://www.ibm.com/support/pages/db2-zos-information-roadmap)
How should security and recovery fit into the plan?
Treat security as an operating discipline rather than a final vocabulary chapter. For each administrative capability, identify the authority needed, the object or subsystem affected, the least-privilege alternative, and the audit or verification evidence. The supplied roadmap explicitly includes security within DB2 9 documentation, but it does not provide the exam’s detailed security objectives or weights. (https://www.ibm.com/support/pages/db2-zos-information-roadmap)
Recovery preparation should connect logs, utilities, data integrity, and availability. Write scenario answers that distinguish prevention, detection, recovery, and post-recovery validation. When the documentation gives multiple recovery paths, compare their prerequisites and operational consequences rather than memorizing a single preferred sequence.
A frequent mistake is to study authorization statements without studying the failure they prevent. Pair each permission concept with a realistic administrative decision: who should perform it, what access is needed, what would happen if access is too broad, and how the result can be checked. This makes security knowledge useful in both scenario reasoning and real change review.
The IBM roadmap also points to a DB2 Log Analysis Tool for z/OS, described as supporting high availability and control over data integrity. Treat that listing as a resource lead, not as evidence that the tool is required for the exam or available in a particular environment. (https://www.ibm.com/support/pages/db2-zos-information-roadmap)
What is a practical six-stage study roadmap?
A staged plan works better than alternating randomly between manuals. Begin with product orientation, then build installation and configuration knowledge, add daily administration and security, develop performance and troubleshooting judgment, review specialist subjects, and finish with closed-book scenario practice. Adjust the pace to your experience and to the availability of the historical exam.
Stage one: establish the product map. Read the Technical Overview selectively and create a one-page diagram of the subsystem, databases and objects, utilities, logs, applications, distributed connections, and z/OS dependencies. Mark every term that you cannot explain in your own words. Use the official roadmap to locate the corresponding DB2 9 publication. (https://www.redbooks.ibm.com/redbooks/pdfs/sg247330.pdf)
Stage two: reconstruct installation and migration. Read the Program Directory and installation links. Produce a dependency checklist, a sequence diagram, and a table separating IBM-supplied samples from local site decisions. Test yourself by explaining what information must be known before each phase and how an administrator verifies completion. (https://www.ibm.com/support/pages/db2-zos-information-roadmap)
Stage three: build the administration and security matrix. For each configuration or administrative function, record prerequisites, authority, affected resources, activation behavior, verification, and failure evidence. Add recovery and change-control questions. Review the same topic from administration, security, and troubleshooting perspectives so that your notes describe both the action and its consequences.
Stage four: practice performance diagnosis. Use the Performance Monitoring and Tuning Guide and buffer pool material to create short cases. For each case, identify the observation, formulate one hypothesis, select the next measurement, propose a controlled change, and define success. Include application behavior and workload context rather than blaming every symptom on a subsystem parameter. (https://www.ibm.com/support/pages/db2-zos-information-roadmap)
Stage five: select specialist coverage. Choose stored procedures, distributed functions, data sharing, internationalization, utilities, or enterprise applications according to your target responsibilities. For every selected topic, write a short explanation of its administrative dependencies and a failure path. Drop topics that are not relevant until your core areas are reliable.
Stage six: conduct readiness reviews. Close the manuals and answer your own scenario prompts. A strong answer names the affected component, the evidence to collect, the authority or prerequisite, the safest next action, and the verification step. Reopen the source only after committing to an answer. Track weak concepts by subject, not by a vague overall confidence score.
A weekly study rhythm
Use three complementary sessions: source reading, retrieval practice, and operational synthesis. Source reading supplies accurate terminology; retrieval practice exposes gaps; synthesis makes you explain relationships. Keep a change log for your notes so that unsupported assumptions are removed rather than repeated until they feel familiar.
Reserve the final review period for high-friction subjects: topics you repeatedly confuse, procedures with many prerequisites, and diagnostic paths where several components can produce similar symptoms. Do not spend the final sessions collecting more material indiscriminately. Consolidate, cross-reference, and rehearse decisions.
Which preparation mistakes should you avoid?
The most serious mistake is trusting an unofficial outline, dump, or claim that supplies exact question counts, domains, scores, or current registration details without an IBM source. None of those facts is present in the supplied official research. Use unofficial material, if at all, only as a prompt for a concept you can verify in IBM documentation, never as evidence of the live exam.
Do not assume that a historical product version makes old documentation self-explanatory. Record the exact product and publication context, distinguish DB2 9 concepts from later-version behavior, and confirm every version-sensitive statement against an IBM DB2 9 source. The Technical Overview applies to IBM DB2 Version 9.1 for z/OS, program number 5635-DB2, and its first edition was published in June 2007. (https://www.redbooks.ibm.com/redbooks/pdfs/sg247330.pdf)
Do not memorize command syntax without learning prerequisites and outcomes. An administrator must know what a command changes, what can block it, what evidence confirms success, and what recovery or rollback considerations apply. Syntax drills are useful only after the operational meaning is clear.
Do not confuse a documentation index with a guaranteed exam blueprint. The IBM roadmap is valuable because it organizes information resources, but the supplied facts do not say that every linked manual is tested or that the navigation headings are official C2090-737 domains. Keep a separate list of verified facts and working study assumptions.
Do not mistake historical availability for current support. IBM states that Version 9 support was discontinued on June 27, 2014. That should influence your decision to verify the exam’s current registration path and to consider whether a later credential better serves a current-role objective. (https://www.ibm.com/support/pages/db2-zos-information-roadmap)
What should you verify before scheduling?
Before scheduling, confirm the exam code, credential name, registration path, delivery method, available locations or online options, fee, language, time limit, scoring rules, prerequisites, and current status directly with IBM or the authorized testing channel. The supplied official sources verify the historical exam identity but do not verify these current operational details.
Check the date and context of any page you find. The roadmap listing is dated October 2014, and IBM’s product roadmap states that DB2 9 support ended on June 27, 2014. A page that still displays the exam name may be archival. Do not treat an accessible PDF as proof that an appointment can be booked.
Ask your manager or certification coordinator what outcome is actually required. A historical credential may be needed for a formal record, while a current-version qualification may be more useful for job performance. If the requirement is contractual, obtain the exact credential and exam code in writing before substituting a later examination.
Once IBM confirms that scheduling is possible, align your final review with the confirmed official objectives. If IBM cannot confirm availability, stop short of purchasing preparation products or planning around an assumed exam date. Continue studying the DB2 9 administration knowledge only if it supports a documented work or migration need.
How can you use the official sources efficiently?
Use the IBM DB2 for z/OS Information Roadmap as the index, the Technical Overview as the product-level orientation, and the Program Directory and manuals as procedural references. This division prevents a common research failure: expecting one overview book to teach installation, day-to-day administration, security, performance diagnosis, and troubleshooting in equal depth. (https://www.ibm.com/support/pages/db2-zos-information-roadmap)
The roadmap includes links to product documentation, Program Directories, performance resources, troubleshooting material, stored-procedure references, distributed-functions publications, and related tools. Open only the resources that answer a question in your skills matrix. Note the publication title, product version, and the decision or procedure it supports.
Use the Technical Overview for “why” questions: what DB2 9 introduced, which capabilities may affect migration, and where a feature fits. Use the installation and administration manuals for “how” questions. Use performance and troubleshooting resources for “what evidence” questions. This three-way classification makes review faster and exposes missing reasoning.
Keep source boundaries visible in your notes. An IBM product description can establish what a tool is intended to do; it does not establish that the tool is required in an exam or installed at your workplace. A Redbooks publication can provide practical technical context; it does not, by itself, prove an exam objective or weighting.
IBM also identifies archived publication formats, including HTML in the installable information center and PDF and BookManager formats through the IBM Publications Center. Preserve the bibliographic details of whatever version you use so that a later statement can be checked against the correct DB2 9 material. (https://www.ibm.com/support/pages/db2-zos-information-roadmap)
What is the next action after reading this guide?
First, verify whether C2090-737 can still be scheduled and whether it is the credential your employer or target role actually requires. Second, download or locate the IBM DB2 9 documentation identified in the roadmap. Third, create the skills matrix and mark each topic as verified, needs practice, or not yet researched. Only then should you choose a study schedule or buy any preparation resource.
If the exam is confirmed, make your first study deliverable a product map and your second an installation-and-administration dependency table. Follow those with performance diagnosis exercises and selected specialist topics. If the exam cannot be confirmed, retain the same study work as operational DB2 9 knowledge, but do not describe an unverified appointment, retirement decision, score, or delivery arrangement as fact.
A credible readiness signal is not the number of pages read. It is the ability to explain an administrative choice from prerequisite through verification, cite the IBM source that supports it, identify what remains uncertain, and adapt the procedure to the stated environment. That standard protects both exam preparation and production decision-making.
Conclusion
C2090-737 is historically identified by IBM as the system-administrator exam for DB2 9 for z/OS, but the supplied official research does not provide a current blueprint or current scheduling details. Confirm availability first. If the credential remains relevant and obtainable, prepare through IBM’s DB2 9 documentation: build from product orientation to installation, administration, security, performance, troubleshooting, and role-specific specialist topics. Measure yourself with evidence-based scenarios, keep official facts separate from assumptions, and avoid unsupported claims or memorized exam material.
