As your database grows, it is crucial to manage data loading
properly.
These features ensure that your loads can scale to meet your
needs:
Buffer manager partitioning to avoid lock contention. Buffer partitioning based
on the number of CPUs is enabled by default, and can be
adjusted by setting server or database options.
Allowing sufficient memory for loads, without allocating more memory than is
available on your system.
Reserving space for data structures used during release savepoint, commit, and
checkpoint operations.
Reserve IQ main
store space using the MAIN_RESERVED_DBSPACE_MB
Option.