Skip to main content

 spacer
Professional certification
spacer
  >  		spacer
Certifications
spacer
  >  		spacer
Test information

Test 918: System Administration for IBM Informix Dynamic Server V11


Overview Objectives Test Preparation

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%)


Determine appropriate connection types and communication protocols
Plan for Distributed System capabilities
Determine the number, 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
Demonstrate ability to configure a secure DBMS
Configure and manage dbspaces and sbspaces

Section 2 - System Activity Monitoring (12%)


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

Section 3 - Troubleshooting (14%)


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

Section 4 - Performance Tuning (19%)


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

Section 5 - Database Server Operations (12%)


Recognize fast recovery operations
Manage temporary tables and files
Use of operation modes

Section 6 - Backup and Restore (11%)


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

Section 7 - Replication (11%)


Demonstrate the ability to manage and configure ER and HDR
Demonstrate the ability to manage and configure Mach 11

Section 8 - SQL (8%)


Use the SQL admin API
Prepare and use user defined types
Use SQL built-in functions

Test registration

Authorized Prometric test centers (worldwide testing)