Kbase P16016: Can idxfix be used to activate indices?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
13/03/2009 |
|
Status: Verified
GOAL:
Can idxfix be used to activate indices?
GOAL:
Can idxfix be used online to activate indices?
FACT(s) (Environment):
Progress 8.2x
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
FIX:
Yes, starting on Progress version 8.2A, the proutil option idxfix can be used to activate indices but the database has to be OFFLINE to order to allow activate the index (read below).
Perform the following steps to build an individual index or all indices (online or offline) and activate the index (offline only) using idxfix.
proutil <database name> -C idxfix
Choose option 3
You will be asked if you want to build
All
Some
Quit.
Choose some to allow specific tables to be entered.
Enter the name of table containing the index.
Enter ! to indicate input is complete. (9176)
Table name:
customer
Index name:
custnum
Enter the name of table containing the index.
Enter ! to indicate input is complete. (9176)
Table name:
!
**** The following indexes will be fixed:
Owner: PUB
Table: customer
Index: custnum
Is this correct? (y
)
y
Validate recids for index entries.
Is this correct? (y
)
y
Fix indexes on Scan.
Is this correct? (y
)
y
Provide a range of records to scan through.
Type All or the recid to start the scan at.
all
Is this correct? (y
)
y
At this point the idxfix will begin.
If the idxfix is performed when a database is online then it will build the index but not activate it. To complete the activation will require an idxfix against offline database of the same index.
The time to build the index entries is directly related to how complex the index and how many records. It may take a large amount of time if there are a lot of records.
If the idxfix was used online to build the index then the time to activate the index is usually very small - related to how many additional index changes may have occurred after the first idxfix started.