The reorganization specification designates the title of the REORGANIZATION code file for the database.

The following diagram illustrates the syntax for specifying the REORGANIZATION code file:

<reorganization specification>

── REORGANIZATION ── = ──<file title>──────────────────────────────────┤

Explanation

The file title can include a usercode and an ON <family name> specification. If the reorganization specification is not specified, the default title for the REORGANIZATION code file is REORGANIZATION/<database name>. However, it is recommended that this file title be explicitly specified.

Family substitution occurs at run time for this title.

This file title is contained in the control file. At run time, this title is used to initiate reorganization in the event that the reorganization is re-initiated automatically during a database recovery process. If a database recovery detects a reorganization that was in progress, it will restart the reorganization by executing the file title specified here. Both the usercode of the running task and the family substitution have an effect on which version, if any, of the software is found.

Example

The following statement defines the name of the REORGANIZATION code file as REORGANIZATION/<database name>. The code file is located under the USER2 usercode on the PACK2 pack.

REORGANIZATION = (USER2)REORGANIZATION/<database name> ON PACK2;