Online Documentation for SQL Manager for DB2

Setting restore options


This step of the wizard allows you to set the restore options.

 

Restore Database - Setting restore options

 

 

Buffer options

Use the spinner controls to specify the preferable buffer size, number of buffers, parallelism (number of buffer manipulators).

 

Final state

Specify the preferable database state after the operation:

RadioButton leave in roll forward pending state

RadioButton reset roll forward pending state after restore

 

CheckBox Online restore

Enable the option to leave connections to database alive when performing operation.

 

CheckBox Quiesce database

This option indicates whether Quiesce Database operation should be performed as well.

 

Click the Next button to proceed to Running restore.