Roll-Forward to a point in time

Select this radio button to have changes rolled forward to a specific date and time. If you decide not to specify a date and time, the default is the current date and time. The Next transaction to reapply field displays the date and time of the next transaction that will be reapplied by the roll-forward operation. To determine this date and time, the roll-forward status of the table space is checked. The date and time that the table space has already been rolled forward to (if any) is displayed.

Notes:

1. You can only perform a point-in-time operation on a table space if it contains all parts of all its tables.

2. In a partitioned database environment, if you want to roll forward a table space to a point in time, you must restore the table space partition at each database partition that contains a portion of the table space, and roll forward each table space partition individually to the same point in time. This ensures that the table space is consistent at each node.

• Use the Date field to specify the date to which you want to roll forward.

  You can either type the date, or you can click on the arrow to open a calendar on which you select the date. Click on the arrows at the top of the calendar to display the month that you want, then on a date to select it. The calendar closes, and the date you selected will be displayed in the field.

• Use the Time field to specify the time to which you want to roll forward. To change the time, click on the portion of the time that you want to change and either type the value that you want, or use the up and down arrows to adjust the value.

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]