Progress
Database Administration
Guide and Reference
PROQUIET Command
Stops all writes to database files by enabling a “quiet” processing point (useful for advanced backup strategies). You can also use the PROQUIET command with the bithreshold parameter to adjust the size of the recovery log threshold online. Use the PROSERVE command with the -
bithold
startup parameter to set the size of the primary recovery log threshold on startup.For more information on using database quiet points, see "Backing Up a Database," and Managing Performance."
SYNTAX
dbname
Specifies the name of the database where you are enabling or disabling a quiet processing point.
enable | disable
Enables or disables a quiet processing point. Any processes that attempt transactions while a quiet point is enabled must wait until the quiet point is disabled.
bithreshold n
Specifies the maximum size to which BI recovery files can grow, where
n
is an integer specifying the size of the threshold in MB. You can increase the size of the threshold above the current value or reduce the size to one cluster larger than the size of the recovery log file at the time the PROQUIET command is issued.NOTE: Though the above table lists theEXAMPLES-C
parameter to show the complete syntax, you do not need to use the-C
parameter in the PROQUIET syntax as PROQUIET calls-C
for you.
- Use the PROQUIET command to manage the primary recovery area (BI) threshold before your database stalls.
For example, to start a server and set a 500MB BI threshold, allowing the system to stall if that threshold is reached, use the PROSERVE command as follows:
Assume a long running transaction causes the expansion of the BI, but before the threshold is reached you receive the following message:
After receiving message 6559, you decide to increase the BI threshold to 1GB while the database remains online and investigate the cause of the unexpected BI growth before the system stalls. Use the PROQUIET command, as follows:
The above command establishes a quiet point and increase the threshold. The database does not stall.
NOTE: In practice, invoke PROQUIET commands by using a script so that they occur as quickly as possible, and with the least amount of impact to the online system.- When a database stalls because the BI threshold is reached, the stall causes an implicit quiet point and the database engine writes a message to the log file. To expand the BI threshold and continue forward processing, use the PROQUIET command with the
bithreshold
parameter only:
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |