C2090-616 Exam Guide: What the Exam Covered and How to Plan Your Next Step
C2090-616 was IBM’s “DB2 11.1 Fundamentals for LUW” exam, associated with the entry-level Certified Database Associate—DB2 11.1 Fundamentals for LUW credential. Its blueprint tested planning, security, database objects, SQL, and core Db2 structures for people with entry-level Db2 11 experience and basic SQL knowledge. IBM states that the exam was withdrawn on July 31, 2022, and that the certification expired on March 31, 2023. The most important decision now is whether you need historical preparation material or a currently available IBM credential instead.
Is C2090-616 still available?
No. IBM marks C2090-616 as withdrawn and states that the associated certification was withdrawn on July 31, 2022 and expired on March 31, 2023. Treat this page as historical exam guidance, not as confirmation that you can book the exam or earn the former credential today.
Before investing in a study plan, verify the current IBM certification catalogue and the official IBM pages linked below. Do not assume that an old exam code has been replaced by a similarly named test, that an old voucher remains usable, or that a provider advertising C2090-616 can schedule an official attempt. Those decisions require current information from IBM, not a third-party practice-test listing.
The practical decision for candidates
If your employer, training record, or project specifically refers to C2090-616, use the blueprint to understand the Db2 knowledge it represented, then ask the sponsor whether a current credential is required. If you are studying Db2 for work rather than for the retired badge, the subject areas remain a useful way to organize fundamentals, but the former exam’s status should shape your time and budget decisions.
What did C2090-616 validate?
The exam validated foundational knowledge of Db2 for Linux, UNIX, and Windows through the title “DB2 11.1 Fundamentals for LUW.” IBM positioned the related certification at entry level for users of the DB2 for LUW product family, with recommended entry-level experience using DB2 11 and basic SQL knowledge.
This was not a narrow SQL syntax test. The published blueprint combined product and workload planning with access control, database and object administration, SQL work, and the behavior of tables, views, and indexes. A sensible preparation plan therefore connects concepts: for example, understand an object before studying how privileges on that object affect a user’s SQL operation.
Who was the intended learner?
The recommended starting point was someone who already had entry-level experience using DB2 11 and understood basic SQL. That profile points to a foundation-level candidate rather than a learner beginning with relational databases from zero. Candidates without that background should first build vocabulary around databases, schemas, tables, keys, queries, transactions, and authorization before attempting detailed blueprint review.
How was the exam structured?
IBM’s published details stated that C2090-616 had 63 questions, an allotted time of 90 minutes, and a passing requirement of 43 questions. These figures describe the historical exam and should not be used to infer the format or passing rule of any current IBM test.
The time information supports a disciplined practice habit: learn to identify the tested concept quickly, eliminate answers that conflict with Db2 fundamentals, and move on when a question is consuming disproportionate attention. Because the exam is withdrawn, there is no reason to plan around a live appointment until IBM confirms a current path.
What the numbers mean for study planning
The passing requirement was 43 questions, but it is a mistake to turn that figure into a target for memorizing isolated answers. A stronger preparation goal is reliable reasoning across the published domains. Practice should expose gaps in concepts and terminology, not imitate or seek leaked exam content. No dump can establish that a candidate understands authorization, object behavior, or transaction processing.
Which blueprint areas deserved the most attention?
The largest named allocation was planning at 21%, followed by working with DB2 data using SQL at 19%, security at 17%, working with databases and database objects at 16%, and DB2 tables, views, and indexes at 13%. Use those official domain labels whenever you prioritize study; a percentage without its domain is not useful guidance.
The five published allocations total 86%, so do not treat them as a complete reconstruction of every possible exam topic unless the official blueprint provides the remaining detail. They are still sufficient to establish a practical order: begin with planning and SQL, then connect security and object work, and finish by consolidating table, view, index, and trigger behavior.
Planning and Db2 capabilities — 21%
The planning domain allocated 21% and included DB2 products, DB2 Cloud offerings, workload characteristics, pureScale, BLU Acceleration, federation, and compatibility features. Prepare to distinguish what each capability or product concept is intended to address rather than memorizing names as unrelated terms.
Create a comparison sheet with one row per topic. For each row, write the problem or workload characteristic it addresses, the kind of environment in which it is relevant, and any important distinction from the other topics. Keep product claims tied to the official learning material; do not infer current service availability from this historical blueprint.
Working with DB2 data using SQL — 19%
The SQL domain allocated 19% and covered SELECT, data modification, transactions, stored procedures or user-defined functions, compatibility enhancements, and OLAP functions. Study these as connected operations: retrieve data, change data, control the unit of work, and understand how database-resident logic or analytical functions affect the result.
A useful exercise is to take one small relational scenario and write several kinds of statements against it. Explain what each statement reads or changes, when a transaction boundary matters, and what result shape an analytical function produces. Review the logic manually instead of relying only on whether a tool accepts the syntax.
Security — 17%
The security domain allocated 17% and included data-access restrictions, authorities, privileges, DCL statements, roles, and trusted contexts. The study objective is to separate broad administrative authority from permission to perform a particular operation on a particular object.
Build an authorization map for a fictional user and database object. Mark the user’s authorities, direct privileges, role-derived privileges, and any relevant trusted-context condition. Then explain which DCL statement or authorization concept changes each permission. This approach is more durable than memorizing a list of command names without understanding who can use them and why.
Working with databases and database objects — 16%
The database-and-object domain allocated 16% and covered connections, DB2 objects, DDL statements, and table types. Candidates should be able to place common objects in the database structure, recognize the purpose of DDL, and reason about what a connection represents in an application or administration scenario.
Draw a simple object map from a connection to a database, schema, and selected objects. Add the DDL operation that creates or changes each object in your study example. When reviewing an explanation, ask whether it describes structure definition, data manipulation, authorization, or transaction control; confusing those categories is a common source of wrong answers.
DB2 tables, views, and indexes — 13%
The tables, views, and indexes domain allocated 13% and included data types, object characteristics, temporary tables, and triggers. This domain rewards precise distinctions: a view is not the same kind of storage structure as a base table, an index serves a different purpose from a constraint, and a trigger represents a database event mechanism.
Use a decision table with columns for purpose, data held or referenced, lifetime, and effect on operations. Add temporary tables and triggers to the same comparison so that each term has a concrete place. Check every example against the official Db2 learning material rather than generalizing from another database platform.
Conclusion
C2090-616 is now a historical Db2 11.1 fundamentals exam, not a live credentialing option according to IBM’s published status. If you are researching it for legacy documentation, use the official blueprint to organize planning, SQL, security, database objects, and table-related concepts. If your goal is a current certification, stop before scheduling or buying preparation material: confirm IBM’s current replacement or alternative first, then build a new plan around that exam’s own objectives and delivery rules.
