Kbase P118002: How to change the after-image block size
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
07/12/2010 |
|
Status: Verified
GOAL:
How to change the after-image block size
GOAL:
How to modify AI block size
GOAL:
How to set -aiblocksize
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Product Family
FIX:
As with before-imaging, the database engine reads and writes information to the AI file in blocks. Increasing the size of AI blocks lets the engine read and write more AI data at one time. This can reduce I/O rates on disks where the AI files are located. In general, the default AI block size (8K) is sufficient for systems with low transaction rates. However, if performance monitoring indicates that AI writes are a performance bottleneck and your platform?s I/O subsystem can take advantage of larger writes, increasing the AI block size might improve performance. A larger AI block size might also improve performance for roll-forward recovery processing.
To change the AI block size:
1. Use the PROSHUT command or the PROMON Shutdown a Database option to shutdown the database.
2. If after-imaging is enabled, disable it by entering the following command:
rfutil db-name -C aimage end
3. Truncate the BI file to bring the database and BI files up to date and eliminate any need for database recovery. To do this, enter the following command:
proutil db-name -C truncate bi- [ -bi size | -biblocksize size ]
Typically, if you change the AI block size, you should also change the BI block size. If you have not already, you might want to use this command to do so.
4. Change the AI block size by entering the following command:
rfutil db-name -C aimage truncate -aiblocksize size [ -a aifilename ]
For size, specify the size of the AI read and write block in kilobytes. The minimum value allowed is the size of the database block. Valid values are 0, 1, 2, 4, 8, and 16. If you specify 0, RFUTIL uses the default size (8K) for your operating system platform.
5. Perform a full backup of the database. Note: You must perform this step because backups and AI files created before you change the AI block size are no longer valid with the new AI block size.
6. Enable after-imaging by entering the following command:
rfutil db-name -C aimage begin { buffered | unbuffered } -a ai-name
7. Restart the database and continue processing.