6. QUEL and EQUEL Statements : Copy Statement--Copy Data : WITH Clause for COPY : Allocation Option
 
Share this page                  
Allocation Option
To specify the number of pages initially allocated to the table or index, use the with allocation option. By allocating disk space to a table, you can avoid runtime errors that result from running out of disk space.
The number of pages specified must be between 4 and 8,388,607 (the maximum number of pages in a table). If the specified number of pages cannot be allocated, the modify statement is aborted.
You can modify a table to a smaller size. If the table requires more pages that you specify, the table is extended and no data is lost. You can modify a table to a larger size, to reserve disk space for the table.
If the table is spread across multiple locations, space is allocated across all locations.