INFORMIX-OnLine Dynamic Server System Administration: The High Performance Loader

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

The course INFORMIX-OnLine Dynamic Server System Administration: Managing the Instance; 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 use OnLine's High Performance Loader

Learning Objectives

Describe the High Performance Loader (HPL). List the components of HPL and outline its architecture. Describe the OnLine environment variables used for HPL. Describe the organization of load and unload jobs. Define device arrays, formats, queries, maps, and filters. Explain the uses of the generate feature in load and unload jobs. Create a job using the generate function. Discuss the various loading objects. Use the browsing options to preview data file options. Monitor the HPL. Connect to a job while it's running. Use the onstat utility's -j option. Identify ways of optimizing HPL performance.

Topics Covered

Features of the High Performance Loader - What is the HPL? - HPL architecture - The HPL and OnLine Defining HPL components - Organizing HPL tasks - Defining device arrays - Defining formats - Defining queries - Defining maps - Defining filters Loading and unloading data - The generate feature - Load and unload options Monitoring performance - Browsing options - Monitoring HPL utilities Performance hints - Optimizing load and unload options - Maximizing parallelism