Test 000-918: System Administration for IBM Informix Dynamic Server V11

The test contains eight sections totalling approximately 74 multiple-choice questions.  The percentages after each section title reflect the approximate distribution of the total question set across the sections.

Section 1 - Installation and Configuration (14%)

1. Determine appropriate connection types and communication protocols
2. Plan for Distributed System capabilities
3. Determine the number, size and placement of logical and physical logs to accommodate transaction activity
4. Determine when an instance can/should use AIO or KAIO
5. Set up Operating System files and parameters
6. Demonstrate ability to configure a secure DBMS
7. Configure and manage dbspaces and sbspaces

Section 2 - System Activity Monitoring (12%)

1. Monitor activity using sysmaster, sysadmin and onstat utilities
2. Monitor the message log file for abnormal activity
3. Use the oncheck command /SQL API to view information about the database server

Section 3 - Troubleshooting (14%)

1. Isolate problems using systmaster, systadmin, onstat utilities
2. Use concurrency and locking

Section 4 - Performance Tuning (19%)

1. Recognize Operating System resources affecting system operations
2. Configure shared memory parameters
3. Determine optimal disk layout and configuration
4. Utilize Parallel Database Query (PDQ) to optimze query performance
5. Use UPDATE STATISTICS to achive optimal performance
6. Configure system for optimal checkpoint duration
7. Monitor the number of Virtual Porcessors needed for the resources available
8. Manage network parameters for optimal communcation performance

Section 5 - Database Server Operations (12%)

1. Recognize fast recovery operations
2. Manage temporary tables and files
3. Use of operation modes

Section 6 - Backup and Restore (11%)

1. Select the appropriate backup and restore strategy and restore utilities for a particular situation
2. Configure Onbar parameters for optimal backup and restore performance
3. Configure ontape parameters for optimal backup and restore performance

Section 7 - Replication (11%)

1. Demonstrate the ability to manage and configure ER and HDR
2. Demonstrate the ability to manage and configure Mach 11

Section 8 - SQL (8%)

1. Use the SQL admin API
2. Prepare and use user defined types
3. Use SQL built-in functions