Freespace Check 

Before a reorganization, SAPDBA checks whether the relevant tablespace contains enough space for the object at hand.

The import check always takes into account:

  1. All the extents to be generated according to the number of MINEXTENTS for all the tables to be reorganized (one INITIAL extent and (MINEXTENTS-1) NEXT extents).
  2. All other NEXT extents of tables to be expected during the data import (this number is determined from the old total size allocated or from the total size of the tables determined by Reduce object size: yes).
  3. All expected INITIAL and NEXT extents of all indexes to be reorganized (as in nos. 1 and 2).
  4. Reserve space (the size of the largest NEXT extent or at least 120 KB).

The import checks are described in the following sections: