After validating the .st file, if you have sufficient downtime, you should back up the database.

If the variable extent is empty, you must truncate the BI files of the database before you can remove the empty variable extent.

During the truncation process, OpenEdge RDBMS:

  • Performs crash recovery.

  • Uses the information in the BI files to update the database and the AI files.

  • Verifies that modified data is successfully written to disk.

  • Truncates the BI files to their original length.

  • Sets the pointer to the beginning of the BI files.

The command to truncate the BI files of a database offline is:
proutil db-name -C truncate bi
After you have validated the sports_add.st file, you can truncate the BI files of the sports database offline. Enter:
proutil sports -C truncate bi