Previous Topic: Loading ProceduresNext Topic: Full Load Procedure


Steps That Apply to All Load Procedures

Steps Before the Load

Regardless of what load procedure you use, perform the following actions before loading the data:

Action

Statement

Define the tables to be loaded

CREATE TABLE

Create the input file or files of data to be loaded using CA Culprit, CA OLQ (batch), or a user-written program

 

Vary the areas in which the tables reside offline to DC/UCF

BACKUP or a comparable backup utility

Steps After the Load

After loading the data, perform these steps:

Action

Statement

Optionally, verify the result by retrieving data from the loaded tables

SELECT statements

Back up the areas in which the tables reside

BACKUP or a comparable backup utility

Vary the areas online

DCMT VARY AREA with the ONLINE option