Database Prereorganization utility (DFSURPR0)

The Database Prereorganization utility (DFSURPR0) runs before you load or reorganize databases that have secondary indexes or logical relationships.

You use the Database Prereorganization utility when:
  • A database to be initially loaded or reorganized has secondary indexes or logical relationships
  • A database not being initially loaded or reorganized contains segments involved in logical relationships with databases that are being loaded or reorganized

The following figure shows the input to and output from the Database Prereorganization utility.

Figure 1. Database Prereorganization utility (DFSURPR0)
DFSURPR0 input: IMS.DBDLIB and control statements. Output: DFSURCDS control data set, Scan control list, and output messages.

The DFSURPR0 utility produces the DFSURCDS control data set, which contains information about what pointers need to be resolved later if secondary indexing or logical relationships exist.

The DFSURCDS control data set produced by the Prereorganization utility is used as input to the following:
  • The Database Scan utility, if that utility needs to be run
  • The HD Reorganization Reload utility, if secondary indexing or logical relationships exist
  • The Database Prefix Resolution utility, after the database is loaded or reloaded

The Prereorganization utility also produces a list of which databases not being initially loaded or reorganized contain segments involved in logical relationships with the database that is being initially loaded or reorganized.

This utility is always run before the database is loaded (for initial load) or reloaded (for reorganization).