Using CA Datacom/DB Utility (DBUTLTY) › DBUTLTY Dynamic Extend Considerations

DBUTLTY Dynamic Extend Considerations

When executing the DBUTLTY LOAD and RECOVERY functions, if the input data does not fit within the existing extents of the data area being loaded, the LOAD function attempts to dynamically extend the existing extents, with restrictions. Details of the dynamic extend match those that would occur in the MUF during ADDIT processing. Additionally, a dynamic extend is attempted when executing the DBUTLTY LOAD, RECOVERY, and RETIX functions, if the index that is needed does not fit within in the existing extents of the Index Area (IXX) or Index Areas.

In all of the cases just described, the CA Datacom 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.

The dynamic extend feature is automatic, if all requirements are in place, and there are no DBUTLTY keywords needing to be specified. There are restrictions, however, 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 CA Datacom Datadictionary attribute RECOVERY 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.

For more information about the DYNAMIC_EXTEND console-like command, see the CA Datacom/DB Database and System Administration Guide.