Salesforce

When to use the offline PROSTRCT REORDER utility?

« Go Back

Information

 
TitleWhen to use the offline PROSTRCT REORDER utility?
URL NameP148117
Article Number000140798
EnvironmentProduct: Progress
Version: 9.1E
Product: OpenEdge
Version: 10.x, 11.x
OS: All supported platforms
Question/Problem Description
When to use the offline PROSTRCT REORDER utility to ensure AI files are available?
How does the PROSTRCT REORDER utility to ensure newly added AI files are available?
Does PROSTRCT REORDER ai have to be run offline?
 
Steps to Reproduce
Clarifying Information
Error Message
Defect Number
Enhancement Number
Cause
Resolution
Since Progress 9.1E, OpenEdge 10.0B (and later), an enhancement to the PROSTRCT utility, "prostrct reorder ai <dbname>" was added as an offline utility.  PROSTRCT reorder ai moves empty AI extents in front of the existing FULL/LOCKED extents to follow the current BUSY extent so that an AI switch order will succeed.  The RFUTIL aimage query command was also added to assist with using the 'reorder ai' utility.  

PROSTRCT REORDER can be used to recover from situations where the next AI extent in sequence is unavailable. For further detail refer to Article  This method is particularly useful in OpenEdge Replication environments when AI extents are LOCKED. For further detail refer to Articles  It is advised to upgrade to OpenEdge 10.2B before using PROSTRCT REORDER:
Workaround
Notes
References to Other Documentation:

OpenEdge Data Management: Database Administration,
  • PROSTRCT REORDER AI qualifier
  • RFUTIL AIMAGE QUERY qualifier
Keyword Phrase
Last Modified Date11/20/2020 7:07 AM

Powered by