Description

Purpose

The MAINTAIN ASF utility statement deletes, loads, or extends an ASF-defined table.

You can run MAINTAIN ASF all at once or break it into steps.

Authorization

You must have DBAWRITE authority on the area(s) containing the table and its associated index(es).

Stick.Syntax

►►─── MAINTAIN ASF ───────────────────────────────────────────────────────────►

 ►─── IN SEGMENT segment-name ────────────────────────────────────────────────►

 ►─── USING subschema-name ───────────────────────────────────────────────────►

 ►─┬────────┬─────────────────────────────────────────────────────────────────►
   └─ TEST ─┘

 ►─┬──────────────────────────────┬───────────────────────────────────────────►
   └─ NOTIFY notify-record-count ─┘

 ►─┬──────────────────────┬───────────────────────────────────────────────────►
   ├─ FROM ─┬─ step-name ─┘
   └─ STEP ─┘

 ►─┬─ DELETE ─┬─┬─ TABLE table-definition-number ─┬─┬─────────────┬───────────►
   ├─ LOAD ───┤ └─ RECORD record-name ────────────┘ ├─ CONNECT   ─┤
   └─ EXTEND ─┘                                     └─ NOCONNECT ─┘

 ►─┬─────────────────────┬────────────────────────────────────────────────────►
   └─ RECFORM ─┬─ F ───┬─┘
               └─ V ───┘

 ►─┬────────────────────────┬─────────────────────────────────────────────────►
   └─ INPUT input-filename ─┘

 ►─── as SORTEXIT ────────────────────────────────────────────────────────────►

 ►─── REUSE workfiles ────────────────────────────────────────────────────────►◄

Parameters

IN SEGMENT

Specifies the segment containing the table to be processed.

segment-name: The name of the segment.

USING

Specifies the subschema that defines the table.

subschema-name: The name of the subschema.

TEST

Processes only the first 100 records of the database.

See "Usage", below.

NOTIFY

Directs MAINTAIN ASF to send a message to the operator whenever a specified number of rows have been processed.

The message states the step currently being executed and the number of rows that have been processed.

notify-record-count: The number of records to process before sending a message.

FROM

Specifies that MAINTAIN ASF should begin at a specified step and complete all remaining steps.

step-name

The name of the first step that MAINTAIN ASF should execute.

If the specified restart step is any step except IDMSTABX, all other parameters are ignored. In this case, MAINTAIN ASF gets the information normally provided by the other parameters from the intermediate work files.

STEP

Directs MAINTAIN ASF to execute only one step of the table maintenance process.

By default, if you do not specify STEP, MAINTAIN ASF will perform all steps.

If the specified step is any step except IDMSTABX, all other parameters are ignored. In this case, MAINTAIN ASF gets the information normally provided by the other parameters from the intermediate work files.

step-name

The name of the first or only step to execute.

The name must be one of the following:

IDMSTABX
SORT3
IDMSDBL3
SORT4
IDMSDBL4

DELETE

Directs MAINTAIN ASF to erase all rows of the specified table, and all associated index structures. The table definition remains intact.

LOAD

Directs MAINTAIN ASF to load the specified table from an external file.

All indexes associated with the table must be empty.

EXTEND

Directs MAINTAIN ASF to add rows to the existing specified table.

At least one index must not be empty. If all indexes are empty, MAINTAIN ASF will perform a LOAD.

TABLE

Specifies the table with its table definition number.

"table-definition-number"

The table definition number assigned to the table when it was created.

The table definition must be enclosed in double quotes.

RECORD

Specifies the table with its record name.

"record-name"

The record name by which the table is identified in the schema.

The record name must be enclosed in double quotes.

CONNECT

Directs MAINTAIN ASF to connect all rows added during a LOAD or EXTEND operation to all manual and automatic indexes.

By default, if you do not specify CONNECT or NOCONNECT, MAINTAIN ASF will connect added rows to the indexes.

NOCONNECT

Directs MAINTAIN ASF not to build index structures during the LOAD or EXTEND operation.

If you specify NOCONNECT, you must use the MAINTAIN INDEX utility at a later time to build the index(es).

For more information on the MAINTAIN INDEX utility, see CA IDMS Utilities Guide

RECFORM

Specifies whether the input file has a fixed or variable format.

By default, if you do not specify a format, MAINTAIN ASF assumes the file has a fixed format.

F

Specifies that the file has a fixed format.

This is the default.

V

Specifies that the file has a variable format.

INPUT input-filename

Specifies the DD/ASSIGN/FILEDEF/FILE statement in the JCL that contains the input for a LOAD or EXTEND operation.

By default, if you do not specify a DD/ASSIGN/FILEDEF/FILE, MAINTAIN ASF uses SYS001.

as SORTEXIT

Causes each DBLx step in the utility to return its input data directly from the preceding sort instead of having the sort write the data to a workfile. This option eliminates one workfile for each sort and saves the I/O it takes to write then read the workfile.

REUSE workfiles

Causes each step in the utility to reuse an existing workfile, if possible, when writing its output data, instead of writing to a new one for each step. This reduces the number of workfiles that need to be allocated.