INFORMIX-OnLine Dynamic Server System Administration: Configuring for Optimal Performance

Course Status:	Released	Courseware Features
Course Language:	English
Course Duration:	4 Hours
Deployment Options:	Online, Interactive CDs, Network, Downloads, Intranet

Audience

Application developers, database and system administrators, and technical support personnel

Prerequisites

Previous courses from the INFORMIX-OnLine Dynamic Server System Administration suite; the course Relational Principles and the SQL Programming suite; a knowledge of the UNIX operating system is necessary (refer to the UNIX curriculum); an understanding of client/server technologies, though not a strict prerequisite, would be useful

Course Aim

To enable the student to configure their OnLine system for optimal performance

Learning Objectives

Explain how OnLine configuration and resources can affect system performance. Describe how to measure the performance of your OnLine system. Describe how to monitor the use of system resources. Discuss the performance factors that determine the placement of tables in your OnLine system. Describe how indexes can affect table performance. Explain how the layout of tables across extents can affect performance. Describe how to optimize your client/server environment. Identify ways to improve network communication. Describe how to configure poll threads for large environments. Discuss ways of monitoring network performance.

Topics Covered

Performance basics - Performance issues - Resource utilization Database optimization - Table and data placement - Indexing strategies - Managing extents Optimizing client/server environments - Client applications - Configuring poll threads - Remote configurations