What is the difference between PROSTRCT REPAIR and BUILDDB?

What is the difference between PROSTRCT REPAIR and PROSTRCT BUILDDB

PROSTRCT REPAIR: 

• REPAIR simply updates the file list of the Control Area (.db) file to reflect the new physical locations of database extents.
• It also updates the shared memory and semaphore information that previously indicated that the database was active and online. 
• Nothing else, it does not repair database integrity, a common misconception.
• It is typically used on databases that are OS copied or in a mirroring or similar 3rd Party backup strategy.

PROSTRCT BUILDDB: 

• BUILDDB completely rebuilds the Control Area (.db) from the database structure description file provided.
• It only does minimal validation of the resulting Control Area. For example, when run on replication enabled databases it is not able to fully reconstruct all the Control information needed by replication or recovery information in a blob (RCB) in the Control Area).  For further discussion refer to Article What effect does builddb have on a replication enabled database?   
• BUILDDB is typically used when the Control Area is damaged. Apart from re-creating the file list of the Control Area, it can also be used to rename Storage Areas.  Refer to Article How to change Storage Area names?   

 

References to Other Documentation: 

OpenEdge Data Management: Database Administration, PROSTRCT Utility

Progress Articles:

 How to use PROSTRCT repair? 
 Databases fail to restart after running PROSTRCT repair