Kbase P146149: Idxbuild with inactiveindexes option rebuilds all indexes for the identified table
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/08/2009 |
|
Status: Verified
SYMPTOM(s):
Idxbuild with the inactiveindexes option to idxbuild rebuilds all indexes
Command:
proutil dbname -C idxbuild table tablename inactiveindexes
Output to screen shows that all indexes within the table are rebuilt even though only a couple actually had inactive indexes
A couple of indexes were inactive.
All indexes ended up being rebuilt by the idxbuild process.
FACT(s) (Environment):
Table contains multiple indexes
Solaris
Sun Solaris SPARC 64-bit
OpenEdge 10.1C
CAUSE:
Bug# OE00184292
CAUSE:
Enhancement Request# 0000003906
CAUSE:
In 10.0B we added some additional command line options "table", "area", and "schema" for idxcheck/idxbuild. To compensate the only option "all" that we had at that time, later in 10.1A we added the options "activeindexes" and "inactiveindexes". All 5 of these options are stand alone options. These options are not currently coded to work in conjunction with each other.
FIX:
An enhancement request has been added to have these command line options work in conjunction with each other. If you are interested in this option, please vote for the enhancement # 0000003906 in the OpenEdge Enhancement Request System.
A workaround for this issue would be to reactivate the index using one of the following methods:
Online by using the command: proutil dbname -C idxactivate
For additional information on this command see solution: P149661, "What is idxactivate?"
Offliine by using the proutil command with either the idxbuild or idxfix option to reactivate the index for the specific table.
For additional information on these offline methods see solution: P16490, "How to reactivate a deactivated index when the database is offline?"