IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1: Exam and Preparation Guide
Exam C2090-311 was designed to validate an experienced DB2 10.1 administrator’s understanding of new DB2 10.5 features and day-to-day administration for Linux, UNIX, and Windows. It was an upgrade credential rather than a replacement for the underlying DB2 10.1 DBA certification. The most important decision for a candidate now is not which study plan to follow, but whether the credential can still be pursued: IBM states that the certification was withdrawn on July 31, 2022, and expired on March 31, 2023. The guide below remains useful for historical knowledge, migration planning, and skills assessment.
Should you schedule this exam now?
No. IBM’s certification page states that the IBM Certified Database Administrator – DB2 10.5 DBA for LUW Upgrade from DB2 10.1 certification was withdrawn on July 31, 2022, and expired on March 31, 2023. Treat Exam C2090-311 as a retired historical exam, not as a currently schedulable certification target. Verify IBM’s current certification catalogue before committing time or payment to any successor credential.
The IBM credential code was 08002108. IBM lists 08002107 as the credential replaced by this certification and lists no replacement credential on the referenced certification page. That absence should not be interpreted as evidence that a newer DB2 exam exists; it is simply the status reported by the supplied source.
For a current career objective, use this guide to identify the DB2 administration and upgrade subjects worth retaining, then compare those subjects with IBM’s current certification offerings. For a historical project, internal skills review, or legacy DB2 migration, the original preparation material still provides a useful technical reading sequence.
What the upgrade credential was intended to validate
The credential targeted intermediate-to-advanced, day-to-day administration skills for DB2 10.5 instances and databases. Its defining scope was new features and functionality introduced in DB2 10.5 for Linux, UNIX, and Windows, so preparation should have concentrated on release changes rather than repeating the complete DB2 10.1 administrator syllabus.
The intended candidate
IBM required candidates to hold the DB2 10.1 DBA for Linux, UNIX, and Windows certification to qualify for the upgrade exam. IBM also states that administrators should have experience working with DB2 LUW Version 9 or Version 10.1. A reader without that background would need foundational DB2 administration study before approaching the upgrade topics.
The certification roadmap identifies the exam as C2090-311. It states that C2090-311 had to be taken together with either C2090-730 or C2090-610, C2090-611, and C2090-311 as applicable to the certification path. Because the credential is retired, confirm any current IBM pathway independently rather than assuming this historical combination remains active.
What is not established by the supplied evidence
The supplied official research does not provide a current delivery method, testing location, language list, duration, question count, passing score, price, or blueprint percentages. Do not rely on third-party claims for those details, and do not infer them from another IBM exam. The practical delivery decision is therefore to check IBM’s current catalogue first; for this credential, the stated withdrawal and expiry make scheduling unavailable according to the supplied source.
Which DB2 10.5 subjects deserve study time?
The official preparation guide points to release-specific capabilities rather than generic memorization. Build study around how a DB2 administrator would configure, operate, upgrade, and troubleshoot these capabilities. For every topic, connect the feature to a workload, an operational trade-off, and a verification step in a safe test environment.
Analytic workloads and column-organized processing
The preparation guide includes analytic-workload database configuration and parallel processing for column-organized tables. Study the purpose of these capabilities, the kind of workload they address, and the administrative decisions surrounding configuration and execution. A useful exercise is to explain why an analytic workload might require a different configuration approach from a conventional transaction-processing workload without assuming that one setting is universally better.
Storage and table organization
The guide includes default table organization and space reclamation. Prepare to reason about how table organization affects administration and how reclaimed space fits into an ongoing maintenance plan. When reviewing documentation, record the prerequisite conditions, the operational impact, and the evidence an administrator would inspect after the action. Avoid reducing the topic to a list of feature names.
Concurrency and administration tools
Workload concurrency management and IBM Data Studio are also named in the preparation guide. Study the administrative problem each addresses: controlling competing work in the first case and supporting database management tasks in the second. Since the Control Center tools and related wizards were discontinued in Version 10.1, include the documented transition toward IBM Data Studio and IBM InfoSphere Optim tools when reviewing older administration procedures.
Other documented DB2 10.5 changes
IBM’s upgrade roadmap highlights large row size support, allowing row length to exceed the maximum record length for a table-space page size. It also directs administrators to review changes in existing functionality, discontinued or deprecated functionality, and the fix list containing shipped APARs. Treat these as impact-analysis subjects: identify what changes, determine whether an environment uses the affected function, and document the corrective action.
How should you study the upgrade path itself?
Study the upgrade as an environment-wide change, not as a database-only installation. IBM’s roadmap separates DB2 servers, clients, database applications, and routines, and calls for prerequisites, pre-upgrade tasks, upgrade tasks, and post-upgrade tasks for each component. Your notes should mirror that structure so that dependencies and rollback concerns are visible.
Confirm the source and target topology
IBM documents DB2 Version 10.1 as a supported direct upgrade source for DB2 Version 10.5. For a DB2 10.1 multiple-partition environment, IBM lists paths to DB2 10.5 single-partition Enterprise Server Edition, multiple-partition DB2 10.5, and DB2 10.5 with the pureScale feature, subject to documented restrictions. Compare the documented path with your actual topology before studying procedure details.
Do not generalize a supported path into a universal design recommendation. Record the current edition, partition arrangement, operating system, clients, applications, routines, and add-on products. Then check the applicable restrictions and installation requirements in IBM’s supported-upgrade-path and roadmap documentation.
Plan prerequisites and compatibility checks
IBM’s roadmap requires administrators to verify the operating system and hardware requirements for DB2 Version 10.5. It also advises reviewing changes in existing functionality and discontinuing functionality unsupported in Version 10.5. If the source is DB2 Version 9.5 or earlier, IBM says an intermediate upgrade to Version 9.7 or Version 10.1 is required; that condition does not apply to the stated DB2 10.1 source, but it matters when comparing legacy environments.
Include APARs and known issues in the plan. IBM’s roadmap directs readers to search existing technotes for known issues and resolutions and identifies the DB2 10.5 fix list as a source for shipped APAR information. A strong study note links each issue to a symptom, affected component, diagnostic evidence, and documented remedy.
Understand the Linux and UNIX procedure
On Linux and UNIX, IBM’s procedure requires DB2 10.5 to be installed in a new path, followed by manual upgrades of existing instances and databases. The procedure also requires root access before beginning the server upgrade and instructs administrators to install DB2 add-on products that were present in the DB2 copy being upgraded.
Study this as a sequence with ownership boundaries: installation, instance handling, database handling, add-on products, validation, and application readiness. Do not assume that placing the new software on the host automatically upgrades every existing object. For Windows or other deployment arrangements, use the relevant IBM procedure rather than transferring Linux and UNIX steps unchanged.
Build a test-environment rehearsal
IBM recommends upgrading DB2 servers, clients, database applications, and routines in a test environment to discover issues and evaluate the impact of DB2 10.5 changes. The roadmap also says a test environment can help determine upgrade time and disk-space requirements. Rehearse with representative configuration, data shape, clients, routines, and workload behavior rather than a minimal installation.
Capture a before-and-after record: software and instance details, database configuration, storage capacity, application connectivity, routine behavior, diagnostic output, and performance observations. Include a recovery decision because IBM states that there is no utility to fall back to a previous release after upgrading DB2 servers.
What mistakes make preparation inefficient?
The most common preparation error is treating an upgrade exam as a general product exam. The second is reading feature summaries without practicing environment-impact analysis. A better approach is to start with the DB2 10.5 delta, then test each change against an upgrade plan, a supported topology, and a verification checklist.
Mistake: studying a retired exam as if it were active
Do not begin by purchasing dumps, booking a test, or trusting a third-party page that presents this credential as current. IBM’s supplied certification page gives the withdrawal and expiry status. Check IBM first, then decide whether your objective is historical preparation, practical DB2 10.5 knowledge, or a current replacement credential.
Mistake: memorizing feature labels without operational context
Knowing that column-organized tables, space reclamation, or workload concurrency management appear in the preparation guide is not enough. For each subject, write a short operational answer: what problem does it solve, what must be checked before using it, what changes during an upgrade, and how would you confirm the result? This method produces transferable administration knowledge without relying on leaked or memorized questions.
Mistake: ignoring clients, applications, and routines
An upgraded server can still expose compatibility problems in clients, database applications, or routines. IBM’s roadmap explicitly treats these as separate upgrade components. Add connection tests, routine checks, application regression tests, and post-upgrade validation to your rehearsal. A database-only checklist leaves important dependencies unexamined.
Mistake: overlooking configuration and discontinued functionality
The roadmap identifies changes in existing functionality and discontinued or deprecated functionality as upgrade concerns. It also warns that database_memory, appl_memory, or both may change during an upgrade using RESTORE DATABASE when they were updated individually on a member or database partition. Record configuration baselines and review the documented behavior instead of assuming every value survives unchanged.
A practical study roadmap for legacy DB2 10.5 work
Use a staged roadmap that moves from status verification to release knowledge, then to a controlled rehearsal. The objective is not to simulate unavailable exam questions; it is to develop a defensible upgrade decision and the ability to explain DB2 10.5 administration changes in concrete terms.
Stage 1: decide whether the objective is still valid
Read IBM’s certification page and record the credential code, eligibility history, withdrawal status, expiry status, and any stated replacement information. If you need a current certification, stop the historical exam plan and investigate IBM’s current catalogue. If you support a DB2 10.5 estate, continue with the technical roadmap independently of the retired credential.
Stage 2: establish the DB2 10.1 baseline
Document the source version, edition, partition layout, operating system, hardware, instances, databases, clients, applications, routines, add-on products, configuration values, and unsupported or deprecated functions in use. This baseline gives every DB2 10.5 reading a concrete application and exposes gaps that a feature-only study plan would miss.
Stage 3: read the preparation guide by capability
Use IBM’s Preparation Guide for DB2 10.5 DBA for LUW Upgrade from DB2 10.1 Exam 311 as the topic index. Create one page per named capability: analytic-workload configuration, parallel processing for column-organized tables, default table organization, space reclamation, workload concurrency management, and IBM Data Studio. Add the relevant DB2 documentation link, prerequisite, administration task, and validation method to each page.
Stage 4: execute the upgrade-planning sequence
Follow the roadmap’s component structure: prerequisites, pre-upgrade tasks, upgrade tasks, and post-upgrade tasks for servers, clients, applications, and routines. Check supported paths, operating system and hardware requirements, discontinued functionality, APARs, technotes, and add-on products. Keep an explicit no-fallback decision in the plan because the supplied roadmap states that server upgrades have no utility for returning to the previous release.
Stage 5: rehearse and close the gaps
Perform the work in a test environment, measure the resources required, and test representative applications and routines. When a result is unexpected, consult the IBM upgrade documentation, technotes, and diagnostic information rather than guessing. IBM notes that diagnostic information is captured when DIAGLEVEL is set to 3, the default value, or higher. Finish with a concise runbook that another administrator could review and execute.
Which official resources should anchor your notes?
Start with IBM’s preparation guide for the exam-topic boundary, then use the upgrade roadmap and server-upgrade documentation for procedures. Use the supported-upgrade-path page for topology decisions and the DB2 end-of-support page for lifecycle context. These sources are more reliable for legacy planning than undated summaries or third-party question collections.
Use the preparation guide as the topic index
The preparation guide is titled Preparation Guide for DB2 10.5 DBA for LUW Upgrade from DB2 10.1 Exam 311. It identifies the release-specific capabilities that should shape study notes. Read the feature topics alongside administration procedures so that each note answers both “what is new?” and “what does an administrator do with it?”
Use the roadmap as the project checklist
The IBM upgrade roadmap is the central planning source for prerequisites, component planning, unsupported functionality, testing, troubleshooting, and additional resources. It also points readers toward the Upgrading to DB2 Version 10.5 guide, IBM documentation, technotes, APAR information, and test-environment work.
Use procedure documentation for execution details
The Linux and UNIX server-upgrade procedure supplies concrete procedural constraints, including the new installation path, root access, manual instance and database upgrades, and installation of existing add-on products. The supported-path documentation should be consulted before applying those steps to a particular partitioned or pureScale environment.
Conclusion
This credential is no longer a live scheduling target: IBM reports withdrawal on July 31, 2022, and expiry on March 31, 2023. Its technical content still offers a disciplined way to review DB2 10.5 administration and legacy upgrade planning. First verify your current certification objective with IBM. If the goal is operational, baseline the DB2 10.1 environment, study the DB2 10.5 feature delta, rehearse every environment component in test, and document validation and recovery decisions before touching production.
