Kbase P34008: How to use the idxmove command.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/30/2007 |
|
Status: Verified
GOAL:
How to use the idxmove command.
GOAL:
Is it possible to move the indexes from DB area to DB area?
GOAL:
Using the idxmove command
FACT(s) (Environment):
Progress 9.1
OpenEdge 10
FIX:
Moving Indexes
Use the PROUTIL IDXMOVE utility to move an index from one storage area to another. This utility can be run while the database remains online. Improved performance my be gained by moving indexes that are heavily used to an storage area on a faster disk.
Command Syntax:
proutil db-name -C idxmove [owner-name.]table-name.index-name area-name
Area name should be in quotes if it contains spaces: "Cust Index"
The PROUTIL IDXMOVE utility operates in two phases:
Phase 1: The new index is being constructed in the new area. The old index remains in the old area and all users can continue to use the index for read operations.
Phase 2: The old index is being removed and all the blocks of the old index are being removed to the free block chain. For a large index this phase can take a significant amount of time. During this phase all operations on the index are blocked until the new index is available; users accessing the index might experience a freeze in their application.
The _UserStatus virtual system table displays the utility's progress.
While the indexes can be moved online, no writes to the table or its indexes are allowed during the move. The IDXMOVE utility will acquire a SHARE lock on the table, which blocks all attempts to modify records in the table.