Tab navigation
- Overview
- Objectives
- Test preparation- selected tab,
Subtab navigation
This certification exam certifies that the successful candidate has important knowledge, skills, and abilities necessary to configure, install, monitor, and troubleshoot Informix Dynamic Server v11.
Study Guide for the certification test.
All Course Formats
This is the Classroom version of Instructor led online course 3X13 and replaces course 3X13.
In this course, you will learn to write queries using ANSI standard Structured Query Language (SQL) with IBM Informix extensions. You will start with simple queries to select rows from a single table, then advance to more complex queries that involve subqueries or multitable joins. You will learn how to use functions and expressions in SQL statements and how to format the query results. In addition, you will learn how to perform insert, update, and delete operations, and how to select rows that contain large object and other non-standard data types.
In this course, you will learn about the new features that are included with the 11.70 release of IBM Informix. Features include a replication grid management facility, updated installer, fragmentation enhancements, new indexing options, new query optimization features, a debugger for stored procedure language (SPL) coding, new scheduler tasks, support for system and log backup to the Cloud, and many others. A new replication grid management facility provides a central administration tool for administration of HDR primary and secondary servers, RS server, SD servers, and Enterprise Replication participants. Embeddability and deployment tools are also included to enable users to package snapshots of Informix instances and data.
In this course, you will learn the process of generating multiple copies of data at one or more sites through the planning, implementing, and administering of Informix Enterprise Replication. You will also learn how to configure remote server that can be used for hot-site backup using High Availability Data Replication (HDR) and by configuring Remote Standalone Secondary and Shared Disk Secondary servers.
The course is updated for version 11.50 of Informix, but is suitable for those still running previous versions of IDS. This course is the classroom-delivered version of Instructor Led Online course Informix Replication - Instructor Led Online (3X42) and Self Paced Virtual course Informix Replication - SPVC (2X42).
In this course, you will learn about the various Informix tools that can be used to extract the contents of database objects for safekeeping or for migration, and restoring the objects at a later time. You will learn to use the ontape and ON-Bar utilities to perform backup and restore operations on dbspaces and logical logs in the database server. As a part of learning about the ON-Bar utility, you will learn how to manage backup media using Informix Storage Manager.
The course is updated for version 11.50 of Informix, but is suitable for those still running previous versions of IDS. This course is the classroom-delivered version of Instructor Led OnLine course Informix Backup and Restore - Instructor Led Online (3X44).
This course replaces IBM Informix Stored Procedures and Triggers (IX71). This course is the classroom version of Instructor led online course IBM Informix Stored Procedures and Triggers (3X71).
In this course, you will learn to write procedures, functions, and triggers using the Informix stored procedure language. These stored procedures can then be stored within the database server and accessed by database server users.
In this course, you will develop the skills necessary to successfully administer one or more database servers. You will learn how to configure and initialize a database server instance, configure and test client connectivity, configure and manage memory and disk usage, plan and implement system maintenance tasks, and configure the server for optimal Online Transaction Processing (OLTP) or decision support.
The course is updated for version 11.50 of Informix, but is suitable for those still running previous versions of Informix. This course is the classroom-delivered version of Instructor Led Online course Informix System Administration - Instructor Led Online (3X81) and Self Paced Virtual course Informix System Administration - Self-Paced Virtual Class (2X81).
This course is intended for experienced Informix System Administrators interested in advancing their troubleshooting and monitoring skills. In this course, you will learn advanced skills for monitoring and analyzing various structures within an Informix environment. You will be presented with detailed information about the architecture of dbspaces, blobspaces, sbspaces, and their various components down to the page level. You will also learn more about virtual processors and how to monitor thread activity. You will learn more about shared memory components and how memory pools are designed and used. Finally, you will learn more in-depth details about various Informix processes, including checkpoints, physical and logical logging, and fast recovery.
The course is updated for version 11.50 of Informix, but is suitable for those still running previous versions of IDS. This course is the classroom-delivered version of Instructor Led OnLine course Informix Internal Architecture - Instructor Led Online (3X91).
Computer-based course
Course title:
IBM Informix Dynamic Server 11 System Administration Certification Preparation Tutorial Series
Course duration: 10-16 hours
Course number:
Abstract: This series of eight tutorials has been developed to help you prepare for the IBM Informix Dynamic Server 11 System Administration Certification 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 a quick registration, you can begin a tutorial. Currently parts 1 and 2 are available in this series of eight. Each tutorial should take less than two hours to complete. You can take the tutorials online, or download a PDF.
Retail Book
Geared towards database server administrators who need to get a server up and running in a short amount of time, this guide focuses on the basic skills required to administer and maintain the Informix Dynamic Server (IDS) data server. Each of the major functional areas of the database server are reviewed, including designing, initializing, monitoring, building availability layers, securing data, and the data processing environment. This book reviews how the IDS works, how to install it, how to configure a database environment, back up, recovery, and includes an introduction to monitoring instance operations, making it useful to current IDS users who need to upgrade from earlier versions of the data server as well as those who have never used IDS before.
Register for a test
Register for an IBM Certification test at Prometric and take a step into your future.