Kbase 8989: Changing the bi cluster size in version 6.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/1998 |
|
Changing the bi cluster size in version 6.
900824-mlb01
Date Last Modified: 10/09/90
INTRODUCTION:
=============
This Technical Support Knowledgebase entry describes how to change the
cluster size of the PROGRESS before-image (dbname.bi) file in version
6 of PROGRESS . It also corrects the PROGRESS System Administration
Guide II page 4-23 on the same subject.
WHY YOU NEED TO DO THIS:
========================
Increasing the before-image (dbname.bi) file size reduces the frequency
at which before-image writes are flushed to disk, therefore improving
performance. Be aware, however, that increasing the cluster size, makes
the before-image file use a greater amount of disk space, and takes
longer to back out the database in case of system failure.
To be able to use this PROGRESS version 6 feature since using it as
documented in the System Administration Guide II results in an error.
PROCEDURAL APPROACH:
====================
If you use the PROGRESS proutil -C bi <kilobytes> option as described
on page 4-23 of the System Administration Guide II you receive a
message to the effect that parameters are missing. This is indeed the
case. Setting the before-image (dbname.bi) cluster size can only be
done on a zero length before-image (dbname.bi) file. The utility,
therefore, expects you to use the PROGRESS proutil -C truncate bi
<dbname> option to first make the before-image (dbname.bi) file 0
bytes.
To truncate the before-image file and set the cluster size, use the
command described below:
On DOS/OS2/UNIX:
proutil dbname -C truncate bi -bi n
On VMS use:
PROGRESS/UTILITIES=TRUNCATE_BI/BI_CLUSTER_SIZE=n dbname
On BTOS/CTOS:
PROGRESS Utilities
Database Name dbname
Utility Name -C truncate bi
[Options] -bi n
Note:
In all cases n is an integer in multiples of 16 representing
kbytes up to 256MB.
ONLINE PROCEDURES OR UTILITIES:
===============================
proutil - Progress Utilities lets you truncate and set the before-image
cluster size.
REFERENCES TO WRITTEN DOCUMENTATION:
====================================
PROGRESS Version 6 System Adminstration II, page 4-23.
Progress Software Technical Support Note # 8989