Progress
Database Administration
Guide and Reference


RFUTIL ROLL FORWARD Qualifier

Reconstructs a database by applying to that database all notes stored in the after-image (AI) file. The ROLL FORWARD qualifier displays the following information:

SYNTAX

Operating System
Syntax
UNIX
Windows
rfutil db-name -C roll forward [ verbose ] 
 [    endtime yyyy:mm:dd:hh:mm:ss 
  | endtrans transaction-number 
 ] 
 [ -B  n ] [ -r ] -a ai-name  

db-name

Specifies the database you are using.

verbose

Produces information for every note in the AI area.

-a ai-name

Identifies the AI area of the specified database.

endtime

Specifies to roll forward to a certain time. You must specify the ending time as a string of digits and separate the date and time components with a colon. Transactions are included in the partial roll forward only if they end before the specified time. For example, to roll forward to 5:10 PM on July 18, 2002, type 2002:07:18:17:10:00. For Progress to include a transaction in this partial roll forward, the transaction must have ended on or before 2002:07:18:17:09:59.

endtrans

Specifies to roll forward up to but not including the transaction beginning that contains the transaction-number. For example, if you specify endtrans 1000, Progress rolls forward the AI area to transaction 999. If you want to include transaction 1000, you must specify endtrans 1001.

-B n

Specifies the number of database buffers. The single-user default value is 20.

-r

Directs Progress to use buffered I/O.

If the system crashes while you are running the ROLL FORWARD operation, restore your database files again and rerun the ROLL FORWARD operation.

The ROLL FORWARD qualifier fails if:

NOTES


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