DBUTLTY LOAD fails with DB13012E - INSUFFICIENT SPACE IN AREA. Why did the LOAD not perform a dynamic extend?

Document ID : KB000045812
Last Modified Date : 14/02/2018
Show Technical Document Details

Question: 

DBUTLTY LOAD fails with DB13012E - INSUFFICIENT SPACE IN AREA. The area is defined with DYNAMIC-EXTEND YES. Why did the LOAD not perform a dynamic extend on the area?

 

Answer: 

There are some restrictions on when dynamic extend will be attempted for a LOAD.

This is documented in https://Docops.ca.com in section DBUTLTY Dynamic Extend Considerations

  • 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.

Most likely these conditions are not met so the extend was not performed.