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: 15287 views
Comments:

Conclusion

This tutorial has introduced the various tools and utilities that are available with IDS to ease administration tasks. At the end of this tutorial, you should be able to:

Use oninit and onmode utilities to change the mode of the database server
Use onstat to monitor the database server
Use the available data movement utilities to move database objects and data between databases
Describe functionality of sysadmin database and SQL Admin API
Demonstrate knowledge of the features available in dbaccess and OAT