100% Money Back Guarantee
Fast2test 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 000-919 exam practice materials
- Three formats are optional
- 10 years of excellence
- 365 Days Free Updates
- Learn anywhere, anytime
- 100% Safe shopping experience
The IBM Informix 11.70 System Administrator exam has a reputation for tripping up even experienced professionals. Fast2test breaks it down into 123 practice questions with verified answers, so you walk into 000-919 in 2026 knowing exactly what to expect.
IBM 000-919 Exam Overview:
| Certification Vendor: | IBM |
|---|---|
| Exam Name: | Informix 11.70 System Administrator |
| Exam Number: | C2090-919 |
| Real Exam Qty: | 63 |
| Exam Duration: | 90 minutes |
| Exam Format: | Multiple-response, Multiple-choice |
| Certificate Validity Period: | Not specified |
| Passing Score: | 60% |
| Available Languages: | English |
| Exam Price: | USD 200 (may vary by region) |
| Recommended Training: | IBM Informix 11.70 Administration Training |
| Exam Registration: | Pearson VUE Registration IBM Certification Portal |
| Sample Questions: | IBM 000-919 Sample Questions |
| Exam Way: | In-person at Pearson VUE centers or online proctored |
| Pre Condition: | No formal prerequisites; recommended 2+ years of Informix administration experience |
| Official Syllabus URL: | https://www.ibm.com/certify/exams/C2090-919 |
IBM 000-919 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: Replication and High Availability | 10% | - Connection Manager configuration - ER, GRID, HDR and Mach 11 setup |
| Topic 2: System Activity Monitoring and Troubleshooting | 14% | - Informix utilities and admin API usage - Message log and system database monitoring - Locking, concurrency and problem isolation |
| Topic 3: Performance Tuning | 16% | - Shared memory and virtual processor configuration - Disk layout and PDQ optimization - Checkpoints, statistics and network tuning |
| Topic 4: Security | 12.5% | - Auditing, trusted contexts and privileges - Authentication, authorization and encryption |
| Topic 5: Space Management | 19% | - Fragmentation, compression and OLTR - Dbspace, sbspace and chunk management - Storage pool and extendable chunks |
| Topic 6: Backup and Restore | 8% | - Onbar and ontape configuration - Backup strategies and recovery modes |
| Topic 7: Warehousing | 8% | - Merge and external tables - Star/snowflake schema support |
| Topic 8: Installation and Configuration | 12.5% | - Log configuration and connection protocols - Operating system setup and parameters - Deployment utilities and migration - Distributed system and user-defined types |
IBM 000-919 FAQs: What Every Candidate Asks
The 000-919 exam, officially titled Informix 11.70 System Administrator, is the qualifying test for the IBM Certified System Administrator - Informix 11.70 certification from IBM, a credential at the Administrator level. Passing it proves you have the skills employers look for in certified professionals.
The IBM Informix 11.70 System Administrator exam gives you 90 minutes to work through 63 questions. That is a steady pace with little room for second-guessing, so train yourself to read each question once, flag the difficult ones, and keep moving. Before exam day, sit at least two full timed sessions in the Fast2test test engine — when the clock feels familiar, it stops being a threat.
You need 60% to pass, and the official registration fee is USD 200 (may vary by region). Fall short and you pay that fee in full again for every retake, which makes solid preparation the cheaper option by far. Work through the Fast2test practice questions until you score comfortably above the passing mark, then book your seat.
No formal prerequisites; recommended 2+ years of Informix administration experience Eligibility rules can change over time, so before you register, confirm the latest requirements on the official exam page: IBM 000-919 exam overview.
You can book your 000-919 exam through any of these official registration channels:
The exam is delivered as In-person at Pearson VUE centers or online proctored, so you can pick the option that fits your schedule when you book.
IBM recommends the following training for IBM Informix 11.70 System Administrator candidates:
Pair that training with the 123 practice questions from Fast2test and you can check your readiness topic by topic before exam day.
Yes. Fast2test offers a free PDF demo for the IBM Informix 11.70 System Administrator exam so you can judge the quality of our questions and answers before paying anything. Every purchase also comes with 365 days of free updates, and once that period expires you can extend your update service at a 50% discount.
Your purchase is protected by a 100% money-back guarantee. If you sit the corresponding 000-919 exam within 60 days of buying and do not pass, send us a scan of your exam enrollment slip together with your official Score Report (PDF) within 2 days of the exam date — the candidate name must match the payer's name — and we will process your full refund within 7 days. Please note that exams taken within 3 days of purchase, materials downloaded without ever sitting the exam, free products, and expired orders are not covered. If you would rather not have a refund, you can exchange your order for two exam products of equal value, free of charge, and keep the update service on your original purchase.
Delivery is instant: your files are emailed to you within one minute of payment and can also be downloaded directly, with no limit on the number of computers you install them on. If nothing has arrived within 2 hours, contact our customer service team and we will sort it out.
The IBM Informix 11.70 System Administrator syllabus is organized into 8 domains. The main areas include Performance Tuning (16%), Backup and Restore (8%), and Replication and High Availability (10%). Scroll up to the Exam Topics section above for the complete, current outline before you plan your study schedule.
IBM Informix 11.70 System Administrator Sample Questions:
Question 1
Which statement about Informix data compression is NOT true?
A. It can compress, repack and shrink a table in one command.
B. There is no Admin API (sysadmin) interface to automatically compress tables.
C. The 'onstat -g dsk' command can be used to find the progress of currently running compression operations.
D. The compress, repack, repack_offline, uncompress, and uncompress_offline operations can consume large amounts of logs.
Question 2
How can ER onconfig parameters be modified dynamically?
A. cdr define onconfig
B. cdr set onconfig
C. cdr tune onconfig
D. cdr change onconfig
Question 3
Which parameter is used to configure the servers in a high-availability cluster so that transactions complete after failover?
A. SURVIVAL_TX_TIMEOUT
B. FAILOVER_TX_TIMEOUT
C. FAILOVER_CALLBACK
D. SURVIVAL_TX_ENABLE
Question 4
Given the following SQL statement:
WHEN MATCHED THEN DELETE What does the merge statement do?
A. Deletes rows in tab1 that match the condition col1 = c1 and insert rows in tab1 from those in tab2 that do not match the condition.
B. Deletes rows in tab1 that match the condition col1 = c1.
C. Deletes rows in tab1 that match the condition col1 = c1 and deletes rows in tab2 that do not match the condition col1 = c1.
D. Deletes rows in tab2 that match the condition col1 = c1.
Question 5
Given the following SLA definition:
SLA group_1=HDR+(inst_2+inst_3)+SDS
How will new connections be routed through the SLA?
A. The HDR instance first, then inst_2, followed by inst_3, finally to any SD secondary instance.
B. The HDR instance first, load balanced between inst_2 and inst_3, then to any SD secondary instance.
C. Load balanced between inst_2 and inst_3, then either HDR or any SD secondary instance.
D. Load balanced between all secondary instances.
Solutions:
| Question 1 Answer: B | Question 2 Answer: D | Question 3 Answer: B | Question 4 Answer: B | Question 5 Answer: B |
0 Customer ReviewsCustomers Feedback (* Some similar or old comments have been hidden.)
Instant Download 000-919
After Payment, our system will send you the products you purchase in mailbox in a minute after payment. If not received within 2 hours, please contact us.
365 Days Free Updates
Free update is available within 365 days after your purchase. After 365 days, you will get 50% discounts for updating.
Money Back Guarantee
Full refund if you fail the corresponding exam in 60 days after purchasing. And Free get any another product.
Security & Privacy
We respect customer privacy. We use McAfee's security service to provide you with utmost security for your personal information & peace of mind.
Related Exams
Contact Us
If you have any question please leave me your email address, we will reply and send email to you in 12 hours.
Our Working Time: ( GMT 0:00-15:00 ) From Monday to Saturday
Support: Contact now


