In 2026, rehearsal should feel like the real day. The PC test engine at PassCollection recreates the C2090-600 exam scene on your computer: set a time limit exactly like the live test, and practice finishing under pressure until the IBM DB2 11.1 DBA for LUW format feels routine.
IBM C2090-600 Exam Overview:
| Certification Vendor: | IBM |
|---|---|
| Exam Name: | DB2 11.1 DBA for Linux, UNIX, and Windows |
| Exam Number: | C2090-600 |
| Available Languages: | English |
| Exam Format: | Multiple response, Multiple choice |
| Certificate Validity Period: | 3 years |
| Exam Duration: | 90 minutes |
| Related Certifications: | IBM Certified Database Administrator - DB2 IBM Certified Advanced Database Administrator - DB2 |
| Recommended Training: | IBM DB2 11.1 Administration Training |
| Exam Registration: | IBM Certification Portal Pearson VUE IBM Exams |
| Sample Questions: |  |
| Exam Way: | Online proctored or test center (Pearson VUE) |
| Pre Condition: | Recommended experience with DB2 LUW administration and basic database concepts; no strict formal prerequisite required. |
| Official Syllabus URL: | https://www.ibm.com/certify |
IBM C2090-600 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Performance Monitoring and Tuning | - Query optimization
|
| Database Operation and Maintenance | - Backup and recovery
|
| High Availability and Recovery | - Replication and clustering
|
| Security and Authorization | - User and role management
|
| DB2 Server Administration | - DB2 instance and database architecture
|
C2090-600 Exam Questions and Study Options
Whichever matches your habits — all three are built around the same IBM DB2 11.1 DBA for LUW content. The PDF version suits paper readers: print it out, mark it up, and share pages with a study partner. The PC test engine suits computer-based learners: it simulates the real exam scene, lets you set a time limit like the live C2090-600 exam, flags your mistakes, and reminds you to re-practice them daily. The online APP includes every software function and runs on Windows, Mac, Android, and iOS. Choose the one you will actually use every day.
IBM recommends these training options for candidates:
Official courses build understanding; a daily practice routine with expert-verified answers builds exam-day readiness. The strongest preparation uses both.
The official outline divides the C2090-600 exam into weighted domains, including:
- Performance Monitoring and Tuning ()
- DB2 Server Administration ()
- Database Operation and Maintenance ()
The IBM DB2 11.1 DBA for LUW practice questions at PassCollection follow these same objectives, whichever of the three study formats you use.
Yes. We understand that many candidates prefer not to advertise how they prepare. PassCollection runs a strict information protection system: your personal details and your C2090-600 exam purchase are kept secret and safe, and never disclosed to any third party. You can order the IBM DB2 11.1 DBA for LUW materials with complete peace of mind.
Recommended experience with DB2 LUW administration and basic database concepts; no strict formal prerequisite required.
The C2090-600 exam is the official assessment behind the IBM DB2 11.1 DBA for LUW certification from IBM. Many IT professionals pursue it as a step toward leadership roles, because the credential verifies practical command of the published objectives. Solid preparation — not luck — is what carries candidates through it.
You can register for the C2090-600 exam through these official channels:
Book your seat only when your timed practice scores say you are ready — the registration fee is better paid once than twice.
IBM DB2 11.1 DBA for LUW Sample Questions:
Automatic space reclamation for column-organized tables can be accomplished in which of the following scenarios?
- A. After termination all the back-end processes using TERMINATE command
- B. After setting the database configuration parameter AUTO_DEL_REC_OBJ to ON
- C. When the registry variable DB2_WORKLOAD=ANALYTICS prior to database creation
- D. When the registry variableDB2_AUTORECLAIMSPACE=YES
Correct Answer: B 🗳️
Which operation best describes the purpose of the SET INTEGRITY PRUNE operation?
- A. To prune the contents of a materialized query table (MQT).
- B. To prune the contents of a synopsis table.
- C. To prune the contents of a staging table.
- D. To prune the contents of a declared global temporary table.
Correct Answer: C 🗳️
Which data types are only valid when DB2_COMPATIBILITY_VECTOR=ORA? (Choose two.)
- A. VRCHAR2
- B. REAL
- C. XML
- D. NUMBER
- E. VARBINARY
Correct Answer: D,E 🗳️
What does dsmtop use to gather metrics?
- A. db2pd
- B. monitoring table functions
- C. the system catalog
- D. db2dart
Correct Answer: B 🗳️
If the following SQL statements are executed:
CREATE DATABASE testdb AUTOMATIC STORAGE NO;
CONNECT TO testdb;
CREATE STOGROUP sgl ON '/datal';
CREATE STOGROUP ibmstogroup ON '/data2';
CREATE STOGROUP sg2 ON '/data3';
Which storage group is the default storage group for the TESTDB database?
- A. SG1
- B. SG2
- C. IBM STOGROUP
- D. IBM DEFAULTISG
Correct Answer: C 🗳️
Melissa 
Ryan 
Harvey 
Yves 
Larry 
Norton 
Sandy 
Dana 
Zona 
Wanda 
Sarah 
Douglas 
Hilda 
Hayden 
Afra 
Nicholas 
