The first time you sign into developerWorks, a profile is created for you. Select information in your profile (name, country/region, and company) is displayed to the public and will accompany any content you post. You may update your IBM account at any time.

All information submitted is secure.

The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerworks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

All information submitted is secure.

My developerWorks:

My notifications:

Sign out

Select a language:

Informix Dynamic Server 11.50 Fundamentals Exam 555 certification preparation, Part 7: Tools and utilities

Joo Guan Yap (yapjg@sg.ibm.com), Advanced Support Engineer, IBM

Joo Guan graduated from Nanyang University of Singapore with a Bachelor of Applied Science (Computer engineering) Degree in 1996 and was involved in various IT development projects. He joined IBM Informix support in 2001 and is now involved in Advanced Support work.

Summary: With a good understanding of the tools and utilities that come with IBM® Informix® Dynamic Server (IDS), you'll find the database easier to monitor and administer. In this tutorial, learn about those tools. This is the seventh of a series of nine tutorials that will help prepare you for IDS exam 555.

View more content in this series

Date: 17 Sep 2009
Level: Introductory
PDF: A4 and Letter (670 KB | 49 pages)Get Adobe® Reader®

Activity: 15264 views
Comments:

Before you start

About this series

This complimentary series of nine tutorials has been developed to help you prepare for the IBM Informix Dynamic Server 11.50 Fundamentals certification exam (555). This certification exam will test your knowledge of entry-level administration of IDS 11.50, including basic SQL (Structured Query Language), how to install IDS 11.50, how to create databases and database objects, security, transaction isolation, backup and recovery procedures, and data replication technologies and purposes. 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.

About this tutorial

This tutorial describes the tools and utilities available in IBM Informix Dynamic Server (IDS) 11.50.

Objectives

At the end of the tutorial, you should be able to:

Describe onstat, oninit, and onmode utilities
Demonstrate knowledge of data movement utilities
Describe the sysadmin database and its functionality
Demonstrate knowledge of the features or functions available in OpenAdmin Tool and dbaccess

Prerequisites

This tutorial is written for users with basic knowledge of Structured Query Language (SQL).

System requirements

To understand and test the concepts discussed in this tutorial, you need a running instance of IDS 11.50.

Comments