CONTROLPOINT is a dynamic database parameter that specifies the number of syncpoints that occurs before a new controlpoint.

After every syncpoint, the value of the CONTROLPOINT parameter is compared with the current number of syncpoints. If the current number of syncpoints is equal to the value of the CONTROLPOINT parameter, the last syncpoint is changed to a controlpoint and the current number of syncpoints becomes 0 (zero).

Therefore, the maximum number of syncpoints that can occur between controlpoints is always one less than the value of the CONTROLPOINT parameter. For example, if the CONTROLPOINT parameter is set to five, then the maximum number of syncpoints is four. This parameter can be applied only to databases that have been audited.

By default, the value is 2 and it can be increased to find the best performance value. The maximum value of 4095 is not recommended for a production application unless a timely database abort recovery is a priority.

You can change the value of the CONTROLPOINT parameter while the database is active by directing a message to the database stack. Refer to the Enterprise Database Server Utilities Operations Guide for more information on how to change this parameter by using Visible DBS commands.