For optimal performance, the server can tune the following server options automatically:
To have the server automatically tune the MOVEBATCHSIZE and MOVESIZETHRESH options, set the SELFTUNETXNSIZE option to Yes. When the server performs an internal data movement operation, such as migration, reclamation, move data, storage pool backup/restore, it will adjust these values to achieve optimal performance. To prevent running out of log space during these operations, use the DEFINE SPACETRIGGER command to allow for expansion of the recovery log.
To have the server automatically tune the BUFPOOLSIZE option, set the SELFTUNEBUFPOOLSIZE option to Yes. Before expiration processing, the server resets the database buffer pool and examines the database buffer pool cache hit ratio. The server accounts for the amount of available storage and adjusts the buffer pool size as needed.
To have the server automatically tune the TXNGROUPMAX option, set the SELFTUNEBUFPOOLSIZE option to Yes. The server uses the value specified in the server options file and adjusts it for each node until it obtains the best performance. It is recommended that the client specify the maximum transaction byte limit and rely on the server's TXNGROUPMAX value adjustment to reduce the client's overall session time.
For information about the SELFTUNEBUFPOOLSIZE and SELFTUNETXNSIZE server options, refer to Administrator's Reference.