IBM C2090-919 Exam Syllabus Topics:
| Topic | Details | Weights |
|---|---|---|
| Space Management | -Configure and manage dbspaces and sbspaces -Knowledge of OLTR -Knowledge of storage pool mgmt -Knowledge of extendable chunks -Knowledge of pro-active/reactive space allocation -Knowledge of fragmentation and database design (online attach/detach) -Knowledge of compression | 19% |
| System Activity Monitoring and Troubleshooting | -Monitor and isolate problems using system databases -Monitor the message log file for abnormal activity -Use the Informix utilities to view information about the database server -Use the admin API to view information about the database server -Use of concurrency and locking | 14% |
| Backup and Restore | -Select the appropriate backup and restore strategy and restore utilities for a particular situation -Configure Onbar parameters for optimal backup and restore performance -Configure ontape parameters for optimal backup and restore performance -Use of operation modes | 8% |
| Performance Tuning | -Configure online shared memory parameters -Determine optimal disk layout and configuration -Utilize Parallel Database Query (PDQ) to optimize query performance -Use UPDATE STATISTICS to achieve optimal performance -Configure system for optimal checkpoint duration, recovery logs, auto checkpoints -Monitor the number of Virtual Processors (VPs) needed for the resources available -Manage network parameters for optimal communication performance -Knowledge of DSS vs OLTP tuning differences -Manage temporary tables and files | 16% |
| Replication and High Availability | -Demonstrate the ability to manage and configure ER -Demonstrate the ability to manage and configure GRID -Demonstrate the ability to manage and configure Mach 11 and HDR -Demonstrate knowledge of Connection Manager | 10% |
| Security | -Knowledge of Non OS users -Knowledge of SRL auditing / auditing -Knowledge of trusted context -Knowledge of authentication, authorization, and encryption -Knowledge of privileges -Demonstrate ability to configure a secure DBMS - Role separation | 12.5% |
| Installation and Configuration | -Determine appropriate connection types and communication protocols -Plan for Distributed System capabilities -Determine the number and size and placement of logical and physical logs to accommodate transaction activity -Determine when an instance can/should use AIO or KAIO -Set up Operating System files and parameters -Deployment assistant/ Deployment utility -Knowledge of migration and upgrading -Knowledge of installation order for multiple products -Prepare and use of user defined types | 12.5% |
| Warehousing | -Knowledge of Multi-index Star Join, Snow Flake support -Knowledge of Fragmentation -Knowledge of merge and external tables | 8% |
IBM Informix System Administrator Exam Certification Details:
| Schedule Exam | Pearson VUE |
| Exam Name | IBM Certified System Administrator - Informix 11.70 |
| Number of Questions | 63 |
| Sample Questions | IBM Informix System Administrator Sample Questions |
| Exam Price | $200 (USD) |
| Passing Score | 60% |
| Exam Code | C2090-919 |
| Duration | 90 mins |
According to the market research, we have found that a lot of people preparing for the A2090-919 exam want to gain the newest information about the exam. In order to meet all candidates requirement, we compiled such high quality study materials to help you. It is believed that our products will be very convenient for you, and you will not find the better study materials than our A2090-919 exam question. If you willing spend few hours to learn our study materials, you will pass the exam in a short time. Now we are going to introduce our A2090-919 test questions to you.
We provide practice offline in anytime
People are very busy nowadays, so they want to make good use of their lunch time for preparing for their A2090-919 exam. As is known to us, if there are many people who are plugged into the internet, it will lead to unstable state of the whole network, and you will not use your study materials in your lunch time. If you choice our A2090-919 exam question as your study tool, you will not meet the problem. Because the app of our A2090-919 exam prep supports practice offline in anytime. If you buy our products, you can also continue your study when you are in an offline state. You will not be affected by the unable state of the whole network. You can choose to use our A2090-919 exam prep in anytime and anywhere.
Printable format of the PDF version
Maybe most of people prefer to use the computer when they are study, but we have to admit that many people want to learn buy the paper, because they think that studying on the computer too much does harm to their eyes. A2090-919 test questions have the function of supporting printing in order to meet the need of customers. You can print our A2090-919 exam question on papers after you have downloaded it successfully. It not only can help you protect your eyes, but also it will be very convenient for you to make notes. We believe that you will like our A2090-919 exam prep.
We can promise 365 days free updates
In order to meet the needs of all customers that pass their exam and get related certification, the experts of our company have designed the updating system for all customers. Our A2090-919 exam question will be constantly updated every day. The IT experts of our company will be responsible for checking whether our A2090-919 exam prep is updated or not. Once our A2090-919 test questions are updated, our system will send the message to our customers immediately. If you use our A2090-919 exam prep, you will have the opportunity to enjoy our updating system. You will get the newest information about your exam in the shortest time. You do not need to worry about that you will miss the important information, more importantly, the updating system is free for you, so hurry to buy our A2090-919 exam question, you will find it is a best choice for you.
985 Customer Reviews
