Progress
Database Administration
Guide and Reference
PROUTIL IDXBUILD Qualifier
Packs or consolidates index records to use disk space as efficiently as possible. It also:
SYNTAX
Operating System Syntax UNIXWindows proutil db-name -C idxbuild [all
]
[-T
dir-name
]
[
-TB
blocksize
]
[
-TM
n] [-B
n ]
db-name
Specifies the database you are using.
all
Specifies that you want to rebuild all your indexes. PROUTIL automatically rebuilds all your indexes without asking about disk space requirements.
If you do not specify all, the following menu appears:
The following table describes the options:
NOTES
- Use IDXFIX to repair and IDXCOMPACT to compress online.
- Use the Temporary Directory (-
T
) startup parameter to identify or redirect temporary files created by the PROUTIL utility to a specified directory when sorting and handling space issues.- Use the Speed Sort (-
TB
), Merge Number (-TM
), and Blocks in Database Buffers (-B
) startup parameters to improve index rebuild performance. For more information on these parameters, see the Progress Startup Command and Parameter Reference .- IDXBUILD does not repair corrupted data.
- Use the following formulas to determine whether you have enough free space to sort the indexes:
- If you rebuild all the indexes in your database, sorting the indexes requires free space that can be as much as 75 percent of the total database size.
- If you rebuild an individual index, sorting that index requires free space that can be the size of one index entry * the number of records in the file * 2.
- The Index Rebuild utility rebuilds an index or set of indexes in three phases:
- The utility scans the database, clearing all index blocks that belong to the indexes and rebuilds and adds those blocks to the free-block list.
- The utility scans the database file and rebuilds all the index entries for every data record. If you chose to sort the index, the utility writes the index entries to the sort file. Otherwise, the utility writes the index entries to the appropriate index at this point.
- If you indicated that you have enough space to sort the indexes, the utility sorts the index entries in the sort file into groups and enters those entries in one index at a time.
- For more information about using the IDXBUILD qualifier, see Managing Performance."
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |