Home | Previous Page | Next Page Disk, Memory, and Process Management >

Loading with External Tables for Extended Parallel Server

In This Chapter

Getting an Overview of High-Performance Loading

Loading and UnLoading Data

Using the Reject File and Violations Table to Handle Load Errors

Setting Up Loading and Unloading Tasks

Data-Format Conversion

File Types and Formats

Starting to Load and Unload Data

Specifying the External Table

Loading Data in Express Mode

Loading Data in Deluxe Mode

Loading, Unloading, and Reorganizing Data

Loading from a Delimited File with Unchanged Columns

Unloading to a Delimited File

Mapping Columns to Other Columns

Unloading to an Informix Data File

Loading Between Tables That Have the Same Schema

Loading from a Fixed-ASCII File

Unloading to a Fixed-ASCII File

Loading from an IBM Fixed-EBCDIC File

Loading from and Unloading to a Named Pipe

Loading with Named Pipes

Using FIFO Virtual Processors

Unloading with Named Pipes

Adding an End-of-Line Character to a Fixed-ASCII File

Using a Program or Script

Adding a Newline Field in a SELECT Statement

Loading Values into Serial Columns

Loading Data Warehousing Tables

Loading Initially

Refreshing Periodically

Refreshing Frequently or Continuously

Initial Loading of OLTP Data from Other Database Servers

Loading Simple Large Objects

Formats for Simple Large Objects

Using Informix Internal Format

Using Delimited Format

Loading Simple Large Objects from an External Table

Using Pipe Staging

Using Parallel Execution

Using Temporary Space for Pipe Staging of Simple Large Objects

Monitoring the Load or Unload Operations

Monitoring Frequent Loads and Unloads

Monitoring FIFO Virtual Processors

Monitoring Loads and Unloads of Data

Using SET EXPLAIN ON Output

Using onstat to Monitor Pipe Staging

Recovering After Errors

Recoverability of Table Types

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]