New Features › CA Datacom/DB Enhancements › DBUTLTY Dynamic Extend

DBUTLTY Dynamic Extend

When executing the DBUTLTY LOAD function, if the input data does not fit within the existing extents of the data area being loaded, an enhancement to the LOAD function attempts to dynamically extend the existing extents, with restrictions. Details of the dynamic extend match those that would occur in the Multi-User Facility (MUF) during ADDIT processing.

Additionally, a dynamic extend is attempted when executing the DBUTLTY LOAD and RETIX functions, if the index that is needed does not fit within the existing extents of the Index Area (IXX) or Index Areas. The RECOVERY function supports dynamic extend for both the Index and data areas.

In the cases just described, the Datadictionary attributes for dynamic extend are honored, and the DBUTLTY functions involved do not have independent keywords or options. These attributes, as during ADDIT processing, are subject to the many rules of the operating system.

There are restrictions that, if not met, prevent dynamic allocation from being attempted. The restrictions specific to the DBUTLTY functions are as follows:

• For the RETIX and LOAD functions, the SORT= keyword must be specified, and with a value other than zero. Only the code path using a SORT= contains the option to dynamic extend. There is no message generated if this requirement is not met.
• Every table in the database must have been defined with the Datadictionary attribute RECOVER YES. There is no message generated if this requirement is not met.
• For the RETIX and RECOVERY functions, the area must have been loaded with YES specified for the URI option. For the LOAD function, YES must have been specified for the URI option or allowed to default to YES for URI. There is no message generated if this requirement is not met.