Kbase P80473: How to perform an index build against a database?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/7/2011 |
|
Status: Verified
GOAL:
How to perform an index build against a database?
GOAL:
When should the database's indexes be rebuilt?
GOAL:
How to rebuild database indexes?
FACT(s) (Environment):
Progress 9.1x
OpenEdge 10.x
All Supported Operating Systems
FIX:
Use the PROUTIL IDXBUILD qualifier to:
1. To pack or consolidate index records.
2. Compresses index blocks to minimize space usage.
3. Activate deactivated indexes in the database.
4. Repair corrupted indexes in the database. (Index corruption is typically signaled by error messages.)
Command Syntax: $DLC/bin/proutil -C idxbuild [ all ] all - Specifies to rebuild all indexes.
If all is not specified, the following menu appears:
Index Rebuild Utility
------------------------
Select one of the following
All - Rebuild all of the indexes
Some - Rebuild only some of the indexes
Quit - Quit, do not rebuild
Enter your selection:
Parameters:[ -T dir-name | -SS sort-file-directory-specification ]
[ -TB blocksize ] [ -TM n ] [ -B n ] [ -SG n ]
All
Prompts to verify there is enough disk space for sorting.
Some
Prompts for the indexes to rebuild and whether there is enough disk space for sorting.
Quit Quits without rebuilding any indexes.
-T dirName
Specifies the name of the directory to store the temporary files.
-SS sort-file-directory-specification
Identifies the location of a multi-volume sort file specification.
If the (-SS) parameter is used PROUTIL will not use the (-T) parameter.
-TB n
Specifies that the index rebuild will be performed using Speed Sort.
n indicates the allocated block size, in kilobytes.
-TM n
Specifies the merge number. n indicates the number of blocks or streams to be merged during the sort process.
-B n
Specifies the number of blocks in the database buffers.