The DBUTLTY RETIX function has a new keyword, SORTDFLT=, that allows the SORT value when specified as greater than 0 for a RETIX to be overridden with an estimate expected to be more accurate. SORTDFLT= can only be used in conjunction with the SORT= keyword. When set as SORTDFLT=YES, the RETIX uses the current CXX count of records and definition to calculate a value for the SORT= override. If the count is zero (no records) for all tables to be loaded then the SORT=n value is used and not overwritten. Verify that it is in the appropriate range to allow a successful RETIX.
The record count and the number of key definitions per table are multiplied for each table to be loaded and the products are summed as the estimate for record index entries. Based on the areas space management (DSOP) options, additional counts are added to verify a successful sort.
When using this DBUTLTY RETIX enhancement, take into consideration that the number of records in a table after a MUF outage is likely to be inaccurate.
(z/OS only) As previously noted, the SORT= value can now be overridden with what is expected to be a more accurate number. SORTDFLT= can be set to the following:
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|