Status: Verified
GOAL:
What is -DbCheck?
GOAL:
When should -DbCheck be used?
GOAL:
What performance overhead is expected with -DbCheck?
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.1B
FIX:
Optional startup parameters have been added to enable physical consistency checks on record and index blocks. These checks will be performed on index or record write operations only.
The checks are offered at different levels to allow flexibility
- Database level: "-DbCheck"
When this option is enabled, the consistency check will be applied to all index blocks and record blocks (except BLOB blocks) in the entire database.
- Area level: "-AreaCheck <area name>"
When this option is enabled, the consistency check will be applied to all index blocks and record blocks (except BLOB blocks) in the specified area.
- Index level: "-IndexCheck <index name>"
When this option is enabled, the consistency check will be applied to all index blocks of the specified index. This check is for index blocks only.
- Table level: "-TableCheck <table name>"
When this option is enabled, the consistency check will be applied to all record blocks (except BLOB blocks) of the specified table. This check is for record blocks only.
The following precedence rules apply when enabling multiple parameters at the same time:
1. Each option can only be enabled once. For example, the following parameters are invalid: -AreaCheck "Customer Area" -AreaCheck "Order Area"
2. If "-DbCheck" option is used with any other options, "-DbCheck" will have precedence and the consistency check will be applied on the whole database.
3. "-AreaCheck <area name>", "-IndexCheck <index name>" and "-TableCheck <table name>" can be used at the same time. The consistency check will be enabled for the superset of these options.
Syntax: Invoking runtime and roll forward physical checking
On the broker:
_mprosrv <dbname> -S 5768 -B 100000 -L 100000 -DbCheck
For a single user session:
_progres <dbname> -p info.p -DbCheck
_progres <dbname> -p info.p -AreaCheck "CustomerData"
When using proutil:
proutil <dbname> -DbCheck
During roll forward:
_rfutil dbname -C roll forward -a /vfs/work/dbname.a1 -IndexCheck "Customer.name"
_rfutil dbname -C roll forward -a /vfs/work/dbname.a1 -TableCheck "Pub.Customer"
These new options -DbCheck; -AreaCheck; -TableCheck and -IndexCheck may also be enabled for the database via the promon Administrative Functions Menu
promon <dbname>
R&D
option 4 (Administrative Functions...)
option 8 (Enable/Disable block level consistency check)
This brings up the Enable/Disable Block Consistency Check screen:
=================================================
03/11/08 OpenEdge Release 10 Monitor (R&D)
15:15:01 Enable/Disable block consistency check
This option is used to enable/disable block consistency check.
&n.bsp; Current consistency check status:
1. -MemCheck: disabled
2. -DbCheck: disabled
3. -AreaCheck: disabled
4. -IndexCheck: disabled
5. -TableCheck: disabled
Enter the option to enable/disable a consistency check:
.