Kbase P149661: What is idxactivate?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
22/02/2011 |
|
Status: Verified
GOAL:
What is idxactivate?
GOAL:
When was idxactivate added to OpenEdge?
GOAL:
When was idxactivate added to Progress?
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.1x
OpenEdge 10.2x
FIX:
Beginning in 10.1A a new feature was added to proutil to activate an index online.
Syntax:
proutil db-name -C idxactivate [owner-name.]table-name.index-name [useindex table-name.index-name] [recs n] [refresh t]
Prior to activating the index, IDXACTIVATE checks to make sure that there are no users with a schema timestamp that is earlier than the schema timestamp of the index.
If any such users are connected to the database, IDXACTIVATE cannot proceed but an option will be given to wait or cancelling the index activation.
If the option to wait is chosen, the proutil IDXACTIVATE will wait until all the users with an earlier schema timestamp disconnect.
During this waiting period a separate PROSHUT command could be used in a different shell session to forcibly remove the connections.
The REFRESH option specifies the number of seconds between displays of blocking users.
When IDXACTIVATE activates and builds the index, it bundles [recs n] number of records into transactions.
By default, 100 records are bundled into one transaction.
The number specified for the [recs n] value will redefine the number of records to bundle into one transaction.
Once the IDXACTIVATE command completes, the index is active and all users can access it.