Progress
Database Administration
Guide and Reference


Moving Indexes

Use the PROUTIL IDXMOVE utility to move an index from one application data area to another while the database remains online. You might be able to improve performance by moving indexes that are heavily used to an application data area on a faster disk. For example:

proutil db-name -C idxmove [owner-name.]indexname area-name 

NOTE: For the complete syntax description, see Database Administration Utilities."

The PROUTIL IDXMOVE utility operates in two phases:

The _UserStatus virtual system table displays the utility’s progress.

NOTE: While you can move indexes online, no writes to the table or its indexes are allowed during the move. The IDXMOVE utility acquires a SHARE lock on the table, which blocks all attempts to modify records in the table. Progress Software Corporation recommends that you run the utility during a period when the system is relatively idle, or when users are doing work that does not access the table.


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