The DMReorganization specification designates the title of the reorganization using the DMREORG option for the database. The DMREORG reorganization is a nontailored reorganization program and is compatible with any database on the same level. Using DMREORG reorganization increases the limit of the structures that can be reorganized in a single reorganization from 300 to 2,500 structures. It supports OFFLINE and REORGDB reorganizations. Refer to the Enterprise Database Server for ClearPath MCP Utilities Operations Guide (8600 0759), section 7 Reorganizing the Database for more information about DMREORG reorganization.

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

── DMREORGANIZATION ── = ──<file title>─────────────────────────────────────┤

Explanation

The file title can include a usercode and an ON specification. If the DMREORG reorganization specification is not specified, the default title for the DMREORGANIZATION code file is SYSTEM/REORGANIZATION. 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 DMREORG 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 DMREORGANIZATION code file as SYSTEM/REORGANIZATION. The code file is located under the USER2 usercode on the PACK2 pack.

 DMREORGANIZATION = (USER2)SYSTEM/REORGANIZATION ON PACK2;