Release 10.1A: OpenEdge Data Management:
Database Administration

> ## PROUTIL IDXACTIVATE qualifier

> Activates an inactive index.

> #### Syntax

>     proutil db-name -C idxactivate [owner-name.]table-name.index-name
>               [useindex table-name.index-name] [recs n] [refresh t]

> #### Parameters

> ``db-name``

> Specifies the database containing the index being activated.

> `[`owner-name.`]`table-name.index-name``

> Specifies the index being activated. You must specify the table and index names. Specify the owner name if tables in your database have more than one owner.

> ``useindex``table-name.index-name``

> Specifies an index to use to while accessing the records in your table to build the index being activated. This index must be active. If you omit this parameter, the primary index will be used.

> `recs `n``

> Specifies the number of records to process in one transaction. If you omit this parameter, IDXACTIVATE will process 100 records per transaction by default.

> `refresh `t``

> Specifies the frequency in seconds to update the display of clients that are blocking the index activation. The default refresh rate is 60 seconds. You can set it as high as 300 seconds. Connected clients with a schema timestamp earlier than the index’s schema timestamp will prevent activation of the index.

> #### Notes

> - IDXACTIVATE works for both online and offline databases.

> - If IDXACTIVATE detects clients with an earlier schema timestamp than the index, you may wait for those clients to disconnect or forcibly disconnect them with PROSHUT. The index cannot be activated until those clients are disconnected from the database.

> - You cannot activate indexes on schema or auditing tables with IDXACTIVATE.

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095