Roll-Forward Table Space -- Fields and controls

Roll-Forward page

Options page

Roll-Forward page

Roll-Forward to the end of the logs

Roll-Forward to a point in time

Overflow directory

Leave in roll-forward pending state

OK

Cancel

Show Command

Roll-Forward to the end of the logs

Select this radio button to have all changes recorded in the logs applied to the table space or table space partition. This is the default.

Note:

If you need to restore a table space partition on a specific database partition, you can perform roll-forward recovery on it to the end of the logs to bring it up to the same level as the table space on the other nodes.

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.

Overflow directory

The roll-forward operation checks for logs in the location specified by the logpath database configuration parameter. If you have moved any logs from the location specified by the logpath parameter, use the Overflow directory field to specify the path to the logs that you moved.

To display the list of available directories, click on Browse.

Leave in roll-forward pending state

Click on this check box to leave the table space or table space partition. in the roll-forward pending state at the end of the roll-forward operation. This is the default.

A table space or table space partition in the roll-forward pending state cannot be used. To turn the roll-forward pending state off and make the table space or table space partition usable, you can:

• Perform roll-forward recovery on it. You can perform roll-forward recovery on the table space from the Roll-Forward Table Space notebook.
• Select Stop Roll-Forward from the pop-up menu for the table space.
• For a table space partition:
  1. Open the Table Space Partitions window.
  2. Select the table space partition that you want
  3. Select Table Space Partitions->Stop Roll-Forward.

Options page

Process while

OK

Cancel

Show Command

Process while

Select one of the following radio buttons to specify whether the roll-forward operation is to be done online or offline.

Offline

The roll-forward operation occurs offline (that is, no other application or user can be connected to the database or to the database partition when the roll--forward operation is in progress). This is the default.

Online

The roll-forward operation occurs online: other applications and users can be connected to the database or the database partition when the roll--forward operation is in progress, but the table space or table space partition itself is not available for use.