Instant Download: Upon successful payment, Our systems will automatically send the product you have purchased to your mailbox by email. (If not received within 12 hours, please contact us. Note: don't forget to check your spam.)
Instant Download IBM : C2090-600 Questions & Answers as PDF & Test Engine
- Exam Code: C2090-600
- Exam Name: IBM DB2 11.1 DBA for LUW
- Updated: Nov 16, 2026
- No. of Questions: 60 Questions and Answers
- Download Limit: Unlimited
Some companies' dumps expire in three months. Lead2Passed's IBM DB2 11.1 DBA for LUW set stays valid for 365 days with free updates — 60 practice questions, renewable at 50% off in 2026.
IBM C2090-600 Exam Overview:
| Certification Vendor: | IBM |
|---|---|
| Exam Name: | IBM DB2 11.1 DBA for LUW |
| Exam Number: | C2090-600 |
| Exam Format: | Multiple Choice |
| Passing Score: | 38 out of 60 (approx. 63%) |
| Exam Duration: | 90 minutes |
| Exam Price: | Varies by region (official IBM/Pearson VUE pricing) |
| Available Languages: | English |
| Related Certifications: | IBM Certified Database Associate - DB2 11.1 Fundamentals for LUW IBM Certified Database Administrator - DB2 11.1 for LUW Credential |
| Real Exam Qty: | 60 |
| Certificate Validity Period: | This exam and its associated certification have been *withdrawn* (retired March 31, 2023) |
| Sample Questions: | DOWNLOAD DEMO |
| Exam Way: | Delivered through IBM-authorized testing provider (e.g., Pearson VUE) |
| Pre Condition: | No formal prerequisites, but relevant DB2 administration experience recommended |
| Official Syllabus URL: | https://www.ibm.com/training/certification/ibm-certified-database-administrator-db2-111-for-linux-unix-and-windows-08002109 |
IBM C2090-600 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: Utilities | 13% | - Data movement utilities (Export/Import/Load/Ingest) - REORG, RUNSTATS, REBIND, ADMIN_CMD, db2look, db2move |
| Topic 2: DB2 Server Management | 15% | - Configure and manage DB2 servers, instances, and databases - Autonomic features, WLM, Data Server Manager overview - Create and manage storage paths |
| Topic 3: Business Rules Implementation | 10% | - Create and modify table constraints - SET INTEGRITY checking and triggers |
| Topic 4: High Availability | 13% | - Backup and recovery operations - Configure/manage HADR and pureScale |
| Topic 5: Monitoring DB2 Activity | 12% | - Capture/analyze EXPLAIN information - Use monitoring tools, db2pd, dsmtop |
| Topic 6: Security | 15% | - Authentication, trusted contexts, and access control - Data encryption and auditing facilities |
| Topic 7: Physical Design | 22% | - Partitioning and SQL compatibility topics - Implement BLU Acceleration and pureScale enhancements - Create/manage database objects, compression |
What Candidates Ask About the IBM C2090-600 Exam
The IBM DB2 11.1 DBA for LUW blueprint spans 7 domains — including Utilities (13%), DB2 Server Management (15%), High Availability (13%). Spend your hours where the percentages are; the full outline above lists every subtopic.
Varies by region (official IBM/Pearson VUE pricing) per attempt, 38 out of 60 (approx. 63%) to pass. Retakes bill the full fee again, so make the first attempt the prepared one — rehearse with the 60 practice questions from Lead2Passed until the mark is comfortably behind you.
90 minutes for 60 questions. Train the pace, don't guess it: the Lead2Passed software and online engines simulate the real test scene and score your performance, so exam day holds no surprises.
No formal prerequisites, but relevant DB2 administration experience recommended Vendors adjust eligibility rules over time — verify the current requirements on the official page (official C2090-600 exam page) before registering.
Files first: payment triggers an automatic email within a minute — download on unlimited devices, and contact our round-the-clock team if nothing arrives within 2 hours (check spam). Failure is covered: take the corresponding C2090-600 exam within 60 days of purchase, and if you don't pass, email a scanned enrollment slip plus the official Score Report PDF within 2 days of the exam — we handle it quickly, with the full refund processed within 7 days. Exclusions: exams within 3 days of purchase, candidate names that don't match the payer, and free or expired products. You may instead exchange for two equal-value products free.
Yes — download the free IBM DB2 11.1 DBA for LUW demo and inspect real questions before paying. Your purchase then stays valid for 365 days with free updates throughout, renewable afterward at 50% off.
The IBM DB2 11.1 DBA for LUW is IBM's official exam for the IBM Certified Database Administrator certification, at the Intermediate / Professional level. It validates practical, job-relevant skills — which is why employers shortlist certified candidates. Related credentials include IBM Certified Database Associate - DB2 11.1 Fundamentals for LUW, IBM Certified Database Administrator - DB2 11.1 for LUW Credential.
IBM DB2 11.1 DBA for LUW Sample Questions:
On Linux and Unix systems, which of the following will set the DB2_FMP COMM_HEAPSZ registry variable to 1 GB (or 256000 pages), only for the instance db2inst1?
- A. As the db2 instance owner (db2inst1) execute the command:
exportDB2_FMP COMM_HEAPSZ=256000 - B. As the db2 instance owner (db2inst1) execute the command:
db2set -i db2inst1 DB2_FMP COMM_HEAPSZ=256000 - C. As the db2 instance owner (db2inst1) execute the command:
db2set -i DB2_FMP COMM_HEAPSZ=256000 - D. Add to the following line to the user profile (db2inst1): DB2_FMP COMM_HEAPSZ=256000
Correct Answer: C 🗳️
Which of the following statements is TRUE?
- A. REORGCHK can only be used for user tables, not for system tables.
- B. REORGCHK can be used to verify the level of data fragmentation and indicate whether reorganization might be required.
- C. REORGCHK uses only current table and index statistics.
- D. REORGCHK automatically run stables reorganization.
Correct Answer: C 🗳️
Which of the following statements about audit policies is TRUE?
- A. Multiple audit policies can be associated with the same table at the same time.
- B. The audit policy applied to a table is automatically applied to any view based on that table.
- C. Audit policy changes are applied instantly and affect all inflight transactions.
- D. If a user is switched within a trusted connection, the applicable audit policies are re-evaluated for the new user without regard to audit policies for the original user.
Correct Answer: D 🗳️
What is the main benefit of performing an ADMIN_MOVE_TABLE operation in multiple steps?
- A. It does not acquire locks on the table
- B. It does not require additional temporary disk space
- C. It enables the user to control when the table will be offline
- D. It allows the ADMIN_MOVE_TABLE procedure to be used in HADR environments
Correct Answer: D 🗳️
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. IBM DEFAULTISG
- B. SG2
- C. SG1
- D. IBM STOGROUP
Correct Answer: D 🗳️
Viewing page 1 out of 12 pages.
Viewing questions 1-5 out of 60 questions.
100% Money Back Guarantee
Lead2Passed has an unprecedented 99.6% first time pass rate among our customers.
We're so confident of our products that we provide no hassle product exchange.
- Best exam practice material
- Three formats are optional
- 10 years of excellence
- 365 Days Free Updates
- Learn anywhere, anytime
- 100% Safe shopping experience
Over 56368+ Satisfied Customers

1002 Customer ReviewsCustomers Feedback (* Some similar or old comments have been hidden.)
I really went through all the exam question and praise God I passed C2090-600.
My success in C2090-600 came through Lead2Passed Study Guide for the exam. The unique guide provided me not only the simplified information in QandAs form but also
Please tell this information to your IBM DB2 11.1 DBA for LUW dumps customers.
My friend suggested me to get Lead2Passed's practice file for the C2090-600 exam so I purchased it! I was really happy to see all questions come with correct answers! And i passed the exam at my first attempt.
I failed my exam with other website dumps. I think these website has the latest C2090-600 dump. I remember the new questions. They are in this dump! PASSED SUCCESSFULLY!
Valid and latest exam dumps for C2090-600 certification. I passed my exam today with great marks. I recommend everyone should study from Lead2Passed.
The test engine cannot be used on Iphone. Valid dumps. I pass exam with 85%. Study on computer everyday. can not move
After passing the C2090-600 exam in January, I took another two exams, respectively and passed.
Passed C2090-600 exam today with a good score. This dump is valid. Thanks for your help.
Thank you for offering so high efficient C2090-600 exam braindumps! I got a pretty score the day before yesterday.
I have never seen such helpful C2090-600 practice braindump! I am glad that i had purchased it and pass the exam. I recommend it to all candidates!
Hi guys! These C2090-600 exam dumps are very valid! I got all i wanted here. They are great! I passed with all three versions.
I received download link and password within ten minutes after paying for C2090-600 training materials, that was fantastic.
Thank you guys for the perfect work!
You guys finally send the update to me.
Thank you Lead2Passed for turning things on for me by sharing such an outstanding file of 100% real exam dumps. I passed this test and got 94% marks in the C2090-600 certification exam.
