14.5.7 Notes
- In the following cases, the free space reusage facility will not function:
- When data is stored using the hash facility for hash row partitioning
- When data dictionary tables are stored
- When data is stored in tables by means of data loading or by the database reorganization facility (pdrorg)
- When there is a user LOB RDAREA
- When the free space reusage facility is used, page search processing is slower when free space due to deletions is not contiguous than when free space due to deletions is contiguous. In such a case, consider stopping the free space reusage facility or consider reorganizing the data with the database reorganization utility (pdrorg).
- When the free space reusage facility is used with variable-length rows (including BINARY type), even if there is the same volume of additions and deletions, the number of segments used may increase.
- Even when searching is executed in the free page reuse mode, deleted space cannot be reused within the same transaction.