Progress
Database Administration
Guide and Reference


Control Or Primary Recovery Area Disk

The procedure you follow to recover from a full disk depends on whether the variable-length BI extent is on the full disk. Because the BI extent grows during the crash recovery phase of the Progress database startup, if the BI extent is on the full disk, you cannot start the database.

Variable-length BI Extent Is Not On the Full Disk

Follow these steps if the BI file is not on the full disk:

  1. Truncate the BI file using the PROUTIL TRUNCATE BI utility. This rolls back any transactions active at the time the database shuts down. You can also start a single-user Progress session to accomplish the same thing.
  2. Add one or more data extents to the database using the PROSTRCT ADD utility. This step is not necessary to bring the database back online. However, if you omit this step, the database will shut down when users begin adding data to it.
  3. If you have no additional disk space, you must install a new disk or delete some data from the database before you can bring the database online.

  4. Restart the database.
Variable-length BI Extent Is On the Full Disk

The BI extent grows during the crash recovery phase of the Progress database startup. If the BI extent is on the full disk, you will not be able to start the database until you make space available for the BI file to expand.

Follow these steps if you cannot remove any files on the disk containing the variable-length BI extent:

  1. Use the PROSTRCT ADD utility to add a BI extent on a disk that contains some free space. The maximum amount of additional BI space you require to recover the database is equal to that currently consumed by the BI file. If you have a disk with this much free space, then assign the new BI extent to that volume. Note that this is a worst-case space requirement and the BI file normally grows much less than this. Adding the BI extent makes the variable length extent a fixed-length extent.
  2. Start a single-user Progress session against the database. This begins database crash recovery. Exit the single-user Progress session.
  3. Restart the database.

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