IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1: Exam Guide and Preparation Roadmap
This upgrade credential was designed to validate intermediate-to-advanced administration skills for DB2 10.5 instances and databases, with emphasis on new DB2 10.5 features and functionality rather than a complete retest of DB2 10.1 administration. It served administrators already certified on DB2 10.1. The most important decision today is not which study plan to follow, but whether you need historical preparation material or a currently schedulable IBM credential: IBM states that this certification was withdrawn on July 31, 2022, and expired on March 31, 2023.
Should you schedule this exam now?
You should not treat Exam C2090-311 as a currently available certification target without first confirming its status with IBM. The supplied IBM 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.
IBM lists the credential code as 08002108, identifies 08002107 as the credential it replaced, and lists no replacement credential. Those facts make this page useful for historical study, migration planning, and understanding an older certification path, but they do not establish a current exam appointment, delivery method, price, language, duration, or passing score.
Use the official IBM certification page as the status check before making a purchase or study commitment. Do not assume that an old exam code, a third-party listing, or a collection of practice questions represents a live IBM registration option.
What the upgrade exam was intended to validate
The exam was aimed at administrators who already understood DB2 10.1 and needed to demonstrate their knowledge of DB2 10.5 changes. IBM describes the certification as covering intermediate-to-advanced day-to-day administration skills for DB2 10.5 instances and databases, while explicitly stating that the upgrade exam covers only new features and functionality in DB2 10.5 for Linux, UNIX, and Windows.
That scope changes how you should study the material. A candidate preparing for a full administrator exam might begin with installation, security, backup, recovery, monitoring, SQL, and routine maintenance across the entire product. For this upgrade exam, those subjects are the baseline. Your principal task is to identify what changed in DB2 10.5, understand the operational consequence, and decide how an administrator should apply or manage the change.
The exam therefore rewarded release-delta thinking: what is new, what is changed, what is discontinued, what must be checked before an upgrade, and how a new capability affects configuration or daily administration. Memorizing isolated feature names is less useful than connecting each feature to a deployment, workload, or upgrade decision.
Who was eligible for the upgrade route?
IBM states that candidates had to hold the DB2 10.1 DBA for Linux, UNIX, and Windows certification to qualify for the upgrade exam. This was not presented as a general substitute for the foundational or full administrator route.
IBM’s certification roadmap identifies the upgrade exam as C2090-311. The roadmap also states that C2090-311 had to be taken together with either C2090-730 or with C2090-610, C2090-611, and C2090-311 as applicable to the certification path. Because the credential is no longer current, treat that roadmap as historical path information and verify any present-day IBM requirements independently.
If you are studying the material without holding the former prerequisite certification, use the preparation guide as a technical learning resource rather than assuming that it creates eligibility for a current credential. Separate two questions in your notes: “Can I understand and perform this DB2 10.5 task?” and “Can I register for the historical certification?” The supplied evidence answers the first through technical documentation, but the second is affected by withdrawal and expiry.
Which skills should your study plan measure?
The supplied IBM preparation guide identifies several DB2 10.5 subjects that should become practical checkpoints in your study plan: analytic-workload database configuration, parallel processing for column-organized tables, default table organization, space reclamation, workload concurrency management, and IBM Data Studio.
These topics are better used as capability tests than as a list to read once. For analytic workloads, explain which configuration choices support the workload and what operational trade-offs need review. For column-organized tables, explain the role of parallel processing and how it affects execution or resource planning. For default table organization, identify the administrative consequence of the default and when an explicit design decision is preferable.
For space reclamation, be able to describe the problem being addressed, the conditions that make reclamation useful, and the checks an administrator should perform before applying it. For workload concurrency management, connect the feature to competing workloads, resource controls, and predictable service. For IBM Data Studio, focus on which administrative tasks it can support and how it relates to the older Control Center workflow.
No domain percentages are provided in the supplied official research. Do not create a weighted blueprint or compare unlabeled percentages; instead, allocate study time according to your baseline knowledge, the preparation-guide topics, and the operational risk of each subject.
Turn each topic into an observable task
Write one task for every topic and complete it without copying a definition. Examples include designing a small analytic-workload configuration, explaining a column-organized parallel-processing choice, identifying a table-organization default, planning a space-reclamation check, resolving a concurrency conflict, and locating an equivalent administrative workflow in IBM Data Studio.
A useful answer should include the purpose of the feature, prerequisites or restrictions, the administrator’s decision, and a validation step. If your notes contain only terminology, they are not yet testing administration competence.
How should you sequence the official material?
Start with the IBM preparation guide to establish the release-specific subject list, then use the DB2 10.5 upgrade roadmap and server upgrade documentation to test those subjects against a complete upgrade process. This sequence prevents a common mistake: studying new features without understanding where they fit into planning, installation, instance work, database work, and post-upgrade validation.
Use a four-pass method. In the first pass, mark every DB2 10.5 feature or changed behavior that is new to you. In the second, group each item by administrative action: assess, configure, migrate, validate, monitor, or troubleshoot. In the third, build a lab or written scenario around each group. In the fourth, close the documentation and explain the sequence from memory, then reopen the source to correct omissions.
The roadmap identifies the Upgrading to DB2 Version 10.5 guide as the first point of reference for learning how to upgrade each component and create an upgrade plan. It identifies DB2 servers, DB2 clients, database applications, and routines as components that may require attention. Your study notes should therefore include dependencies beyond the database server itself.
Suggested study sequence
First, establish the starting point: DB2 10.1 administration concepts, the target DB2 10.5 environment, operating-system and hardware checks, and the supported upgrade path. Next, study changes in existing functionality and discontinued or deprecated functionality. Then cover the preparation-guide feature set. Finish with troubleshooting, post-upgrade validation, and a complete written runbook.
This order mirrors the decisions an administrator makes. It also exposes gaps earlier: a candidate who cannot identify a supported starting point or an affected client should not move directly to advanced feature configuration.
What does a real DB2 10.1-to-10.5 upgrade involve?
A real upgrade requires more than installing a new DB2 copy. IBM documents DB2 10.1 as a supported direct upgrade source for DB2 10.5, subject to the documented path and restrictions. On Linux and UNIX, the procedure requires DB2 10.5 to be installed in a new path and existing instances and databases to be upgraded manually.
The Linux and UNIX procedure also requires root access before beginning the DB2 10.5 server upgrade and instructs administrators to install DB2 add-on products that were present in the DB2 copy being upgraded. These details should appear in your runbook as gates, not footnotes.
For a DB2 10.1 multiple-partition environment, IBM lists supported 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. Do not infer that every source configuration can use every target. Record the environment topology first, then consult the supported-upgrade-path documentation for the exact route.
Build a component inventory before studying commands
List the DB2 server copy, instances, databases, members or partitions, clients, applications, routines, add-on products, operating system, hardware, and administrative tools. The roadmap specifically says that upgrading the environment might require upgrading these components.
This inventory gives every study item a place in the upgrade plan. It also helps distinguish a server procedure from a client or application procedure, preventing the mistake of treating a successful server installation as proof that the entire environment is ready.
Use a test environment to expose the plan’s weak points
IBM recommends upgrading DB2 servers, clients, database applications, and routines in a test environment. The roadmap says that testing can reveal issues, help evaluate the impact of DB2 10.5 changes, and determine the time and disk space required for an upgrade plan.
For preparation, reproduce the sequence in a controlled environment or create a detailed simulation if the original platform is unavailable. Record prerequisites, commands, expected checkpoints, errors, rollback implications, and post-upgrade evidence. A test that ends immediately after installation is incomplete; include client connections, application behavior, routines, and representative workload checks.
Which compatibility and retirement issues deserve attention?
Review changed, deprecated, and discontinued functionality before memorizing new features. IBM’s roadmap directs administrators to examine changes in existing functionality, discontinue functionality unsupported in DB2 10.5, and review version-specific summaries. It also records that Query Patroller was discontinued and that Control Center tools and related wizards were discontinued in Version 10.1.
IBM identifies IBM Data Studio and IBM InfoSphere Optim tools as recommended tools for tasks previously performed with Control Center, with a mapping available in the roadmap. This matters both for the exam’s tool-related coverage and for practical preparation: learn the administrative outcome of a task, not only the name of an older interface.
A further warning applies to upgrades using RESTORE DATABASE. IBM states that database_memory, appl_memory, or both database configuration parameters, when updated individually on a member or database partition, might change during a database upgrade that uses the RESTORE DATABASE command. Treat parameter preservation and post-upgrade verification as explicit checklist items rather than assuming that every configuration value remains unchanged.
Common mistakes in this area
The first mistake is studying only additions and ignoring removals. The second is assuming that an old tool remains the preferred operational interface. The third is treating configuration behavior as theoretical instead of verifying it after the chosen upgrade method. The fourth is copying a migration sequence from a different topology without checking restrictions.
Correct these errors by maintaining a change-impact table with four columns: feature or function, release status, affected component, and administrator action. Add a validation query, log review, or application test where the documentation indicates a possible operational effect.
How should you use IBM documentation during preparation?
Use the official material as a cross-referenced set rather than relying on one PDF. The preparation guide supplies the exam-oriented topic list. The upgrade roadmap organizes prerequisites, planning, upgrading, troubleshooting, education, and additional resources. The DB2 10.5 documentation supplies procedural detail, including platform-specific server steps and supported upgrade paths.
When two sources serve different purposes, keep both roles clear. The certification page describes the credential and its historical eligibility. The preparation guide tells you what to study. The upgrade documentation tells you how to investigate and perform technical work. The roadmap points you to related client, application, routine, known-issue, and discontinued-functionality material.
IBM states that the DB2 Information Center documentation was updated more frequently than the PDF or hardcopy books. For technical procedures, use the current official documentation available through the supplied IBM links rather than treating an archived preparation document as the final authority for every operational detail.
A practical note-taking format
For each topic, record: the DB2 10.1 baseline, the DB2 10.5 change, the affected component, prerequisites, the administrator’s action, a validation method, and a known risk. Add the exact IBM document location beside the note.
This format forces you to distinguish release knowledge from procedure knowledge. It also makes revision faster because you can review decisions and checks instead of rereading entire documents.
What should a four-stage study roadmap look like?
Use four stages: confirm status and baseline, map the upgrade, practise DB2 10.5 changes, and perform a readiness review. The stages are deliberately practical. They help you decide whether you are learning for an active credential, a historical exam objective, or an actual DB2 10.1-to-10.5 migration.
Stage one is a short orientation. Confirm the certification’s historical status, identify your DB2 10.1 experience, and inventory the environment you can access. Read the preparation guide’s topic list and label each subject as known, partly known, or unknown. Do not spend study time on a full DB2 10.1 review unless your baseline is weak; the upgrade exam’s stated scope was DB2 10.5 new features and functionality.
Stage two is upgrade planning. Read the roadmap, document operating-system and hardware prerequisites, verify the source and target topology, and create separate plans for servers, clients, applications, and routines. Add pre-upgrade, upgrade, and post-upgrade tasks for each component, as IBM recommends. Include known-issue and APAR research in the planning stage.
Stage three is applied feature study. Work through analytic-workload configuration, column-organized parallel processing, table organization, space reclamation, workload concurrency management, and IBM Data Studio. For every item, produce a short design decision and a validation procedure. Then connect the item to an upgrade scenario: what changes, who owns the task, and what evidence proves that it worked.
Stage four is readiness review. Rehearse the complete runbook without relying on copied steps. Explain supported paths, Linux and UNIX installation-path implications, root access, add-on products, discontinued functionality, and the configuration caveat associated with RESTORE DATABASE. Review troubleshooting resources, including the db2ckupgrade log identified in the roadmap, APAR information, known issues, and diagnostic information when DIAGLEVEL is set to 3 or higher.
How to decide whether you are ready
You are closer to readiness when you can answer scenario questions in sequence rather than by recognition. Given a DB2 10.1 environment, identify prerequisites, choose a documented path, name affected components, explain the DB2 10.5 change, select a validation step, and identify what could require troubleshooting.
If you cannot explain why a step is required, mark it for review. If you can recite a feature but cannot identify its workload or operational consequence, move it back to applied study. If your plan has no post-upgrade checks, it is not ready for a production-style exercise.
How should you handle troubleshooting and rollback assumptions?
Treat troubleshooting as part of the upgrade design, not as an afterthought. IBM’s roadmap directs administrators to search existing technotes for known issues and describes upgrade-error information in the log file specified when db2ckupgrade is issued. It also notes that diagnostic information is captured when DIAGLEVEL is set to 3 or higher.
The roadmap states that there is no utility to fall back to a previous release after upgrading DB2 servers. That makes pre-upgrade backups, test execution, compatibility review, and a separately designed recovery strategy important study points. Do not describe rollback as an automatic reversal of the server upgrade.
Build a troubleshooting matrix with symptom, evidence to collect, likely component, source document, and next action. Include server, client, application, routine, and database categories. Review APARs and known issues related to DB2 10.5 upgrades, using IBM’s roadmap and the fix-list reference. Avoid relying on exam dumps or leaked questions: they cannot replace the product documentation needed to reason through an upgrade incident.
What delivery details are actually evidenced?
The supplied official research identifies the historical exam code C2090-311 and credential code 08002108, but it does not establish a current delivery provider, testing-center or online format, question count, duration, language list, price, passing score, or rescheduling policy. Because IBM states that the certification was withdrawn and expired, do not publish or rely on unverified delivery details.
Before taking any action, check IBM’s official certification page for current status and any replacement path. If no active listing exists, redirect your effort toward current IBM credentials or toward technical DB2 upgrade competence, depending on your goal. A third-party page cannot override the official status information.
What should you do next?
First, verify whether you need a live credential or a historical DB2 10.5 upgrade study reference. Second, open the official preparation guide and create the topic checklist. Third, build an environment inventory and an upgrade runbook from the roadmap. Finally, validate every technical decision against the DB2 10.5 documentation, especially supported paths, platform procedures, discontinued functionality, and post-upgrade checks.
If your goal is a real migration, begin with a test environment and document the evidence required before production approval. If your goal is certification research, record the withdrawal and expiry status prominently and do not assume that C2090-311 can be scheduled. In either case, use the material to develop repeatable administration decisions rather than memorized answers.
Conclusion
This historical upgrade exam was designed for certified DB2 10.1 administrators moving toward DB2 10.5 knowledge, with emphasis on new functionality and day-to-day administration. Its most useful preparation lessons remain practical: map the full environment, verify the supported path, test servers and dependent components, study release changes and discontinued functions, and rehearse validation and troubleshooting. However, IBM’s stated withdrawal and expiry dates mean that candidates must confirm the current IBM certification landscape before treating this exam as a scheduling target.
