Kbase P49134: Should the -r parameter be used when doing a proutil bigrow?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/20/2003 |
|
Status: Unverified
GOAL:
Should the -r parameter be used when doing a proutil bigrow?
FIX:
The -r parameter is a client connection parameter and is used to enable buffered I/O to the before-image file. In most cases, avoid using this parameter because it might put database integrity at risk.
CAUTION: If you run Progress with the -r parameter and the system fails because of a system crash or power failure, the database can not be recovered. It must restored from a backup and all processing restarted from the beginning.
CAUTION: When updating a database using buffered I/O and there is a Progress system failure but no hardware failure, Progress can recover the database.
In general complete database integrity is the goal for a DBA. When additional performance is desired for tasks such as growing the bi file, the -r parameter does not guarantee complete database integrity, and offers No Crash Protection.
However, if the database is backed up at this point and one is willing to take the time hit required for a restore if the database were to crash during the bigrow process, then the -r parameter would offer an increase in performance while growing the bi file.