Using PROQUIET to adjust the BI threshold

Database Administration

Maintaining and Monitoring Your Database : Managing Performance : Server performance factors : Before-image I/O : 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 Startupand 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 Startupand Shutdown Commands.