Control statements for the DFSURGU0 utility

You can use the following utility control statements for the DFSURGU0 utility: PARTITION, MIGRATE, KEYRANGE, MIGRATX,and FALLBACK

All of the utility control statements that are used by the HD Reorganization Unload utility (DFSURGU0) specify options for processing HALDB databases or for converting databases to HALDB.

The PARTITION utility control statement must conform to the following:


>>-PARTITION--=partname--+------------+--+----------------+----><
                         '-,NUMBER=nn-'  |        .-DET-. |   
                                         '-,STAT=-+-SUM-+-'

PARTITION=: Specifies the name of a HALDB partition (or the first of several sequential HALDB partitions) to unload.
NUMBER=: Specifies the number of sequential HALDB partitions to unload. The default setting is 1.
STAT=: Specifies whether to generate partition statistics. Partition statistics are generated if STAT=DET. Partition statistics are not generated if STAT=SUM. The default setting is STAT=DET.; SUM produces a summary report for all partitions processed. This option suppresses detail reports.; DET produces a detail report. The detail report includes the statistics by partition in addition to the summary report. This is the default.

This utility control statement is provided in a SYSIN stream.


>>-MIGRATE=YES-------------------------------------------------><

MIGRATE=: Specifies whether to unload a non-HALDB database for migration. A DD card is required for all of the related secondary index databases.


>>-KEYRANGEFROMKEYfromkeyvalTOKEYtokeyval--KEYLENkeylenval-----><

KEYRANGE

KEYRANGE is designed to increase the performance of Unload, when migrating a non-HALDB to a HALDB, by running multiple unload jobs in parallel. Invoke this function by adding a KEYRANGE statement in column 1 immediately after a MIGRATE= statement. KEYRANGE is not valid after a MIGRATX= statement.

Specify key ranges using the FROMKEY, TOKEY, and KEYLEN parms.

fromkeyval: Use either zeros, or the high key of a previous partition definition, expressed in hexadecimal.
tokeyval: The high key of the destination partition's definition expressed in hexadecimal.
keylenval: The length of the key specified as an alphanumeric value.


>>-MIGRATX=YES-------------------------------------------------><

MIGRATX=: MIGRATX creates unload files for secondary index datasets in addition to the primary data set. It eliminates the need to run multiple migration HD Reorganization Unload utility jobs for migration to PSINDEX by creating multiple work files from a single pass of the database for each indexed source segment. Corresponding sort control statements are generated for each work file. The sorted file is then usable as input to the HD Reorganization Reload utility to load the PSINDEX. DFSWRKnn and DFSSRTnn DD cards are required for each secondary index database referencing the primary database being unloaded.


>>-FALLBACK=YES------------------------------------------------><

FALLBACK=: Specifies the unload of a HALDB database for fallback, creating fallback records.