Regular Procedures › Database Areas Extensions › Extending an Area

Extending an Area

When a database file is allocated, it should be allocated with primary and secondary allocation. This allows you to run the DBUTLTY EXTEND function. You cannot run this function when the database is open. When the CA Datacom/DB area becomes full, add additional space to the area by executing the DBUTLTY EXTEND function. For more information, see the CA Datacom/DB DBUTLTY Reference Guide.

You can use the following ways to enlarge an area:

• Use DBUTLTY BACKUP, DELETE, RE-ALLOCATE LARGER, INIT, LOAD for a data area or Delete, re-allocate larger, DBUTLTY INIT and RETIX
• Use the DBUTLTY EXTEND function to perform the following:
  • Dynamically allocate a secondary extent
  • Supply a secondary space override using JCL
  • Extend the area to another DASD volume
  • Enlarge the area using a non-Datacom utility but then use EXTEND to format the excess blocks
• Extend data and Index Areas dynamically when they become full if the database definition has specified DYNAMIC EXTEND=YES and DYN.EXT.TRACKS

For more information about creating and maintaining data and Index Areas, see the appropriate chapters in the CA Datacom/DB Database and System Administration Guide.