The IBM® Certified System Administrator exam for IBM Informix® Dynamic Server 11 (Exam 918) demonstrates knowledge, skills, and abilities necessary to configure, install, monitor, and troubleshoot Informix Dynamic Server 11. Significant experience as an IDS 11 system/database administrator is required. Topics include installation and configuration, system activity monitoring, troubleshooting, performance tuning, database server operations, backup and restore, replication, and SQL.
In this series
This series of eight free tutorials is designed to help you prepare for the IBM Certified System Administrator: IBM Informix Dynamic Server 11 certification exam (Exam 918). These tutorials provide a solid base for each section of the exam. However, you should not rely on these tutorials as your only preparation for the exam.
After completing this tutorial, take an assessment exam to test your proficiency. For more information about assessment tests, visit Information Management Certification Online Assessment Tests. When you are ready, schedule your certification exam. IBM exams are offered worldwide at Prometric Testing Centers. To find a site near you, call Prometric at (800) 959-EXAM (3926) or visit Prometric.com.
After a quick registration, you can begin a tutorial. Each tutorial should take about an hour to complete. You can take the tutorials online or download a PDF.
-
"System Administration
Certification exam 918 for IBM Informix Dynamic Server 11
prep, Part 1: Installation and configuration"
Install and configure IDS 11, manage space and logs, and configure the different security options available in IDS.
-
"System Administration
Certification exam 918 for IBM Informix Dynamic Server 11
prep, Part 2: System activity monitoring"
Learn to monitor database server activity for IDS. Examine various tools to monitor, diagnose problems, and manipulate IDS data.
-
"System Administration
Certification exam 918 for IBM Informix Dynamic Server 11
prep, Part 3: Troubleshooting"
Explore the topic of troubleshooting for IDS. After a brief overview, learn about the various tools that are available for troubleshooting, then look at examples of how to examine the database server to solve problems.
-
"System Administration
Certification exam 918 for IBM Informix Dynamic Server 11
prep, Part 4: Performance tuning"
Tune IDS 11 and its subsystems for optimum performance. Follow along with examples on how to look at the database server and its subsystems.
-
"System Administration
Certification exam 918 for IBM Informix Dynamic Server 11
prep, Part 5: Database server operations"
Gain an understanding of the operating modes for IDS 11. Learn to identify and change each operation mode, as well as what takes place in each operation mode.
-
"System Administration
Certification exam 918 for IBM Informix Dynamic Server 11
prep, Part 6: Backup and restore"
Explore IDS database backup and restore concepts and strategies. Learn utilities and commands for managing your database backup and restore processes.
-
"System Administration
Certification exam 918 for IBM Informix Dynamic Server 11
prep, Part 7: Informix Dynamic Server replication"
Configure and manage all forms of replication options available with Informix Dynamic Server 11.
-
"System Administration
Certification exam 918 for IBM Informix Dynamic Server 11
prep, Part 8: SQL features for administrators"
Use the new SQL features in Informix Dynamic Server 11 to perform administrative tasks, improve query performance, manage data security, and manipulate data.


