Try OpenEdge Now
skip to main content
Database Administration
Reference : Database Startup Parameters : Alphabetical listing of database startup parameters : Table consistency check (-TableCheck)
 
Table consistency check (-TableCheck)
Operating system and syntax
UNIX / Windows
-TableCheck {
tablename |
ownername.tablename |
ownername.tablename.partitionname
}
Use with
Maximum value
Minimum value
Single-user default
Multi-user default
CC, DBS
tablename
Specifies the name of the table for consistency checking.
owner-name
Specifies the owner of the table you want to check. You must specify an owner name unless the table's name is unique within the database, or the table is owned by PUB. By default, ABL tables are owned by PUB.
partitionname
In a database with partitioned tables, specifies a named partition. Specify the composite initial partition by using initial as partitionname.
Use Table consistency check to enable consistency checking for all record blocks of the specified table (excluding BLOBS) or partition of a table. Table consistency check validates a block is still physically correct after an operation has been performed.
You can only specify one table or partition with -TableCheck. To check multiple partitions, apply consistency checking to the entire table. To check multiple tables, you must apply consistency checking to the entire database with Database consistency check (-DbCheck) or if multiple tables are in one area, you can apply consistency checking to an entire area with Area consistency check (-AreaCheck).
When specifying the table or partition to check, the following parsing rules are applied:
*If one variable is supplied, it is interpreted as a table name.
*If two variables are supplied, they are interpreted as the owner and table name (ownername.tablename).
*Three variables must be supplied to specify a table partition (ownername.tablename.partitionname).
Table consistency checking can be enabled or disabled while your database is online with PROMON. See Enable/disable block level consistency check for more information.
Table consistency check can be enabled for a single user client or for any offline utility. If the utility is read-only, such as DBANALYS, the -TableCheck parameter is ignored. Online utilities determine whether or not to perform table consistency checking during execution based on the use of -TableCheck at broker startup or by the enablement/disablement of the table consistency checking in PROMON.