A failed attempt at the C2090-544 exam means paying the registration fee again and waiting for a new test date. Compared with a retake, a few weeks with the LatestCram IBM DB2 9.7 Advanced DBA for LUW practice package in 2026 is the cheaper path by far.
IBM C2090-544 Exam Overview:
| Certification Vendor: | IBM |
|---|---|
| Exam Name: | IBM DB2 9.7 Advanced DBA for LUW |
| Exam Number: | 000-544 |
| Exam Price: | USD 200 (varies by region) |
| Exam Duration: | 90 minutes |
| Related Certifications: | IBM Certified Database Administrator - DB2 9 for LUW |
| Passing Score: | 60% |
| Exam Format: | Scenario-based questions, Multiple choice |
| Available Languages: | English |
| Real Exam Qty: | 54 |
| Certificate Validity Period: | 3 years |
| Recommended Training: | IBM Training - DB2 9.7 Administration |
| Exam Registration: | IBM Certification Registration |
| Sample Questions: |  |
| Exam Way: | Proctored exam (online or authorized testing center) |
| Pre Condition: | Recommended: IBM DB2 9 Database Administrator certification or equivalent hands-on DBA experience |
| Official Syllabus URL: | https://www.ibm.com/certification/ |
IBM C2090-544 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Topic 1: Backup and Recovery | - Point-in-time recovery - Log management and rollforward recovery - Online and offline backups |
| Topic 2: Database Monitoring and Troubleshooting | - Locking issues and deadlock resolution - Event monitoring and snapshot analysis |
| Topic 3: High Availability and Disaster Recovery | - HADR configuration and monitoring - Failover and recovery strategies |
| Topic 4: Security and Authorization | - Roles, privileges, and access control - Authentication and authorization models |
| Topic 5: Database Performance Tuning | - Memory tuning (buffer pools, sort heap, lock list) - Query optimization and explain plans - Index design and maintenance |
| Topic 6: Database Architecture and Configuration | - Configuration parameters and environment setup - DB2 architecture components (instances, databases, bufferpools) |
Your IBM C2090-544 Exam Questions, Answered
The IBM C2090-544 exam, officially titled DB2 9.7 Advanced DBA for LUW, is the required test for earning the IBM Certified Advanced Database Administrator - DB2 9 for LUW certification, a credential at the Professional level. Passing it validates the skills IBM expects from certified professionals, and it can also support progress toward related credentials such as IBM Certified Database Administrator - DB2 9 for LUW.
The C2090-544 exam includes 54 questions, and you have 90 minutes to complete it. Before exam day, divide the available time by the question count so you know the pace you need to hold, and practice flagging time-consuming items for review instead of stalling on a single question. Timed sessions in the LatestCram test engine are the easiest way to build that rhythm before it counts.
You need 60% to pass the C2090-544 exam, and the official registration fee is USD 200 (varies by region). Keep in mind that a failed attempt means paying that fee in full again for a retake, so avoid booking your seat on a hunch. Work through the LatestCram practice test until your scores sit comfortably above the passing requirement before you schedule the exam.
IBM asks candidates to meet the following requirement before registering: Recommended: IBM DB2 9 Database Administrator certification or equivalent hands-on DBA experience. Exam policies do change, so confirm the latest details on the official exam page at https://www.ibm.com/certification/ before you book.
You can book your seat through the official registration channels below:
The C2090-544 exam is delivered in the following format: Proctored exam (online or authorized testing center).
IBM recommends the following official training for this exam:
A course builds the theory; practice turns it into exam-day performance. Once you finish a class, the 106 practice questions from LatestCram show you how the same knowledge appears in exam-style items.
Yes. LatestCram offers a free PDF demo of the IBM DB2 9.7 Advanced DBA for LUW practice questions, so you can judge the quality and format before purchasing. After you buy, your purchase includes 365 days of free updates; if the product expires after that period, you can extend the update service at a 50% discount from your member zone.
Every LatestCram order is covered by a 100% Money Back Guarantee. If you take the corresponding C2090-544 exam within 60 days of purchase and do not pass, send a scan of your exam enrollment slip together with your official Score Report PDF within two days of the exam date, and your claim will be processed within seven days. The candidate name must match the payer name, and the guarantee does not apply if you take the exam within three days of purchase, if you downloaded the product but never took the exam, or to free materials and expired orders. If you would rather have fresh material than a refund, you can exchange your purchase for two additional exam products of equal value at no cost and keep the update service on your original product. Delivery itself is instant: your download is available right after payment and a copy is emailed to you within one minute — if nothing arrives within two hours, contact our support team. You may install the software on as many computers as you need.
The IBM DB2 9.7 Advanced DBA for LUW exam is organized into 6 major domains. Some of the key domains include:
- Database Architecture and Configuration
- Security and Authorization
- Backup and Recovery
Scroll up to the Exam Topics section for the complete breakdown, and use it to plan how much study time each domain deserves.
IBM DB2 9.7 Advanced DBA for LUW Sample Questions:
Assuming table TAB_A resides in a DB2 9.7 database, what is one way to obtain an estimate of how much space could be saved if this table were compressed?
- A. The ADMINGETTABCOMPRESSINFO_V97 table function.
- B. The ADMINGETTABCOMPRESSINFO table function.
- C. The ADMIN_GET_TAB_COMPRESS_INFO_V97 table function.
- D. The ADMIN_GET_TAB_INFO table function.
Correct Answer: C 🗳️
Given a newly created database and sufficient memory. If the following statements are successful: CREATE BUFFERPOOL bp1 SIZE 40MB; CREATE BUFFERPOOL bp2 PAGESIZE 16K SIZE 40000; How much memory will be allocated for buffer pools BP1 and BP2?
- A. 40MB
- B. 680MB
- C. 80MB
- D. 665MB
Correct Answer: D 🗳️
Which registry variable allows you to limit the size of individual containers for automatic storage table spaces?
- A. DB2_LIMIT_AS_CONTAINER_BLOCKS
- B. DB2_ALLOCATION_SIZE
- C. DB2_TRUNCATE_AS_STORAGE
- D. DB2_SET_MAX_CONTAINER_SIZE
Correct Answer: D 🗳️
Given the following output from the GET DATABASE CONFIGURATION command:
Which of the following DB configurations listed below will enable circular logging?
- A. LOGPRIMARY=LOGCIRCULAR and LOGRETAIN=OFF
- B. LOGRETAIN=CIRCULAR
- C. LOGARCHMETH1=OFF and LOGARCHMETH2=OFF
- D. LOGSECOND=-1
Correct Answer: C 🗳️
A database and a table space were created using the following commands:
Afterwards, two tables were created in table space TBSP1 and both tables were populated with 100,000 rows. If a DBA decides that database MYDB should use automatic storage, which command(s) are needed to convert the database?
- A. ALTER DATABASE mydb AUTOMATIC STORAGE YES ON ?mnt/path_1? ?mnt/path_2?
- B. ALTER DATABASE mydb AUTOMATIC STORAGE YES ON ?mnt/path_1? ?mnt/path_2? ALTER TABLESPACE tbsp1 MANAGED BY AUTOMATIC STORAGE;
- C. ALTER DATABASE mydb ADD STORAGE ON ?mnt/path_1? ?mnt/path_2? ALTER TABLESPACE tbsp1 MANAGED BY AUTOMATIC STORAGE;
- D. ALTER DATABASE mydb ADD STORAGE ON ?mnt/path_1? ?mnt/path_2?
Correct Answer: D 🗳️
Viewing page 1 out of 22 pages.
Viewing questions 1-5 out of 106 questions.
Mandel 
Lewis 
Howar 
Chapman 
Beacher 
Jason 
Morgan 
Darnell 
Maurice 
Merle 
Luther 
Harley 
Monroe 
Kelly 
Maxwell 
Hubery 
