The Sort Sets on Reorg configuration property, under the Installation category, of the Segment applies only to sets and subsets that are being created from their dataset records.
In Agile Business Suite terms, a set is a Profile, a subset is a Profile Condition, and a dataset is a <<Ispec>> class Direction that is Out, or InOut Ispec (Ispec or Event).
Note: The Sort Sets on Reorg configuration property, under the Installation category, of the Segment is optional if you are using online reorganization.
When a set or subset is changed, the set or subset is recreated from the existing set or subset. Generally, the creation of sets and subsets from the existing sets and subsets is the most efficient mechanism to use.
When it is not possible to create a set or subset from the existing set or subset, DMS II creates the set or subset from its dataset.
When a set or subset is created from the dataset without the Sort Sets on Reorg configuration property, under the Installation category, of the Segment set to True, the DMS II process creates the set or subset structure by reading a dataset record and then creating the matching set or subset table entry. This procedure is repeated for each appropriate dataset record.
If you check the Sort Sets on Reorg configuration property, under the Installation category, of the Segment, any creation of a set or subset from the dataset causes the set or subset to be created from a sorted interim file. DMS II extracts all the required dataset details to an interim file, sorts the file, and then creates the set or subset structure from that sorted file.
Refer to the Enterprise Database Server for ClearPath MCP Utilities Operations Guide for more information on sorting sets on reorganization.
Impact of Using Sort Sets
Reorganizations of sets and subsets over large datasets might be considerably faster if the Sort Sets on Reorg configuration property, under the Installation category, of the Segment is set to True.
The reorganization of small sets and subsets does not benefit from this option, and might result in longer reorganization times.
Any set or subset being created from the dataset is not available until the full set or subset is created. The dataset is also unavailable for access for the creation and deletion of records.
Any program attempting to access a set, subset, or dataset under these circumstances waits until the creation is complete or the program times out due to the MAXWAIT setting, unless the transaction is interrupted by other factors, such as a DMS II deadlock. MAXWAIT is defined and altered by changing the MAXWAIT parameter in the Generate and Configure WFLs.
If you set to True the Sort Sets on Reorg configuration property, under the Installation category, of the Segment, it applies to all sets and subsets that are being created from their datasets in the reorganization.
You can use sort sets with the across-hosts BNA generate facility.
When to Use Sort Sets
The Sort Sets on Reorg configuration property, under the Installation category, of the Segment should be set to True, when you are reorganizing large sets or subsets and you do not need your application running during the reorganization.
The exact point at which an additional sort is more efficient depends on the following factors:
Number of records in the set or subset
Whether duplicates are present
Whether the DASDL option DUPLICATES LAST is defined
Generally, if you have more than approximately 200,000 records in your set or subset, you should benefit from sorting. If you have a number of duplicates, and they are defined as DUPLICATES LAST, you should have an additional performance benefit.
DUPLICATES LAST is the standard Builder default. You can alter this option by changing the User DASDL options associated with each Profile in Builder.
Note: The Sort Sets on Reorg property is valid for population change, but not for garbage collection when using the Database Management Utility (DMU).
How to Enable Sort Sets
To select this option for a configuration to be used either for generation or for subsequent transfer and configuration, check the Sort Sets on Reorg configuration property, under the Installation category, of the Segment.
To select this option when using the Configure Utility to configure a transferred application on the target host (when a configuration was not specified for the generate or transfer), select the Sort Sets on Reorg check box on the Configure Utility Environmental Options screen.
To select this option for population changes when using the Database Management Utility (DMU), select the Sort Sets on Reorg check box on the DMU main option screen.