Database Prefix Resolution utility (DFSURG10)

You use the Prefix Resolution utility to accumulate and sort the information that has been put on DFSURWF1 work data sets up to this point in the load or reload process.

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

Figure 1. Database Prefix Resolution utility (DFSURG10)
DFSURG10 input: DFSURCDS, SORTIN data set, and sort/merge programs. Output: DFSURWF3 work data set, DFSURIDX secondary index work data set, and output messages.
The various work data sets that could be input to the DFSURG10 utility are:
  • The DFSURCDS control data set produced by the Prereorganization utility
  • The DFSURWF1 work data set produced by the scan utility
  • The DFSURWF1 work data set produced by the HD Reorganization Reload utility

The DFSURWF1 work data sets must be concatenated to form an input data set for the Prefix Resolution utility. The name of the input data set is SORTIN.

The Prefix Resolution utility uses the z/OS® sort/merge programs to sort the information that has been accumulated. For output, the utility produces the DFSURWF3 work data set, which contains the sorted prefix information needed to resolve logical relationships. The DFSURWF3 data set will become input to the Database Prefix Update utility.

If secondary indexes exist, the utility produces the DFSURIDX work data set, which contains the information needed to create a new secondary index or update a shared secondary index database. The DFSURIDX work data set is used as input to the HISAM unload utility. The HISAM unload utility formats the secondary index information before the HISAM reload utility creates a secondary index or updates a shared secondary index database.

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