MaxWaitForQuietPoint
Integer
5
Purpose
The MaxWaitForQuietPoint parameter specifies the maximum time in seconds that the database waits for a quietpoint in the following situations.
-
Quiescing the database for a quiesced backup or changing the access mode to archive.
-
Changing the access mode of a file to read‑only by using the
-
When locking files that are about to be reorganized.
If a reorganization is audited, transactions are temporarily blocked and all files that are going to be reorganized are locked, allowing updating transactions to all files except for those that are locked.
-
Performing an SDS take-over operation.
If the performing of one of these operations does not correspond to a natural quietpoint, the MaxWaitForQuietPoint parameter specifies the maximum time in seconds that the database waits for existing transactions to complete before performing the operation after temporarily suspending new transactions from starting.
If a quietpoint is not achieved within the time specified in this parameter, a DB_QUIETPOINT_TIMEOUT exception is raised.
The minimum value is zero (0) and the maximum value is 600 seconds (10 minutes).
For more details, see "
Parameter is read when …
The database server node is initialized; for example, when you restart the database server.
Hint
The default value of zero (0) causes database operations requiring a quietpoint to fail when database transactions are in progress.
