Try OpenEdge Now
skip to main content
Programming Interfaces
Data Management : Database Access : The CONTAINS operator : Using word-break tables : Rebuilding word indexes
 
Rebuilding word indexes
For word indexing to work as expected, the word-break table ABL uses to write the word indexes (to add, modify, or delete a record that contains a word index) and the word-break table the AVM uses to read word indexes (to process a query that contains the CONTAINS operator) must be identical. To ensure this, when you associate the compiled version of a word-break table with a database, the AVM writes cyclical redundancy check (CRC) values from the compiled word-break table into the database. When you connect to the database, the AVM compares the CRC values in the database to the CRC value in the compiled version of the word-break table. If they do not match, the AVM displays an error message and terminates the connection attempt.
If a connection attempt fails and you want to avoid rebuilding the indexes, you can try associating the database with the default word-break rules.
Note: This might invalidate the word indexes and require you to rebuild them anyway.
To rebuild the indexes, you can use the PROUTIL utility with the IDXBUILD or IDXFIX qualifier.
The basic syntax of PROUTIL with the IDXBUILD qualifier is:
Operating system
Syntax
UNIX
Windows
proutil db-name -C idxbuild [ all ]
[ -T dir-name ] [ -TB blocksize ]
[ -TM n ] [ -B n ]
The basic syntax of PROUTIL with the IDXFIX qualifier is:
Operating system
Syntax
UNIX
Windows
proutil db-name -C idxfix
Both the IDXBUILD or IDXFIX qualifiers have extensive options for selecting indexes and performance tuning. For the complete syntax of the PROUTIL utility, see OpenEdge Data Management: Database Administration.