Previous Topic: Sample OutputNext Topic: REORG Syntax

Utility Statements › REORG

REORG

The REORG utility reorganizes a database by unloading data from one or more areas in one database and reloading it into one or more areas of another database.

Authorization

To

You Need This Privilege

On

Unload an area

DBAREAD

The area itself

Any area(s) with set connections to the area

Any area(s) containing an index defined on records in the area

Unload a segment

DBAREAD

All areas of the segment

Reload data into an area

DBAWRITE

The area itself

Any area(s) with set connections to the area

Any area(s) containing an index defined on records in the area

Reload data into a database

DBAWRITE

All areas into which the data is being reloaded

Any area(s) with set connections to target areas

Any area(s) containing an index defined on records in the target areas