Try OpenEdge Now
skip to main content
Database Administration
Maintaining and Monitoring Your Database : Managing Performance : Server performance factors : Before-image I/O : Using PROQUIET to adjust the BI threshold
 
Using PROQUIET to adjust the BI threshold
You can adjust the value of the threshold by providing a valid threshold value for the PROQUIET command on systems with an Enterprise database license. The value can be increased above the current value or reduced to a value of one cluster larger than the recovery log file size at the time the PROQUIET command is issued.
To adjust the BI threshold:
1. Use the PROQUIET command to enable a database quiet point:
proquiet db-name enable
db-name is the name of the database for which you want to adjust the BI threshold.
Note: For more information on, and complete syntax for, the PROQUIET command, see Startup and Shutdown Commands.
During a database quiet processing point, all file write activity to the database is stopped. Any processes that attempt to start a transaction while the quiet point is enabled must wait until you disable the database quiet processing point.
2. Adjust the threshold size using the -bithreshold parameter:
proquiet db-name -bithreshold n
db-name specifies the name of the database for which you want to adjust the BI threshold.
n specifies the new value for the threshold.
3. Use the PROQUIET command to disable the quiet point:
proquiet db-name disable
For more information on, and the complete syntax for, PROQUIET, see Startup and Shutdown Commands.