Kbase 11438: How to speed up my roll forward
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/05/1998 |
|
How to speed up my roll forward
INTRODUCTION:
=============
This Technical Support KnowledgeBase entry suggests several techniques
for applyinh the after-image file in the most expeditious manner
possible.
WHY YOU NEED TO KNOW THIS:
==========================
Depending on the operating system, an after-image roll forward might
be extremely time consuming. The following suggestions will help you
decrease that time.
PROCEDURAL APPROACH:
====================
The after-image file contains a journal of all completed transactions.
The after-image notes record physical changes to the database at the
end of each transaction.
PROGRESS applies the after-image file record by record.
It applies the transactions in the sequence they were entered.
No validation is done.
To increase the performance of the roll forward:
1. Use the /BUFFERS or -B parameter. Set them high. Begin with 2 MB
to 5 MB, depending on how much you have available. DON'T use all
available memory.
2. Use the /NORECOVERY or -i parameter. Use the No Crash Protection
parameter.
3. Don't use the /VERBOSE option.
Using this parameter increases the time the roll foward takes
by roughly 10-20%.
4. Move the before-image file to a different disk.
Use the /BEFORE_IMAGE or -bi parameter.
5. Move the temporary files to a different disk.
Use the /TEMPORARY_FILES or -T parameter.
REFERENCES TO WRITTEN DOCUMENTATION:
====================================
System Administration II Chapter 3 and Chapter 7.
Progress Software Technical Support Note # 11438