CLEANUP

The CLEANUP utility physically erases logically deleted records from all or some areas in a database segment.

The CLEANUP utility works only with non-SQL-defined databases.

Authorization

To	You need this privilege	On
Clean up an area	DBAWRITE	The area
Clean up a segment	DBAWRITE	All areas within the segment

CLEANUP Syntax

►►─── CLEANUP SEGMENT segment-name ───────────────────────────────────────────►

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

 ►─┬─────────────────────────┬────────────────────────────────────────────────►◄
   │         ┌──────,──────┐ │
   └─ AREA ──▼─ area-name ─┴─┘

CLEANUP Parameter

SEGMENT

Specifies the segment containing the areas to be processed.

segment-name

The name of the segment.

USING

Specifies a subschema that describes all the sets, records, and areas that are related to the logically deleted records being processed.

subschema-name

The name of the subschema.

AREA

Specifies one or more areas within the segment to process.

By default, if you do not specify any areas, all areas in the specified segment are processed.

area-name

The name of an area within the specified segment.