- Exam Code: C2090-600
- Exam Name: IBM DB2 11.1 DBA for LUW
- Updated: Aug 31, 2026
- Q & A: 60 Questions and Answers
Vendors revise exam objectives, and yesterday's notes age faster than most people expect. Actual4Dumps tracks those changes and keeps its 60 IBM DB2 11.1 DBA for LUW practice questions aligned with the live exam, with 365 days of free updates included for every 2026 buyer.
| Certification Vendor: | IBM |
|---|---|
| Exam Name: | IBM DB2 11.1 DBA for LUW |
| Exam Number: | C2090-600 |
| Exam Price: | Varies by region (official IBM/Pearson VUE pricing) |
| Related Certifications: | IBM Certified Database Associate - DB2 11.1 Fundamentals for LUW IBM Certified Database Administrator - DB2 11.1 for LUW Credential |
| Passing Score: | 38 out of 60 (approx. 63%) |
| Available Languages: | English |
| Exam Format: | Multiple Choice |
| Real Exam Qty: | 60 |
| Exam Duration: | 90 minutes |
| Certificate Validity Period: | This exam and its associated certification have been *withdrawn* (retired March 31, 2023) |
| Sample Questions: | ![]() |
| 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 |
| Section | Weight | Objectives |
|---|---|---|
| Physical Design | 22% | - Implement BLU Acceleration and pureScale enhancements - Create/manage database objects, compression - Partitioning and SQL compatibility topics |
| DB2 Server Management | 15% | - Configure and manage DB2 servers, instances, and databases - Create and manage storage paths - Autonomic features, WLM, Data Server Manager overview |
| Utilities | 13% | - Data movement utilities (Export/Import/Load/Ingest) - REORG, RUNSTATS, REBIND, ADMIN_CMD, db2look, db2move |
| Monitoring DB2 Activity | 12% | - Capture/analyze EXPLAIN information - Use monitoring tools, db2pd, dsmtop |
| High Availability | 13% | - Backup and recovery operations - Configure/manage HADR and pureScale |
| Business Rules Implementation | 10% | - SET INTEGRITY checking and triggers - Create and modify table constraints |
| Security | 15% | - Authentication, trusted contexts, and access control - Data encryption and auditing facilities |
IBM DB2 11.1 DBA for LUW is an official certification exam from IBM, identified by the exam code C2090-600. Pass it and you hold the IBM Certified Database Administrator certification, which sits at the Intermediate / Professional level. It also feeds into related credentials, including IBM Certified Database Associate - DB2 11.1 Fundamentals for LUW, IBM Certified Database Administrator - DB2 11.1 for LUW Credential. In practical terms, this certification tells employers your skills have been measured against the vendor's own standard, which is why certified candidates tend to stand out in hiring and promotion decisions.
Expect 60 questions within 90 minutes on the IBM DB2 11.1 DBA for LUW exam. Numbers aside, the real challenge is rhythm: lingering too long on one item quietly steals time from three others. Build the habit of answering, flagging, and moving on, then rehearse the full experience under a countdown with the Actual4Dumps test engine until finishing comfortably early becomes your norm.
Registration for IBM DB2 11.1 DBA for LUW officially runs Varies by region (official IBM/Pearson VUE pricing), with 38 out of 60 (approx. 63%) required to pass. Worth knowing before you book: retakes are billed at the same full Varies by region (official IBM/Pearson VUE pricing), so a failed attempt doubles your spend. The smarter sequence is to measure yourself first. When your scores on the Actual4Dumps practice tests clear the passing line with room to spare, consistently, that is your signal to schedule the real thing.
No formal prerequisites, but relevant DB2 administration experience recommended
Because vendors update their policies without much fanfare, verify the latest entry requirements before you book using the official exam page.
Yes, and we encourage it. Download the free PDF demo of the IBM DB2 11.1 DBA for LUW questions from Actual4Dumps and evaluate the quality on your own terms. After you buy, every update for the next 365 days is free, and when that window closes you can extend your update service at half price.
A 100% money-back guarantee applies, governed by clear conditions. If you sit the IBM DB2 11.1 DBA for LUW exam within 60 days of purchase and fail, you can claim a full refund, as long as the exam corresponds to your product. Attempts made within 3 days of purchase are ineligible, as are products you downloaded but never used, free materials, and expired orders; the name on the exam record must match the payer's name. File your claim with a scanned enrollment slip and the official Score Report PDF within 2 days of the exam, and it is settled within 7 days. Rather have a replacement than a refund? You may exchange for two other exam products of equal value, free, and your original product keeps its update service.
Delivery is essentially instantaneous: files unlock for download at payment and arrive in your email within one minute. Some vendors make you wait a day; if 2 hours pass here without delivery, check spam and contact customer service. Install on as many computers as you like, with no restrictions.
The IBM DB2 11.1 DBA for LUW blueprint spans 7 domains. The ones carrying the most weight include Monitoring DB2 Activity (12%), High Availability (13%), and Security (15%). The complete domain-by-domain breakdown is in the exam topics section above; treat it as your master checklist and let the weights tell you where your study hours earn the most.
Question 1
Which is the correct way to back up only metadata about database backups, table space backups, and table load operations for database MYDB?
A. db2trc on -db mydb -m "backup,load"run the desired operationsdb2tc dump db2trc.dmpdb2tc format db2tc.dmp db2tc.fmtdb2tc off
B. BACKUP DATABASE mydb NO TABLESPACE TO /outdir
C. CONNECT TO mydbPRUNE HISTORY TO /outdir
D. db2setDB2_BCKP PAGE_VERIFICATION=TRUE must be issued first (no instance restart is needed).Run the desired operations.Afterwards, issue db2trc dump <outfile>
Question 2
Which statement about Data Server Manager (DSM) is TRUE?
A. DSM can be used for reviewing audit trails
B. DSM cannot be used for database administration
C. DSM can be used to efficiently monitor, analyze, identify, and solve a performance issue
D. DSM can be used for configuration management of DB2 Data Server drivers
Question 3
Which DB2 Explain Facility tool uses the Explain tables to display access plain information?
A. db2expln
B. db2advis
C. db21ook
D. db2exfmt
Question 4
An HADR environment has two standby databases - one principal and one auxiliary. What is the only mode that can be used to transfer data to the auxiliary standby?
A. SUPERASYNC
B. ASYNC
C. SYNC
D. NEARSYNC
Question 5
Which of the following SQL statements will list table spaces whose utilization is greater than 95% and may potentially fill, returning an error?
A. SELECT tbsp_name, tbsp_utilization_percentFROM syscat.mon_tbsp_utilization WHERE tbsp_utilization_percent > 95AND tbsp_auto_resize_enabled = O;
B. SELECT tbsp_name, tbsp_utilization_percentFROM syscat.mon_tbsp_utilization WHERE tbsp_utilization_percent > 95AND tbsp_auto_resize_enabled = 1;
C. SELECT tbsp_name, tbsp_utilization_percentFROM TABLE(sysproc.mon_tbsp_utilization()) AS tWHERE tbsp_utilization_percent > 95AND tbsp_auto_resize_enabled = 1;
D. SELECT tbsp_name, tbsp_utilization_percentFROM sysibmadm.mon_tbsp_utilization WHERE tbsp_utilization_percent > 95AND tbsp_auto_resize_enabled = O;
Solutions:
| Question 1 Answer: A | Question 2 Answer: C | Question 3 Answer: A | Question 4 Answer: A | Question 5 Answer: B |
Over 45369+ Satisfied Customers
Actual4Dumps provide an excellent study guide, it helped me het started on studying for the C2090-600 exam.
Content all seems accurate in the real C2090-600 exam questions. I have passed my C2090-600 exam just now. Highly recommend!
I passed with score 96% by using the C2090-600 exam files. Almost all the questions from dumps, so i wrote the paper in quite a short time.
These C2090-600 exam dumps gave me confidence on the real exam and i passed it. About 90% of the questions are valid!
Best exam testing software by Actual4Dumps. I failed my C2090-600 certification exam but after I practised with Actual4Dumps exam testing software, I achieved A 92% marks. Highly suggest all to buy the bundle file.
I can confirm your C2090-600 is still valid.
Most of my colleagues scared me pointing to the difficult syllabus of exam IBM Certified Database Administrator C2090-600 . To an extent they were right but one new question
I suggest the bundle files for the C2090-600 certification Exam. Helped me a lot in passing the exam with 90% marks. Made the real exam very easy with the exam dumps and practise software.
I am really glad with Actual4Dumps C2090-600 study guide because it helped me to become a certified professional. Actual4Dumps gave me the solution to my trouble, providing to me an pass
I passed exam yesterday. Do not hesitate again. Actual4Dumps is reliable. The exam cram is valid
My company asks me to get the C2090-600 certification asap. When i felt worried, i found this C2090-600 study guide, it is wonderful. Can't believe i passed so smoothly. Thanks so much!
I bought the Value Pack containing the PDF & Software & APP online versions and passed this Friday. Well, the price is so low and i can experience all of them. Great!
Tell you the truth, these C2090-600 practice questions and answers are valid for i just passed my exam with the help of them. You can buy them right now if you want to pass!
I can downlod the C2090-600 exam dumps of pdf version after payment. Actual4Dumps is very effective for me.
What I get from the Actual4Dumps is very useful and valid. I will recommend to all of my friends.
Passed my C2090-600 exam with brilliant marks,I seriously faced no trouble at all when I was studying C2090-600 exam.
I will try C2090-600 exam next month.
Passing the C2090-600 exam makes me feel proud of myself though i know it is all because of your excellent C2090-600 practice test questions. Anyway, i am wise to buy them from you.
World class C2090-600 exam prep featuring C2090-600 exam questions and answers! No other C2090-600 dumps will bring you such a knowledge and preparation that only from Actual4Dumps.
Passed the actual exam to share with you the experience..C2090-600 braindumps works perfect makes me pass the exam.
Actual4Dumps Practice Exams are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development - no all study materials.
We are committed to the process of vendor and third party approvals. We believe professionals and executives alike deserve the confidence of quality coverage these authorizations provide.
If you prepare for the exams using our Actual4Dumps testing engine, It is easy to succeed for all certifications in the first attempt. You don't have to deal with all dumps or any free torrent / rapidshare all stuff.
Actual4Dumps offers free demo of each product. You can check out the interface, question quality and usability of our practice exams before you decide to buy.