Version 14.0 › CA Datacom Tools Products › New Features and Enhancements › DBUTLTY Features › DBUTLTY LOAD Function Sort Default (SORTDFLT=)

DBUTLTY LOAD Function Sort Default (SORTDFLT=)

The DBUTLTY LOAD function has a new keyword, SORTDFLT=, that allows the DBUTLTY SORT value when specified as greater than 0 for a LOAD 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 LOAD looks for record counts in the control records of the BACKUP input or the current CXX to use for the SORT= override. If the count in both places 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 LOAD.

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 LOAD enhancement, consider the following:

• The number of records in a table is not always known.
• The number of records in a table after a MUF outage is likely to be inaccurate.
• A backup taken before Version 12.0 does not include information regarding the record count.
• The backup with Version 12.0 or later has the count as stored in the CXX at the time of the backup.
• Extract files never have a count, because they have no control records.
• For each table, the record count in the BACKUP control record is used if known and not zero, otherwise, the current CXX record count is used. Either could be more accurate.
• The record count information from BACKUP input is taken from the control records that exist before the first data record, and any use of concatenated input is inappropriate to using the SORTDFLT=YES option, for example, if a database has two areas and they are each backed up separately. That is, if the two backups are concatenated into one base load, the control records at the start of the first input provide information about the first area, but the control records for the second input are not seen until the first area is complete, which is therefore too late to use to start the SORT. The pairing of base backups with base loads and area backups with areas loads do not have this issue.

SORTDFLT=

(z/OS only) As previously noted, the DBUTLTY SORT= value can now be overridden with what is expected to be a more accurate number. SORTDFLT= can be set to the following:

• YES - SORT value must be specified with a value greater than zero
• NO - Default

Note: The option has no equivalent in the DBFLSUB process.